Переименую базу в primary (исключительно для удобства) на сервере.

1)

$ rman target /
RMAN> backup full database noexclude include current controlfile spfile;
RMAN> quit;

2)

$ sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup mount;


SQL> create pfile='/u01/app/oracle/product/11.2/dbs/initprimary.ora' from spfile;

SQL> quit


$ nid TARGET=sys/master dbname=primary SETNAME=Y logfile=/u01/oradata/nid.log


$ cat /u01/oradata/nid.log


DBNEWID: Release 11.2.0.2.0 - Production on Fri May 6 20:54:10 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to database ORA112 (DBID=272513945)

Connected to server version 11.2.0

Control Files in database:
    /u02/oradata/ora112/control01.ctl
    /u03/oradata/ora112/control01.ctl

Changing database name from ORA112 to PRIMARY
    Control File /u02/oradata/ora112/control01.ctl - modified
    Control File /u03/oradata/ora112/control01.ctl - modified
    Datafile /u02/oradata/ora112/system01.db - wrote new name
    Datafile /u02/oradata/ora112/sysaux01.db - wrote new name
    Datafile /u02/oradata/ora112/undotbs01.db - wrote new name
    Datafile /u02/oradata/ora112/users01.db - wrote new name
    Datafile /u02/oradata/ora112/temp01.db - wrote new name
    Control File /u02/oradata/ora112/control01.ctl - wrote new name
    Control File /u03/oradata/ora112/control01.ctl - wrote new name
    Instance shut down

Database name changed to PRIMARY.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.
[oracle11@oracle11 ~]$ cd /u01/app/oracle/product/11.2/dbs/
[oracle11@oracle11 dbs]$ orapwd file=orapwprimary password=master entries=1


vi /u01/app/oracle/product/11.2/dbs/initprimary.ora


*.db_name='primary'


$ vi ~/.bash_profile

ORACLE_SID=primary
ORACLE_UNQNAME=primary


$ source ~/.bash_profile


$ sqlplus / as sysdba


SQL> startup


SQL> create spfile from pfile='/u01/app/oracle/product/11.2/dbs/initprimary.ora';


SQL> select name from v$database;

NAME
---------
PRIMARY


SQL> shutdown immediate;
SQL> startup;

Необходимо, чтобы сервер был стартован из spfile

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';


Init F
------
SPFILE


# vi /etc/oratab
primary:/u01/app/oracle/product/11.2:Y