oracle 11G 配置侦听文件
lsnrctl status
130 2017-08-23 03:15:16 oracle cat /etc/hosts
131 2017-08-23 03:15:26 oracle cat /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
132 2017-08-23 03:15:43 oracle ps -ef |grep smon
133 2017-08-23 03:15:56 oracle vi /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
134 2017-08-23 03:16:55 oracle lsnrctl status
135 2017-08-23 03:17:00 oracle lsnrctl start
Last login: Wed Aug 23 02:44:37 2017 from 172.16.4.180
[chroot@DSPTDB04 ~]$ su -
Password:
[root@DSPTDB04 ~]# vi /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = payment)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSPTDB04)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora" 20L, 501C
[root@DSPTDB04 ~]# su - oracle
-bash: ulimit: open files: cannot modify limit: Operation not permitted
-bash: /home/oracle/.bash_profile: line 35: syntax error: unexpected end of file
[oracle@DSPTDB04 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 23-AUG-2017 03:20:55
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSPTDB04)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 22-AUG-2017 23:13:04
Uptime 0 days 4 hr. 7 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSPTDB04)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@DSPTDB04 ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 23-AUG-2017 03:21:06
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
[oracle@DSPTDB04 ~]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 23-AUG-2017 03:21:16
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSPTDB04)(PORT=1521)))
The command completed successfully
[oracle@DSPTDB04 ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 23-AUG-2017 03:21:24
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSPTDB04)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSPTDB04)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 23-AUG-2017 03:21:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSPTDB04)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "payment" has 1 instance(s).
Instance "payment", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@DSPTDB04 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 23-AUG-2017 03:21:32
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSPTDB04)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 23-AUG-2017 03:21:24
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSPTDB04)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "payment" has 1 instance(s).
Instance "payment", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@DSPTDB04 ~]$
