Home » RDBMS Server » Server Administration » difference between db_name and instance_name (RHEL5 10g 10.2.0.1.0)
difference between db_name and instance_name [message #346832] Tue, 09 September 2008 16:26 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

I have a question.

I create a database with SID orcleprod.
The instance_name is orcleprod,
but the parameter db_name is orclepro
without the letter "d".
The connection working via service name,
that is orcleprod.


SQL> select * from global_name;
GLOBAL_NAME
-----------------------------------------
ORCLEPRO.REGRESS.RDBMS.DEV.US.ORACLE.COM


There are some problem in this case?

Re: difference between db_name and instance_name [message #346834 is a reply to message #346832] Tue, 09 September 2008 16:50 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Oracle is not consistent.
  1  select table_name, column_name, data_length from dba_tab_columns
  2  where column_name = 'DB_NAME'
  3   and data_type = 'VARCHAR2'
  4* order by 1,2
SQL> /

TABLE_NAME                     COLUMN_NAME                    DATA_LENGTH
------------------------------ ------------------------------ -----------
DBA_HIST_DATABASE_INSTANCE     DB_NAME                                  9
GV_$ASM_CLIENT                 DB_NAME                                  8
GV_$LOGMNR_DICTIONARY          DB_NAME                                  9
GV_$LOGMNR_LOGFILE             DB_NAME                                  8
GV_$LOGMNR_LOGS                DB_NAME                                  8
GV_$LOGMNR_SESSION             DB_NAME                                128
LOGMNRG_DICTIONARY$            DB_NAME                                  9
LOGMNRT_DICTIONARY$            DB_NAME                                  9
LOGMNR_DICTIONARY$             DB_NAME                                  9
MGMT$RACDB_INTERCONNECTS       DB_NAME                               1024
V_$ASM_CLIENT                  DB_NAME                                  8
V_$LOGMNR_DICTIONARY           DB_NAME                                  9
V_$LOGMNR_LOGFILE              DB_NAME                                  8
V_$LOGMNR_LOGS                 DB_NAME                                  8
V_$LOGMNR_SESSION              DB_NAME                                128
WRM$_DATABASE_INSTANCE         DB_NAME                                  9


IIRC, supposedly SID is limited to 8 characters!
Re: difference between db_name and instance_name [message #346865 is a reply to message #346832] Tue, 09 September 2008 23:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
difference between db_name and instance_name

Database name: name of the database.
Instance name: name of the instance.

Database Concepts
Glossary
database
Collection of data that is treated as a unit. The purpose of a database is to store and retrieve related information.

instance
A system global area (SGA) and the Oracle background processes constitute an Oracle database instance. Every time a database is started, a system global area is allocated and Oracle background processes are started. The SGA is deallocated when the instance shuts down.

See Also: background process, system global area (SGA), Automatic Storage Management instance


Database Reference
DB_NAME
Quote:
DB_NAME specifies a database identifier of up to 8 characters.

Regards
Michel
Re: difference between db_name and instance_name [message #347644 is a reply to message #346832] Fri, 12 September 2008 09:17 Go to previous message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

so, there isn't problem in this case.
I have only one database in this server.

thanks,
Marcos Santos
Previous Topic: base line for new object
Next Topic: a 12 gb ram database server
Goto Forum:
  


Current Time: Wed Dec 07 06:43:57 CST 2016

Total time taken to generate the page: 0.06490 seconds