oracle listener

[url]http://blog.chinaunix.net/xmlrpc.php?[/url]r=blog/article&uid=25892360&id=3560136.aud
orcl12c_ora_4820_20170223183359917418143795.aud
orcl12c_ora_4826_20170223183400121338143795.aud
orcl12c_ora_4831_20170223183400171495143795.aud
orcl12c_ora_4832_20170223183400317572143795.aud
orcl12c_ora_4833_20170223183400338426143795.aud
orcl12c_ora_4834_20170223183400552930143795.aud
orcl12c_ora_4839_20170223183401410679143795.aud
orcl12c_ora_4846_20170223183401535751143795.aud
orcl12c_ora_4850_20170223183401586070143795.aud
orcl12c_ora_4854_20170223183401635603143795.aud
orcl12c_ora_4858_20170223183401693037143795.aud
orcl12c_ora_4862_20170223183401748829143795.aud
orcl12c_ora_4866_20170223183401794856143795.aud
orcl12c_ora_4872_20170223183401987662143795.aud
orcl12c_ora_4878_20170223183402032152143795.aud
orcl12c_ora_4884_20170223183402127043143795.aud
orcl12c_ora_4889_20170223183402177328143795.aud
orcl12c_ora_4890_20170223183402307552143795.aud
orcl12c_ora_4897_20170223183402380403143795.aud
orcl12c_ora_4901_20170223183402425255143795.aud
orcl12c_ora_4905_20170223183402469744143795.aud
orcl12c_ora_4909_20170223183402514365143795.aud
orcl12c_ora_4913_20170223183402568063143795.aud
orcl12c_ora_4917_20170223183402649079143795.aud
orcl12c_ora_4932_20170223183436613935143795.aud
orcl12c_ora_4938_20170223183436736444143795.aud
orcl12c_ora_4957_20170223183503547108143795.aud
orcl12c_ora_4971_20170223183616323608143795.aud
orcl12c_ora_4973_20170223183640499759143795.aud
orcl12c_ora_4973_20170223183654318191143795.aud
orcl12c_ora_5032_20170223183654358854143795.aud
orcl12c_ora_5041_20170223183659167472143795.aud
orcl12c_ora_5060_20170223183701210936143795.aud
orcl12c_ora_5203_20170223183702558756143795.aud
orcl12c_ora_5204_20170223183702640490143795.aud
orcl12c_ora_5209_20170223183702825894143795.aud
orcl12c_ora_5210_20170223183702865184143795.aud
orcl12c_ora_5211_20170223183702915101143795.aud
orcl12c_ora_5217_20170223183703125028143795.aud
orcl12c_ora_5219_20170223183703146705143795.aud
orcl12c_ora_5220_20170223183703172055143795.aud
orcl12c_ora_5221_20170223183704033388143795.aud
orcl12c_ora_5222_20170223183704328561143795.aud
orcl12c_ora_5293_20170223183801457389143795.aud
orcl12c_ora_5294_20170223183801505675143795.aud
orcl12c_ora_5295_20170223183801555080143795.aud
orcl12c_ora_5297_20170223183801749462143795.aud
orcl12c_ora_5298_20170223183801791405143795.aud
orcl12c_ora_5299_20170223183801841084143795.aud
orcl12c_ora_5300_20170223183802252875143795.aud
orcl12c_ora_5301_20170223183821193350143795.aud
orcl12c_ora_5304_20170223183830332576143795.aud
orcl12c_ora_5313_20170223183844831731143795.aud
orcl12c_ora_5314_20170223183845275192143795.aud
orcl12c_ora_5319_20170223183845526382143795.aud
orcl12c_ora_5326_20170223183845721503143795.aud
orcl12c_ora_5330_20170223183845821932143795.aud
orcl12c_ora_5334_20170223183845902198143795.aud
orcl12c_ora_5338_20170223183845982140143795.aud
orcl12c_ora_5342_20170223183846053811143795.aud
orcl12c_ora_5346_20170223183846146789143795.aud
orcl12c_ora_5362_20170223183906939076143795.aud
orcl12c_ora_5368_20170223183907031490143795.aud
orcl12c_ora_5372_20170223183907116028143795.aud
orcl12c_ora_5425_20170223234742778055143795.aud
orcl12c_ora_5425_20170223234818419696143795.aud
orcl12c_ora_5434_20170223183957936801143795.aud
orcl12c_ora_5440_20170223183958066275143795.aud
orcl12c_ora_5448_20170223184003011603143795.aud
orcl12c_ora_5449_20170223184003040625143795.aud
orcl12c_ora_5485_20170223234818501749143795.aud
orcl12c_ora_5494_20170223234825227658143795.aud
orcl12c_ora_5514_20170223184224542454143795.aud
orcl12c_ora_5870_20170223234926018907143795.aud
orcl12c_ora_7407_20170223194210137919143795.aud
# cd ..
# ls
adump dpdump pfile xdb_wallet
# cd ..
# ls
orcl12c
# cd ..
# ls
admin audit cfgtoollogs checkpoints db1 diag fast_recovery_area oradata
# cd ..
# ls
12c oraInventory tablespaces
# cd ..
# ls
bin dev lib media net proc selinux sys var
boot etc lib64 misc opt root srv tmp
cgroup home lost+found mnt oracle sbin ss usr
# cd /oracle/12c/db1/
# ls
addnode dbs javavm odbc precomp sqlpatch
apex dc_ocm jdbc olap QOpatch sqlplus
assistants deinstall jdk OPatch R srvm
bin demo jlib opmn racg suptools
ccr diagnostics ldap oracore rdbms sysman
cdata dmu lib oraInst.loc relnotes ucp
cfgtoollogs dv log ord rest usm
clone has md oui root.sh utl
crs hs mgw owm scheduler wwg
css install network perl slax xdk
ctx instantclient nls plsql sqldeveloper
cv inventory oc4j plugins sqlj
# cd network/
# ls
admin install jlib lib log mesg tools trace
# cd admin
# ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
# vi listener.ora
# vi listener.ora
# netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:45232 0.0.0.0:* LISTEN
tcp 0 0 192.168.122.1:53 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.123:36132 23.34.61.10:80 ESTABLISHED
tcp 0 1 192.168.0.123:36070 23.34.61.10:80 FIN_WAIT1
tcp 0 0 :::35070 :::* LISTEN
tcp 0 0 :::111 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 :::44343 :::* LISTEN
tcp 0 0 ::1:631 :::* LISTEN
tcp 0 0 ::1:25 :::* LISTEN
# netstat -nat|grep 1521
#
# su - oracle
[oracle@oracledb ~]$ cd /oracle/
12c/ oraInventory/ tablespaces/
[oracle@oracledb ~]$ cd /oracle/12c/
admin/ checkpoints/ fast_recovery_area/
audit/ db1/ oradata/
cfgtoollogs/ diag/
[oracle@oracledb ~]$ cd /oracle/12c/db1/
addnode/ deinstall/ ldap/ ord/ scheduler/
apex/ demo/ lib/ oui/ slax/
assistants/ diagnostics/ log/ owm/ sqldeveloper/
bin/ dmu/ md/ perl/ sqlj/
ccr/ dv/ mgw/ plsql/ sqlpatch/
cdata/ has/ network/ plugins/ sqlplus/
cfgtoollogs/ hs/ nls/ precomp/ srvm/
clone/ install/ oc4j/ QOpatch/ suptools/
crs/ instantclient/ odbc/ R/ sysman/
css/ inventory/ olap/ racg/ ucp/
ctx/ javavm/ OPatch/ rdbms/ usm/
cv/ jdbc/ opmn/ relnotes/ utl/
dbs/ jdk/ oracore/ rest/ wwg/
dc_ocm/ jlib/ oraInst.loc root.sh xdk/
[oracle@oracledb ~]$ cd /oracle/12c/db1/bin/
[oracle@oracledb bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-FEB-2017 13:36:15

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Starting /oracle/12c/db1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oracle/12c/db1/network/admin/listener.ora
Log messages written to /oracle/12c/diag/tnslsnr/oracledb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 27-FEB-2017 13:36:17
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/12c/db1/network/admin/listener.ora
Listener Log File /oracle/12c/diag/tnslsnr/oracledb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@oracledb bin]$
[oracle@oracledb bin]$ ifconfig
eth0 Link encap:Ethernet HWaddr 08:60:6E:1E:C5:82
UP BROADCAST MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:481 errors:0 dropped:0 overruns:0 frame:0
TX packets:481 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:30093 (29.3 KiB) TX bytes:30093 (29.3 KiB)

virbr0 Link encap:Ethernet HWaddr 52:54:00:A4:73:CE
inet addr:192.168.122.1 Bcast:192.168.122.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

wlan0 Link encap:Ethernet HWaddr 6C:71:D9:33:1C:F1
inet addr:192.168.0.123 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::6e71:d9ff:fe33:1cf1/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:9316 errors:0 dropped:0 overruns:0 frame:0
TX packets:1274 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1590552 (1.5 MiB) TX bytes:110518 (107.9 KiB)

[oracle@oracledb bin]$ shutdown now^C
[oracle@oracledb bin]$ exit
logout
# netstat -nat|grep 1521
tcp 0 0 ::1:1521 :::* LISTEN
tcp 0 0 ::1:50404 ::1:1521 TIME_WAIT
tcp 0 0 ::1:1521 ::1:50404 TIME_WAIT
#
# /etc/init.d/iptables status
iptables: Firewall is not running.
#
# su - oracle
[oracle@oracledb ~]$ cd /oracle/12c/
admin/ checkpoints/ fast_recovery_area/
audit/ db1/ oradata/
cfgtoollogs/ diag/
[oracle@oracledb ~]$ cd /oracle/12c/db1/
addnode/ deinstall/ ldap/ ord/ scheduler/
apex/ demo/ lib/ oui/ slax/
assistants/ diagnostics/ log/ owm/ sqldeveloper/
bin/ dmu/ md/ perl/ sqlj/
ccr/ dv/ mgw/ plsql/ sqlpatch/
cdata/ has/ network/ plugins/ sqlplus/
cfgtoollogs/ hs/ nls/ precomp/ srvm/
clone/ install/ oc4j/ QOpatch/ suptools/
crs/ instantclient/ odbc/ R/ sysman/
css/ inventory/ olap/ racg/ ucp/
ctx/ javavm/ OPatch/ rdbms/ usm/
cv/ jdbc/ opmn/ relnotes/ utl/
dbs/ jdk/ oracore/ rest/ wwg/
dc_ocm/ jlib/ oraInst.loc root.sh xdk/
[oracle@oracledb ~]$ cd /oracle/12c/db1/bin/
[oracle@oracledb bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 27 13:38:04 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oracledb bin]$ ls
acfsroot exp lxchknlb procob
adapters expdp lxegen rawutl
adrci expdpO lxinst rawutl0
adrciO expO mapsga rconfig
afdboot extjob mapsga0 relink
afddriverstate extjobo maxmem renamedg
afdroot extjobO maxmemO renamedg0
afdtool extjoboO mkpatch rman
afdtool.bin extproc mkpatchO rmanO
agtctl extprocO mkstore rtsora
agtctlO extusrupgrade mkstore.bat sbttest
amdu fmputl ncomp sbttestO
amduO fmputlhp netca schema
aqxmlctl genagtsh netca_deinst.sh schemasync
aqxmlctl.pl genclntsh netmgr setasmgid
asmcmd genclntst nid setasmgid0
asmcmdcore genezi nidO skgxpinfo
bndlchk geneziO odisrvreg skgxpinfoO
chopt genksms oerr sqlldr
chopt.ini gennfgt oerr.pl sqlldrO
chopt.pl gennttab oidca sqlplus
cluvfy genoccish oidprovtool srvconfig
cluvfyrac.sh genorasdksh ojvmjava srvctl
coraenv gensyslib ojvmtc statusnc
crsdiag.pl hsalloci okaroot symfind
ctxkbtc hsallociO okdstry sysresv
ctxkbtc0 hsdepxa okdstry0 sysresv0
ctxlc hsdepxaO okinit tkprof
ctxlcO hsots okinit0 tkprofO
ctxload hsotsO oklist tnnfg
ctxloadO imp oklist0 tnslsnr
cursize impdp olsadmintool tnslsnr0
cursizeO impdpO olsoidsync tnsping
dbca impO onsctl tnsping0
dbfs_client jssu orabase transx
dbfsize kfed oracg trcasst
dbfsizeO kfedO oracle trcldr
dbgeu_run_action.pl kfod oracleO trcldr0
dbhome kfod.bin oradism trcroute
dbshut kfodO oraenv trcroute0
dbstart kgmgr orajaxb trcsess
dbua kgmgrO orald tstshm
dbv lbuilder oraping tstshmO
dbvO lcsscan orapipe uidrvci
deploync ldapadd orapki uidrvciO
dg4odbc ldapaddmt orapki.bat umu
dg4odbcO ldapbind orapwd unzip
dg4pwd ldapcompare orapwdO wrap
dg4pwdO ldapdelete oraxml wrapO
dgmgrl ldapmoddn oraxsl wrc
dgmgrlO ldapmodify orion wrcO
diagsetup ldapmodifymt orionO xml
diskmon.bin ldapsearch osdbagrp xmlcg
dropjava ldifmigrator osdbagrp0 xmldiff
dsml2ldif linkshlib osh xmlpatch
dumpsga lmsgen ott xmlwf
dumpsga0 loadjava owm xsl
echodo loadpsp patchgen xsql
emca loadpspO platform_common xvm
emdwgrd lsnodes plshprof zip
emdwgrd.pl lsnrctl plshprofO
eusm lsnrctl0 proc
[oracle@oracledb bin]$ ./net
netca netmgr
[oracle@oracledb bin]$ ./netca

Oracle Net Services Configuration:
No protocol specified
Error: null
Check the trace file for details: /oracle/12c/cfgtoollogs/netca/trace_OraDB12Home1-1702271PM3825.log
Oracle Net Services configuration failed. The exit code is 1
[oracle@oracledb bin]$
[oracle@oracledb bin]$ ./netmgr
No protocol specified
Exiting
java.lang.NullPointerException
at oracle.ewt.lwAWT.BufferedApplet.<init>(Unknown Source)
at oracle.sysman.emSDK.client.appContainer.WebApplication.<init>(WebApplication.java:752)
at oracle.net.mgr.container.NetApplication.<init>(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:357)
at java.lang.Class.newInstance(Class.java:310)
at oracle.sysman.emSDK.client.appContainer.WebApplication.main(WebApplication.java:3316)
[oracle@oracledb bin]$ vf ..
-bash: vf: command not found
[oracle@oracledb bin]$ cd ..
[oracle@oracledb db1]$ cd network/admin/
[oracle@oracledb admin]$ ll
total 32
-rw-r--r-- 1 oracle oinstall 324 Feb 27 13:38 listener1702271PM3827.bak
-rw-r--r-- 1 oracle oinstall 324 Feb 27 13:33 listener.ora
drwxr-xr-x. 2 oracle oinstall 4096 Feb 23 18:18 samples
-rw-r--r--. 1 oracle oinstall 373 Oct 31 2013 shrept.lst
-rw-r--r-- 1 oracle oinstall 171 Feb 27 13:38 sqlnet1702271PM3827.bak
-rw-r--r--. 1 oracle oinstall 171 Feb 23 18:21 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 314 Feb 27 13:38 tnsnames1702271PM3827.bak
-rw-r----- 1 oracle oinstall 314 Feb 27 10:51 tnsnames.ora
[oracle@oracledb admin]$ more listener.ora
# listener.ora Network Configuration File: /oracle/12c/db1/network/admin/listene
r.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

[oracle@oracledb admin]$
[oracle@oracledb admin]$ more tnsnames
tnsnames: No such file or directory
[oracle@oracledb admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/12c/db1/network/admin/tnsname
s.ora
# Generated by Oracle configuration tools.

ORCL12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.123)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl12c)
)
)

[oracle@oracledb admin]$ vim listener.ora
[oracle@oracledb admin]$
[oracle@oracledb admin]$ cd ../../bin/
[oracle@oracledb bin]$ ./lsnrctl stop

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-FEB-2017 13:40:08

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[oracle@oracledb bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-FEB-2017 13:40:11

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Starting /oracle/12c/db1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oracle/12c/db1/network/admin/listener.ora
Log messages written to /oracle/12c/diag/tnslsnr/oracledb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.123)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 27-FEB-2017 13:40:11
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/12c/db1/network/admin/listener.ora
Listener Log File /oracle/12c/diag/tnslsnr/oracledb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.123)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@oracledb bin]$
[oracle@oracledb bin]$ netstat -nat|grep 1521
tcp 0 0 192.168.0.123:1521 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.123:1521 192.168.0.123:35936 TIME_WAIT
tcp 0 0 192.168.0.123:1521 192.168.0.123:35954 ESTABLISHED
tcp 0 0 192.168.0.123:35954 192.168.0.123:1521 ESTABLISHED
[oracle@oracledb bin]$