Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SID name change and connections.....

520528Apr 16 2010 — edited Apr 16 2010
Oracle 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2010
Added on Apr 16 2010
4 comments
1,205 views