Oracle Database 12c Tutorial: What is the Net service in Oracle Database 12c?
ID: 2013081801
After the setup with tutorial How to create a pluggable database? , we check the Oracle Net service in Oracle Database 12c.
C:\Users\jiwang>lsnrctl status LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 21-AUG-2013 22:27:42 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production Start Date 20-AUG-2013 17:24:34 Uptime 1 days 5 hr. 3 min. 10 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora Listener Log File C:\app\oracle_user\diag\tnslsnr\slc03rqi\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.domain.com)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=host.domain.com)(PORT=5500)) (Security=(my_wallet_directory=C:\APP\ORACLE_USER\admin\orcl12c\xdb_wallet))(Pre sentation=HTTP)(Session=RAW)) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl12c.us.oracle.com" has 1 instance(s). Instance "orcl12c", status READY, has 1 handler(s) for this service... Service "orcl12cXDB.us.oracle.com" has 1 instance(s). Instance "orcl12c", status READY, has 1 handler(s) for this service... Service "pdborcl12c.us.oracle.com" has 1 instance(s). Instance "orcl12c", status READY, has 1 handler(s) for this service... Service "pdbdemo.us.oracle.com" has 1 instance(s). Instance "orcl12c", status READY, has 1 handler(s) for this service... The command completed successfully
From this example, you can see that each PDB has it's own NET services.
- ORCLE12c's service name: orcl12c.us.oracle.com. The orcl12cXDB is the XML DB service.
- PDBORCL12c's service name: pdborcl12c.us.oracle.com.
- PDBDEMO's service name is: pdbdemo.us.oracle.com
SQL> connect sys/welcome1@slc03rqi:1522/seed_copy.us.oracle.com as sysdba Connected. SQL> connect seedadmin/seedadmin@slc03rqi:1522/seed_copy.us.oracle.com as sysdba Connected.
Why I need to specify port number in the connection?
If the service port is not in 1521, you have to sepcify the port number in the connection.
You can change the service name if needed by updating the tnsname.ora file in $ORACLE_HOME/NETWORK/admin directory
Last Updated: 8/22/2013. Send Comments.