Home » RDBMS Server » Server Administration » what are steps to change database name on oracle 9i on linux (oracle 9i linux)
what are steps to change database name on oracle 9i on linux [message #354431] Sat, 18 October 2008 22:01 Go to next message
newbiedb
Messages: 1
Registered: October 2008
Junior Member
what are steps to change database name on oracle 9i on linux
Re: what are steps to change database name on oracle 9i on linux [message #354435 is a reply to message #354431] Sat, 18 October 2008 22:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can use DBNEWID.
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 Go to previous messageGo to next message
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)
Re: what are steps to change database name on oracle 9i on linux [message #354535 is a reply to message #354515] Mon, 20 October 2008 03:47 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why are you just repeating (with less details) what is in the link have been posted?

Regards
Michel
Previous Topic: How to generate "Create tablespace statement"
Next Topic: create table space
Goto Forum:
  


Current Time: Sun Dec 04 06:55:06 CST 2016

Total time taken to generate the page: 0.09827 seconds