Database Administration (MOSC)

MOSC Banner

Changing database name

edited Sep 19, 2013 11:36PM in Database Administration (MOSC) 7 commentsAnswered

I just created a database and found out the name should be no more than 8 characters so I need to rename it.

I found the following document:
http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch14.htm

Just wanted to confirm my steps:

1) Set the environment
2) Shutdown the database
3)startup mount
4) run

nid TARGET=SYS/password@MYDBOLDNAME DBNAME=NEWNAME SETNAME=YES

SHUTDOWN IMMEDIATE


5) Convert spfileNEWNAME to initNEWNAME and set the DB_NAME initialization parameter in the initialization parameter file to the new database name.
6) Create spfile from initNEWNAME.ora file
6)Create a new password file - how do i create a new password file?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center