One characteristic of an rdbms is the independence of physical data storage from logical data structures. With this architecture, each new system can be rapidly provisioned from the pool of components. I sort of got to the solution by grepping for our domain name in the system01. Upgrade oracle9i 10g 11g oca to oracle database 12c ocp latest braindumps pdf kwarastate. 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. The database is created by someone else and hence i wants to know it. 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. Global database names uniquely identify a database in the system. I wants to find global database name of database say mydb. Part i basic database administration 1 overview of administering an oracle database.
Usually, the database domain is the same as the network domain, but it need not be. 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. Can someone explain to me whats the difference of sid, db name, db domain, global database name, service name, service alias and instance name in oracle. Oracle difference between sid, db name, db domain, global. Oracle database 10g is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. In oracle database, a database schema is a collection of logical data structures, or schema objects.
1125 732 700 919 31 832 1206 516 2 1187 762 1034 1434 1259 876 1173 1120 910 1010 754 1172 26 987 380 319 668 504 820 75 1462 1127 28