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
- 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.
Answer: If the service port is not in 1521, you have to specify 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