Hope the following definition helps! Basic connection type Host Name: Host system for the Oracle database. Port: Listener port. SID: Database name. Service Name: Network service name of the database for a remote database connection over a secure connection. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy.
Now imagine you're replicating DataGuard your database. I mean: data-wise, it's the SAME database But then how to identify the two 'versions' of your database?
Yes, it's getting confused I experienced problem using domain, and the problems disappear when not using the domain. Global Database Name is Service Name. It's that simple. There is no such catenation of identity or name. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 12 years, 3 months ago. Active 6 years, 11 months ago.
Viewed k times. Active Oldest Votes. Improve this answer. Ahmed Ashour 4, 10 10 gold badges 31 31 silver badges 47 47 bronze badges. Matthew Watson Matthew Watson I think the opposite is the case: You have one SID that is available as many services.
Will it be a problem? In an Oracle Parallel Server environment, you must set this parameter for every instance. Community Bot 1 1 1 silver badge. I'm confused. We have established that instance and database are different. Instance is the oracle program running in memory.
Database is the actual files that contain the data. An analogy would be Microsoft Word. The Word application is the "Instance". The actual document that you open is the "database" — Fabian Madurai. ORA as a better approach. Lalit Kumar B Ashish Ashish 1. The Overflow Blog.
0コメント