千絮泠泉
- 浏览: 279288 次
- 性别:
-
文章分类
最新评论
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]$
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]$
分享到：
发表评论
-
Session
2018-11-23 10:49 463select saddr,sid,serial#,padd ... -
数据快照恢复
2018-11-14 12:07 760--第一步:在v$sqlarea 这视图里面找到你操作那条 ... -
linux常用命令全拼
2018-10-25 10:35 590http://www.cnblogs.com/wangcp-2 ... -
openssl ，nginx ，ssl
2018-09-04 22:30 692https://blog.csdn.net/yazhouren ... -
ssl客户端关闭，将导致服务端Tomcat服务关闭
2018-08-03 15:03 788解决方案 set -m 原理尚未探究， 因为系系统工 ... -
数据库主键选择讨论
2018-05-22 18:13 574https://blog.csdn.net/mchdba/ar ... -
Schema相互授权
2018-04-27 15:50 1761['TABLE1','TABLE2'].forEach(t ... -
逗号分隔字符串为集合
2018-01-12 10:26 592SELECT DISTINCT REGEXP_SUBSTR ( ... -
关于持续集成
2017-12-14 18:20 590http://blog.csdn.net/ouyida3/ar ... -
/usr/local/lib/libz.a(crc32.o): relocation R_X86_64_32 against `.rodata' can not
2017-12-13 00:25 1613make[3]: *** [shared-build-re ... -
linux add swap
2017-12-12 22:17 592[url]https://www.cyberciti.biz/ ... -
linux下安装Apache-httpd-2.4
2017-12-11 23:41 589http://blog.csdn.net/conquer071 ... -
安装mysql5.7.20
2017-12-11 15:31 688http://www.mamicode.com/info-de ... -
gcc 编译出现 internal compiler error: Killed
2017-12-10 20:01 926internal compiler error: Killed ... -
centOS install Maven
2017-04-22 01:41 497centOS install Maven $ sud ... -
centOS block at longin plateform
2017-04-21 23:35 554This problem is environment err ... -
centOs install eclipse & create Desktop
2017-04-21 21:39 568centOs install eclipse & cr ... -
Oracle中查看所有表和字段
2017-04-18 17:10 1510Oracle中查看所有表和字段 获取表字段： se ... -
Oracle在java开发中语句总结
2017-03-29 18:09 58201 oracle 中查询一个表的所有字段名以及属性<表 ... -
Linux Notes 1
2017-03-12 14:08 506[root@localhost ~]# ls -l -l 长格 ...
相关推荐
专门解决Oracle数据库listener报1067错误，简洁有效的解决这个问题，非常实用。
Oracle监听器（Listener）是Oracle数据库系统中至关重要的组件，它负责管理客户端和数据库服务器之间的网络通信。监听器通过监听特定的网络端口，接收来自客户端的连接请求，并根据配置进行响应。理解监听器的工作...
Oracle TNS Listener是Oracle数据库系统中用于监听客户端请求的关键组件。其基本功能是在网络上监听客户端发来的连接请求，并对这些请求做出响应。然而，TNS Listener也存在一系列安全漏洞，尤其是缓冲区溢出和配置...
在Oracle数据库的运行过程中，`listener.ora`和`tnsnames.ora`是两个至关重要的配置文件，它们负责管理和通信数据库实例与客户端应用程序之间的连接。 `listener.ora`文件是Oracle监听器的配置文件，它定义了监听器...
### Oracle Listener 详解 #### 一、Oracle Listener 概述 **Oracle Listener** 是 Oracle 数据库系统中的一个重要组件，负责监听来自客户端的连接请求，并基于这些请求管理与客户端的通信。Listener 的主要职责...
在IT行业中，数据库服务是关键组件之一，Oracle数据库作为企业级数据库系统，其监听器（Listener）扮演着至关重要的角色。监听器负责管理客户端与数据库服务器之间的连接，它监听特定的网络端口，以便接收并处理来自...
Oracle监听器（Listener）是Oracle数据库系统中一个至关重要的组件，负责管理客户端与数据库服务器之间的连接。当数据库遇到连接问题时，监听器日志成为排查问题的重要资源。本文将详细介绍如何解析Oracle监听器日志...
### Oracle Database Listener安全指南 #### 一、简介 在Integrigy发布的《Oracle Database Listener Security Guide》（Oracle TNS Listener 安全指南）中，该文档提供了关于Oracle数据库监听器的安全配置与管理...
"Oracle LISTENER 监听文件参数详解及 Lsnrctl 命令综述" Oracle LISTENER 监听文件参数详解： LISTENER 监听文件参数是 Oracle Net Listener 的配置文件，用于定义监听器的行为和参数。下面是 LISTENER 监听文件...
### 认识Oracle中的sqlnet.ora、tnsnames.ora与listener.ora三个关键配置文件 #### 一、概述 在Oracle安装过程中，我们常常会在安装目录下的`$HOME/network/admin`文件夹中发现三个重要的配置文件：`sqlnet.ora`、...
Oracle RAC 监听器配置文件 listener.ora 详解 Oracle RAC 监听器配置文件 listener.ora 是一个核心配置文件，用于配置 Oracle Net Listener 的参数。本文将详细介绍 listener.ora 文件的配置参数、协议地址参数、...
"listener.ora" 文件是 Oracle 数据库系统中的一个重要配置文件，它定义了监听器（Listener）如何处理数据库实例和服务的连接请求。监听器是数据库通信的关键组件，它负责管理客户端和服务器之间的网络通信。在本篇...
# Oracle listener and instance startup su $ORA_OWNR -lc "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" echo "Oracle Start Successful! OK." ;; stop) # Oracle listener and instance shutdown su $ORA_OWNR ...
Oracle监听器是数据库系统的重要组成部分，它在Oracle数据库与客户端应用程序之间起着桥梁的作用。本文档详细介绍了Oracle监听器的工作原理、主要功能、基本操作、动态注册与静态注册、监听日志管理和分析以及针对...
标题“marcelopaesrech/presto-oracle”指的是一个由GitHub用户marcelopaesrech创建的项目，该项目提供了连接Oracle数据库的Presto连接器。Presto是一个分布式SQL查询引擎，常用于大数据分析，而Oracle则是一种广泛...
Oracle数据库的正常运行依赖于监听服务（Oracle Listener）和数据库服务。本文将详细解释如何启动和关闭Oracle监听及服务，以及如何重新配置监听。 首先，Oracle监听是Oracle数据库系统中的一个重要组件，它的主要...
# Oracle listener and instance startup echo -n "Starting Oracle: " su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart" su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start" touch /var/lock/Oracle su - $ORA_OWNR...
* 检查 Oracle Listener：在登录到数据库之前，需要检查 Oracle Listener 的状态，确保其处于活动状态。 用户管理 在 Oracle 11G 中，用户管理是非常重要的。用户是数据库的基本组成部分，需要对用户进行创建、...
# Oracle listener and instance startup echo -n "Starting Oracle: " su $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart" touch /var/lock/oracle # su $ORA_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole" # ...
Oracle数据库作为一个复杂的系统，其服务包括多个组件，如监听器（Oracle Listener）、数据库实例（Oracle Instance）等，这些服务需要根据系统的运行状态进行启停操作。在Windows环境下，Oracle服务可以通过控制...