Linux??????Oracle???
???????????? ???????[ 2016/9/29 14:10:01 ] ????????????? Oracle
????????
????Centos6.5 ?????????????? orcl1 ?? orcl2
?????????????
???????:?????????????????????ORACLE_SID????
????export ORACLE_SID=????????
???????orcl1
???????oracle??????????
????[root@entel2 ~]# su - oracle
????oracle@entel2:[/oracle]$export ORACLE_SID=orcl1
????oracle@entel2:[/oracle]$sqlplus sys/system as sysdba
????SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 07:23:47 2016
????Copyright (c) 1982?? 2013?? Oracle. All rights reserved.
????Connected to:
????Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
????With the Partitioning?? OLAP?? Data Mining and Real Application Testing options
????SQL>startup
?????????ɡ?
???????orcl2
???????oracle??????????
????[root@entel2 ~]# su - oracle
????oracle@entel2:[/oracle]$export ORACLE_SID=orcl2
????oracle@entel2:[/oracle]$sqlplus sys/system as sysdba
????SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 07:23:47 2016
????Copyright (c) 1982?? 2013?? Oracle. All rights reserved.
????Connected to:
????Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
????With the Partitioning?? OLAP?? Data Mining and Real Application Testing options
????SQL>startup
???????????
?????е?oracle???
????[root@entel2 ~]# su - oracle
????????????
????oracle@entel2:[/oracle]$lsnrctl status
????LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 28-SEP-2016 07:25:02
????Copyright (c) 1991?? 2013?? Oracle. All rights reserved.
????Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.45.7.198)(PORT=1521)))
????STATUS of the LISTENER
????------------------------
????Alias LISTENER
????Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
????Start Date 28-SEP-2016 06:06:16
????Uptime 0 days 1 hr. 18 min. 46 sec
????Trace Level off
????Security ON: Local OS Authentication
????SNMP OFF
????Listener Parameter File /oracle/product/112/network/admin/listener.ora
????Listener Log File /oracle/diag/tnslsnr/entel2/listener/alert/log.xml
????Listening Endpoints Summary...
????(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.45.7.198)(PORT=1521)))
????(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.1)(PORT=1521)))
????Services Summary...
????Service "orcl1" has 2 instance(s).
????Instance "orcl1"?? status UNKNOWN?? has 1 handler(s) for this service...
????Instance "orcl1"?? status READY?? has 1 handler(s) for this service...
????Service "orcl2" has 2 instance(s).
????Instance "orcl2"?? status UNKNOWN?? has 1 handler(s) for this service...
????Instance "orcl2"?? status READY?? has 1 handler(s) for this service...
????The command completed successfully
???????/??
????lsnrctl start/stop
???????? UNKNOWN??????
??????????UNKNOWN??????????????????????á????????????????????????????????????κ????????е????????????????????????????????????
?????????????????????????е???READY????BLOCKED???????????????????????????????????????????????????????? ??????????????????????????????б??????????????????????????????л?????????????????????????????????????????????????????????fallback??????????
????????ж????????????????????????????£?
????1.?????????????????oracle????????
????2.??????????
????3.oracle??????open
??????????????????David????? Oracle Listener ?????? ?? ??????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11