Changing database name
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?