|
|
|
|
| Re: what are steps to change database name on oracle 9i on linux [message #354515 is a reply to message #354431] |
Mon, 20 October 2008 02:49   |
ora110
Messages: 42
Registered: September 2007
Location: China
|
Member |
|
|
1. Backup the database
2. SHUTDOWN IMMEDIATE of the database
3. STARTUP MOUNT
4. Open one session and run NID with sysdba privileges
% nid TARGET=SYS/password@test_db DBNAME=test_db2 SETNAME=Y
- the value of DBNAME is the new dbname of the database
- SETNAME must be set to Y. The default is N and causes the
DBID to be changed also.
5. shutdown IMMEDIATE of the database
6. Set the DB_NAME initialization parameter in the initialization parameter
file to the new database name
7. Create a new password file
8. Startup of the database(without resetlogs)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
