Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change DB ORCL to DBS fail

650105Dec 23 2008 — edited Dec 23 2008
hey 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
This post has been answered by OrionNet on Dec 23 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2009
Added on Dec 23 2008
15 comments
963 views