Versions Compared

Version Old Version 18 New Version 19
Changes made by

Arjen Visser

Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

e. Logout of the database.

No Format
SQL> exit

3. By default the listener is not setup to automatically register services. Setup the listener so that it automatically supports services.

a. Stop the listener service.

No Format
lsnrctl stop
 
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.

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


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.

No Format
lsnrctl service

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

v. Setup the correct TNS alias. Edit /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

No Format
vi /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

a. Add the following to the end of the file:

No Format
TTORCL_SRC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )
TTORCL_TRG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = target-int)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )
Note

b. Test if the TNS alias is working

...

.

No Format
$ 
tnsping ttorcl_src

TNS Ping Utility for Linux: Version
11
12.
2
1.0.
2
1.0 - Production on
11
31-
JAN
JUL-2014
13
23:
39
56:
13
35
Copyright (c) 1997,
2010
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 =
orcl
pdb1)))
 

OK (0 msec)

c. Test connection to the PDB.

No Format
sqlplus oe/oe@ttorcl_src

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

4. Bring the database in archivelog mode. This is a requirement for Dbvisit Replicate.

...