欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

oracle listener

程序员文章站 2024-01-09 19:33:40
...
http://blog.chinaunix.net/xmlrpc.php?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
[root@oracledb adump]# cd ..
[root@oracledb orcl12c]# ls
adump  dpdump  pfile  xdb_wallet
[root@oracledb orcl12c]# cd ..
[root@oracledb admin]# ls
orcl12c
[root@oracledb admin]# cd ..
[root@oracledb 12c]# ls
admin  audit  cfgtoollogs  checkpoints  db1  diag  fast_recovery_area  oradata
[root@oracledb 12c]# cd ..
[root@oracledb oracle]# ls
12c  oraInventory  tablespaces
[root@oracledb oracle]# cd ..
[root@oracledb /]# 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
[root@oracledb /]# cd /oracle/12c/db1/
[root@oracledb 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
[root@oracledb db1]# cd network/
[root@oracledb network]# ls
admin  install  jlib  lib  log  mesg  tools  trace
[root@oracledb network]# cd admin
[root@oracledb admin]# ls
listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora
[root@oracledb admin]# vi listener.ora
[root@oracledb admin]# vi listener.ora
[root@oracledb admin]# 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     
[root@oracledb admin]# netstat -nat|grep 1521
[root@oracledb admin]#
[root@oracledb admin]# 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
[root@oracledb admin]# 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  
[root@oracledb admin]#
[root@oracledb admin]# /etc/init.d/iptables status
iptables: Firewall is not running.
[root@oracledb admin]#
[root@oracledb admin]# 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]$
相关标签: oracle

上一篇: java中Locks的使用

下一篇: