-bash-4.1$ oratop siltech/123456@XE
oratop: Release 13.2.4 Production on Mon Dec 8 12:26:17 2014
Copyright (c) 2011, Oracle. All rights reserved.
Processing ...
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-bash-4.1$
-bash-4.1$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2014 12:25:50
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=XE))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 08-DEC-2014 11:32:30
Uptime 0 days 0 hr. 53 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/cacti/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=XE))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.30.200)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))
The listener supports no services
The command completed successfully
-bash-4.1$
-bash-4.1$ lsnrctl servite XE
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2014 12:33:01
Copyright (c) 1991, 2011, Oracle. All rights reserved.
NL-00853: undefined command "servite". Try "help"
-bash-4.1$ lsnrctl service XE
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2014 12:33:06
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.30.200)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))
The listener supports no services
The command completed successfully
-bash-4.1$
-bash-4.1$ sqlplus siltech/123456
SQL*Plus: Release 11.2.0.2.0 Production on Mon Dec 8 12:46:02 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> show parameter service_names;
NAME TYPE VALUE
------------------------------------ ----------- ------------------
service_names string XE
SQL>
x-bash-4.1$ pwd
/u01/app/oracle/product/11.2.0/xe/network/admin
-bash-4.1$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.20.30.200 )(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
-bash-4.1$
-bash-4.1$ vim listener.ora
-bash-4.1$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.20.30.200 )(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
-bash-4.1$
-bash-4.1$ lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2014 16:33:07
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cacti.siltechconsult.com.br)(PORT=1521)))
The command completed successfully
-bash-4.1$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-DEC-2014 16:33:10
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cacti.siltechconsult.com.br)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 08-DEC-2014 16:07:07
Uptime 0 days 0 hr. 26 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/cacti/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cacti.siltechconsult.com.br)(PORT=1521)))
Services Summary...
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-bash-4.1$
-bash-4.1$ sqlplus siltech/123456@XE
SQL*Plus: Release 11.2.0.2.0 Production on Mon Dec 8 16:34:26 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL>
0 comentários:
Post a Comment