Change DB ORCL to DBS fail
650105Dec 23 2008 — edited Dec 23 2008hey i'm trying to change the ORCL to DBS fr this purpose i used ORINET post and read note from metalink my setps are
C:\Documents and Settings\adeel>set ORACLE_SID=orcl
C:\Documents and Settings\adeel>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 23 10:09:13 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN
SQL> create pfile='e:\oracle\product\10.2.0\ods\admin\pfile\initorcl.ora' from s
pfile;
File created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount pfile='e:\oracle\product\10.2.0\ods\admin\pfile\initorcl.ora'
;
ORACLE instance started.
Total System Global Area 574619648 bytes
Fixed Size 1250236 bytes
Variable Size 188746820 bytes
Database Buffers 381681664 bytes
Redo Buffers 2940928 bytes
Database mounted.
afterward i open new cmd from RUN and do this and got this error
Open a new cmd session from Start-> Run -> cmd
C:>nid TARGET=sys/whateveryourpassword@orcl DBNAME=ODS SETNAME=Y
DBNEWID: Release 10.2.0.1.0 - Production on Tue Dec 23 10:13:43 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to database ORCL (DBID=1197180666)
Connected to server version 10.2.0
Control Files in database:
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
Change database name of database ORCL to ODS? (Y/[N]) => Y
Proceeding with operation
Changing database name from ORCL to ODS
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL - modified
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL - modified
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL - modified
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF - wrote new name
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF - wrote new nam
e
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF - wrote new name
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF - wrote new name
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF - wrote new nam
e
Datafile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYTEM02.DBF - wrote new name
Datafile E:\ADEEL_DG0_PK_IND_0.DBF - wrote new name
Datafile E:\ADEEL_DG0_PK_IND_1.DBF - wrote new name
Datafile E:\ADEEL_DG0_INDEXES_0.DBF - wrote new name
Datafile E:\ADEEL_DG0_INDEXES_1.DBF - wrote new name
Datafile E:\ADEEL_DG0_DATA_0.DBF - wrote new name
Datafile E:\ADEEL_DG0_DATA_1.DBF - wrote new name
Datafile E:\ADEEL_JT_PK_IND_0.DBF - wrote new name
Datafile E:\ADEEL_JT_PK_IND_1.DBF - wrote new name
Datafile E:\ADEEL_JT_INDEXES_0.DBF - wrote new name
Datafile E:\ADEEL_JT_INDEXES_1.DBF - wrote new name
Datafile E:\ADEEL_JT_DATA_0.DBF - wrote new name
Datafile E:\ADEEL_JT_DATA_1.DBF - wrote new name
Datafile E:\FAHEEM_DG0_PK_IND_0.DBF - wrote new name
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL - wrote new
name
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL - wrote new
name
Control File E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL - wrote new
name
Instance shut down
Database name changed to ODS.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.
C:\>oradim -DELETE -SID orcl
Instance deleted.
C:\>oradim -new -sid ODS -intpwd mypassword -startmode AUTO -pfile 'e:\oracle\pr
oduct\10.2.0\admin\ODS\initorcl.ora'
Instance created.
C:\>set ORACLE_SID=ODS
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 23 10:16:44 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount pfile='e:\oracle\product\10.2.0\admin\ODS\pfile\initorcl.ora'
;
LRM-00109: could not open parameter file 'e:\oracle\product\10.2.0\admin\ODS\pfi
le\initorcl.ora'
ORA-01078: failure in processing system parameters
how to resolve this