SID name change and connections.....
520528Apr 16 2010 — edited Apr 16 2010Oracle 10g R2
Oracle doc says "For a client application and a database to communicate, the client application must be able to identify the database it wants to connect to, and the database must provide some sort of identification or address. You can use a service name to connect to a database. A service name is a logical representation of a database, which is the way a database is presented to clients. A single database can be presented as multiple services"
I want to rename the SID name from ORCL_DEV to ORCLDEV.
Content of my listner.ora is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL_TEST.SERVERNAME)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = ORCL_TEST)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL_DEV.SERVERNAME)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = ORCL_DEV)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL_MIGRATE.SERVERNAME)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = MIGRATE)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PHC4440)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
After renaming the ORACLE_SID what are all the places I need to change the settings so that the programs around it needs zero or less modification.
Thank you,
Smith