1. Logon as the oracle user.
...
Once the VM has been restarted, logon as the oracle user.
| No Format |
|---|
su - oracle |
| Note | ||
|---|---|---|
It is now possible to connect externally with Putty or a terminal emulator to the VM (source) with the following command:
This uses port forwarding which was setup when Virtual Box was configured (02 - Set up NAT network in Virtual Box). 192.168.1.197 is the IP address of the host machine (laptop). Use ifconfig or ipconfig to identify what the local IP address is of your host machine. |
2. Setup the OE schema in the database.
a. By default the TWO_TASK is set to the PDB. Unset the TWO_TASK to connect to the CDB.
| No Format |
|---|
[oracle@source ~]$ echo $TWO_TASK pdb1 [oracle@source ~]$ pdb1 unset TWO_TASK |
b. Logon to the database (CDB) as sysdba.
| No Format |
|---|
[oracle@source ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 31 23:25:18 2014
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> |
...
a. Stop the listener service.
| No Format |
|---|
lsnrctl stop
|
| 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 |
b. Rename the current listener.ora file so that this file is no longer used. We want the default Listener configuration.
| No Format |
|---|
cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin mv listener.ora _listener.ora |
c. Start the listener again.
| No Format |
|---|
lsnrctl start
|
| 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 service
|
| 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 |
|---|
CDB$ROOT@ORCL> startup mount; |
| 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. |
d. Turn on archivelog mode.
| No Format |
|---|
CDB$ROOT@ORCL> alter database archivelog; |
| No Format |
|---|
Database altered. |
e. Open the database.
| No Format |
|---|
CDB$ROOT@ORCL> alter database open; |
| No Format |
|---|
Database altered. |
f. Check the archivelog mode.
| No Format |
|---|
CDB$ROOT@ORCL> 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 |
g. Logout of the database.
| No Format |
|---|
SQL> exit |
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
| No Format |
|---|
su - |
b. Create an archive management script named del_arch.sh that will manage the archives.
...
d. Make the script executable and change ownership to oracle.
| No Format |
|---|
[root@source bin]# chmod 750 /usr/local/bin/del_arch.sh |
| No Format |
|---|
[root@source bin]# chown oracle:dba /usr/local/bin/del_arch.sh |
| No Format |
[root@source bin]# exit |
e. As user oracle, add the script to the oracle crontab.
...