login as: oracle
Using keyboard-interactive authentication.
Password:
Last login: Mon Jan 12 13:09:43 2015 from 192.168.68.38
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$
$
$ bash
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:18:19 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
NMS MOUNTED
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:20:12 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database open;
Database altered.
SQL> alter user sys identified by sys;
User altered.
SQL> conn sys/sys as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:21:02 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:21:50 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ nid target =/ dbname=nms1
DBNEWID: Release 10.2.0.2.0 - Production on Mon Jan 12 14:22:22 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to database NMS (DBID=2769379598)
Connected to server version 10.2.0
Control Files in database:
/opt/oracle/oradata/NMS/control01.ctl
/opt/oracle/oradata/NMS/control02.ctl
/opt/oracle/oradata/NMS/control03.ctl
Change database ID and database name NMS to NMS1? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 2769379598 to 858488030
Changing database name from NMS to NMS1
Control File /opt/oracle/oradata/NMS/control01.ctl - modified
Control File /opt/oracle/oradata/NMS/control02.ctl - modified
Control File /opt/oracle/oradata/NMS/control03.ctl - modified
Datafile /opt/oracle/oradata/NMS/system01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/undotbs01.dbf - dbid changed, wrote new nam
Datafile /opt/oracle/oradata/NMS/sysaux01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/users01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/example01.dbf - dbid changed, wrote new nam
Datafile /opt/oracle/oradata/NMS/temp01.dbf - dbid changed, wrote new name
Control File /opt/oracle/oradata/NMS/control01.ctl - dbid changed, wrote new
Control File /opt/oracle/oradata/NMS/control02.ctl - dbid changed, wrote new
Control File /opt/oracle/oradata/NMS/control03.ctl - dbid changed, wrote new
Instance shut down
Database name changed to NMS1.
Modify parameter file and generate a new password file before restarting.
Database ID for database NMS1 changed to 858488030.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:23:07 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
Disconnected
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$ su - oracle
Password:
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$
$
$ bash
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:24:03 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
ORA-01103: database name 'NMS1' in control file is not 'NMS'
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:24:44 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:25:00 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
SQL> exit
Disconnected
bash-3.00$
bash-3.00$
bash-3.00$ export ORACLE_SID=NMS1
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:26:42 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount pfile='/opt/oracle/admin/NMS/pfile/init.ora.112520141420'
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string NMS1
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS;
Database altered.
SQL> SQL>
Using keyboard-interactive authentication.
Password:
Last login: Mon Jan 12 13:09:43 2015 from 192.168.68.38
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$
$
$ bash
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:18:19 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
NMS MOUNTED
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:20:12 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database open;
Database altered.
SQL> alter user sys identified by sys;
User altered.
SQL> conn sys/sys as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:21:02 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:21:50 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ nid target =/ dbname=nms1
DBNEWID: Release 10.2.0.2.0 - Production on Mon Jan 12 14:22:22 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to database NMS (DBID=2769379598)
Connected to server version 10.2.0
Control Files in database:
/opt/oracle/oradata/NMS/control01.ctl
/opt/oracle/oradata/NMS/control02.ctl
/opt/oracle/oradata/NMS/control03.ctl
Change database ID and database name NMS to NMS1? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 2769379598 to 858488030
Changing database name from NMS to NMS1
Control File /opt/oracle/oradata/NMS/control01.ctl - modified
Control File /opt/oracle/oradata/NMS/control02.ctl - modified
Control File /opt/oracle/oradata/NMS/control03.ctl - modified
Datafile /opt/oracle/oradata/NMS/system01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/undotbs01.dbf - dbid changed, wrote new nam
Datafile /opt/oracle/oradata/NMS/sysaux01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/users01.dbf - dbid changed, wrote new name
Datafile /opt/oracle/oradata/NMS/example01.dbf - dbid changed, wrote new nam
Datafile /opt/oracle/oradata/NMS/temp01.dbf - dbid changed, wrote new name
Control File /opt/oracle/oradata/NMS/control01.ctl - dbid changed, wrote new
Control File /opt/oracle/oradata/NMS/control02.ctl - dbid changed, wrote new
Control File /opt/oracle/oradata/NMS/control03.ctl - dbid changed, wrote new
Instance shut down
Database name changed to NMS1.
Modify parameter file and generate a new password file before restarting.
Database ID for database NMS1 changed to 858488030.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:23:07 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
Disconnected
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$
bash-3.00$ su - oracle
Password:
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$
$
$ bash
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:24:03 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
ORA-01103: database name 'NMS1' in control file is not 'NMS'
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:24:44 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:25:00 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
SQL> exit
Disconnected
bash-3.00$
bash-3.00$
bash-3.00$ export ORACLE_SID=NMS1
bash-3.00$
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 14:26:42 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount pfile='/opt/oracle/admin/NMS/pfile/init.ora.112520141420'
ORACLE instance started.
Total System Global Area 595591168 bytes
Fixed Size 1281576 bytes
Variable Size 163578328 bytes
Database Buffers 427819008 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL>
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string NMS1
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS;
Database altered.
SQL> SQL>
