...
a. Stop the listener service.
| No Format |
|---|
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-JUL-2014
23:49:54
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully |
...
c. Start the listener again.
| No Format |
|---|
LSNRCTL for Linux: Version 12.1.0.1.0 - Production
on 31-JUL-2014 23:50:05
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/source/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 31-JUL-2014 23:50:05
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/source/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=1521)))
The listener supports no services
The command completed successfully |
d. Check the listener services. It may take several minutes for the services to start and appear.
| No Format |
|---|
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-JUL-2014
23:50:18
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: source, pid: 3347>
(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=55291))
Service "pdb1" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully |
...
| No Format |
|---|
tnsping ttorcl_src
|
| No Format |
|---|
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 31-JUL-2014 23:56:35
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1)))
OK (0 msec) |
...
| No Format |
|---|
sqlplus oe/oe@ttorcl_src
|
| No Format |
|---|
SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 31 23:57:41 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Thu Jul 31 2014 23:50:31 -04:00
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
PDB1@ORCL> exit |
...
a. By default the TWO_TASK is set to the PDB. Unset the TWO_TASK to connect to the CDB.
| No Format |
|---|
[oracle@source ~]$ unset TWO_TASK |
| Note |
|---|
Unsetting of TWO_TASK was already done in a previous step so it is not strictly needed. |
b. Shutdown the database.
| No Format |
|---|
sqlplus / as sysdba
|
| No Format |
|---|
CDB$ROOT@ORCL> shutdown immediate; |
c. Start up the database in no mount mode.
| No Format |
|---|
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2289016 bytes
Variable Size 322962056 bytes
Database Buffers 79691776 bytes
Redo Buffers 8429568 bytes
Database mounted. |
...
| No Format |
|---|
alter database archivelog;
|
| No Format |
|---|
Database altered. |
e. Open the database.
| No Format |
|---|
alter database open;
|
| No Format |
|---|
Database altered. |
f. Check the archivelog mode.
| No Format |
|---|
archive log list
|
| No Format |
|---|
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 104
Next log sequence to archive 106
Current log sequence 106 |
...
6. Ensure the archive log files are managed and not filling up and stopping the database. Install a script that manages the archive logs.
a. Logon as root. The password is oracle
b. Create an archive management script named del_arch.sh that will manage the archives.
...