In order to restart CDB we need to log in as common user which has perviliege to perform this operation and second thing is you need to connect without tns names.
This is done using unsetting the TWO_TASK variable. Below is how I would do it.
[oracle@localhost harvey]$ echo $TWO_TASK
[oracle@localhost harvey]$ sqlplus "/ as sysdba"
set pages 10000 lines 270 long 10000
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jan 6 23:01:07 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
CDB$ROOT@ORCL> CDB$ROOT@ORCL>
CDB$ROOT@ORCL>
CDB$ROOT@ORCL> show con_name
CON_NAME
------------------------------
CDB$ROOT
CDB$ROOT@ORCL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
CDB$ROOT@ORCL>
CDB$ROOT@ORCL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@localhost harvey]$
[oracle@localhost harvey]$
[oracle@localhost harvey]$ ps -ef | grep smon
oracle 11602 32410 0 23:01 pts/2 00:00:00 grep smon
[oracle@localhost harvey]$ sqlplus "/ as sysdba"
set pages 10000 lines 270 long 10000
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jan 6 23:02:03 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
idle> idle>
idle> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2289016 bytes
Variable Size 335544968 bytes
Database Buffers 71303168 bytes
Redo Buffers 4235264 bytes
Database mounted.
Database opened.
idle> show user
USER is "SYS"
idle>
[oracle@localhost harvey]$ ps -ef | grep smon
oracle 11634 1 0 23:02 ? 00:00:00 ora_smon_orcl
oracle 11762 32410 0 23:05 pts/2 00:00:00 grep smon
[oracle@localhost harvey]$
No comments:
Post a Comment