The global database name uniquely distinguishes a database from any other database in the same network. The oracle database 11g software identifies a database by its global database name. How to get sid, service name and port for oracle database. Upgrade oracle9i 10g 11g oca to oracle database 12c ocp latest braindumps pdf kwarastate. Enterprise grid computing creates large pools of industrystandard, modular storage and servers. One characteristic of an rdbms is the independence of physical data storage from logical data structures. If you use or plan to use distributed processing, then oracle recommends that you set this parameter to true to ensure the use of consistent naming conventions for databases and links in a networked environment. Oracle database 10g is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. It is a stand alone db without db links or connections from other dbs so the change is ok db version oracle 10g message was edited by. A database user owns a database schema, which has the same name as the user name schema objects are usercreated structures that directly refer to the data in the database. Managing global names in a distributed system oracle. The database is created by someone else and hence i wants to know it. A primary administration task in a distributed system is managing the creation and alteration of global database names.
It is used in a distributed database to enforce uniqueness across all databases so there is no confusion as to which database is what. I sort of got to the solution by grepping for our domain name in the system01. Oracle difference between sid, db name, db domain, global. I wants to find global database name of database say mydb. Usually, the database domain is the same as the network domain, but it need not be.
With this architecture, each new system can be rapidly provisioned from the pool of components. A global database name consists of the database name and database domain. In a distributed database system, each database should have a unique global database name. I am trying to set up new connection in oracle sql developer so i can access this database. In oracle database, a database schema is a collection of logical data structures, or schema objects.