|
|
[root@station90 1]# netstat -lntp | grep :1521
[root@station90 1]# su - oracle
[oracle@station90 ~]$ . oraenv
ORACLE_SID = [orcl] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 29 15:35:52 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='1522';
System altered.
SQL> alter system set local_listener='a1522';
alter system set local_listener='a1522'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'a1522'
SQL> alter system set local_listener='1522';
System altered.
SQL> alter system set local_listener='1522';
System altered.
SQL> alter system set local_listener='xxx';
alter system set local_listener='xxx'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'xxx'
SQL> alter system set local_listener='mytns';
System altered.
SQL> alter system set local_listener='';
System altered.
SQL> alter system set local_listener='mytns';
System altered.
SQL> alter system set local_listener='';
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@station90 ~]$ exit
logout
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crs_unregister ora.LISTENER.lsnr
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type OFFLINE OFFLINE
ora....ER.lsnr ora....er.type OFFLINE OFFLINE
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crsctl start res ora.L2.lsnr
CRS-2672: Attempting to start 'ora.L2.lsnr' on 'station90'
CRS-2676: Start of 'ora.L2.lsnr' on 'station90' succeeded
[root@station90 1]# crsctl start res ora.LISTENER.lsnr
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'station90'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'station90' succeeded
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crsctl stop res ora.orcl.db
CRS-2673: Attempting to stop 'ora.orcl.db' on 'station90'
CRS-2677: Stop of 'ora.orcl.db' on 'station90' succeeded
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type OFFLINE OFFLINE
[root@station90 1]# su - oracle
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 29 16:31:54 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@station90 ~]$ exit
logout
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crsctl stop res ora.orcl.db
CRS-2673: Attempting to stop 'ora.orcl.db' on 'station90'
CRS-2677: Stop of 'ora.orcl.db' on 'station90' succeeded
[root@station90 1]# crsctl start res ora.orcl.db
CRS-2672: Attempting to start 'ora.orcl.db' on 'station90'
CRS-2676: Start of 'ora.orcl.db' on 'station90' succeeded
[root@station90 1]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora.L2.lsnr ora....er.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.MYGROUP.dg ora....up.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
[root@station90 1]# crsctl stop res ora.LISTENER.lsnr
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'station90'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'station90' succeeded
[root@station90 1]# netstat -lntp | grep :152
tcp 0 0 :::1521 :::* LISTEN 21056/tnslsnr
[root@station90 1]# su - oracle
[oracle@station90 ~]$ exit
logout
[root@station90 1]# crsctl start res ora.LISTENER.lsnr
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'station90'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'station90' succeeded
[root@station90 1]# crsctl stop res ora.LISTENER.lsnr
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'station90'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'station90' succeeded
[root@station90 1]# netstat -lntp | grep :152
tcp 0 0 :::1522 :::* LISTEN 12342/tnslsnr
[root@station90 1]# crsctl start res ora.LISTENER.lsnr
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'station90'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'station90' succeeded
[root@station90 1]# ps aux | grep 3530>
bash: syntax error near unexpected token `newline'
[root@station90 1]# (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PO^C
[root@station90 1]#
[root@station90 1]#
[root@station90 1]# ps aux | grep 3530
oracle 3530 0.0 40.0 6837908 6568260 ? Ss 16:35 0:01 ora_d000_orcl
root 29230 0.0 0.0 103300 808 pts/9 S+ 17:40 0:00 grep 3530
[root@station90 1]# su - oracle
[oracle@station90 ~]$ watch -n 1 "lsnrctl services"
[oracle@station90 ~]$ ps aux | grep ora_s
oracle 3178 0.0 0.0 103296 812 pts/9 S+ 17:47 0:00 grep ora_s
oracle 3363 0.0 40.1 6838440 6580220 ? Ss 16:35 0:01 ora_smon_orcl
oracle 3587 0.0 40.1 6833360 6572468 ? Ss 16:35 0:01 ora_s000_orcl
oracle 13280 0.0 40.0 6831784 6567888 ? Ss 16:45 0:01 ora_smco_orcl
[oracle@station90 ~]$ ps aux | grep ora_s
oracle 3363 0.0 40.1 6838440 6580220 ? Ss 16:35 0:01 ora_smon_orcl
oracle 3515 59.5 40.0 6832848 6567400 ? Ss 17:47 0:01 ora_s001_orcl
oracle 3534 0.0 0.0 103296 812 pts/9 S+ 17:47 0:00 grep ora_s
oracle 3587 0.0 40.1 6833360 6572468 ? Ss 16:35 0:01 ora_s000_orcl
oracle 13280 0.0 40.0 6831784 6567888 ? Ss 16:45 0:01 ora_smco_orcl
[oracle@station90 ~]$ ps aux | grep ora_s
oracle 3363 0.0 40.1 6838440 6580220 ? Ss 16:35 0:01 ora_smon_orcl
oracle 3515 14.8 40.0 6832848 6567400 ? Ss 17:47 0:01 ora_s001_orcl
oracle 3554 19.0 40.0 6832848 6567396 ? Ss 17:47 0:01 ora_s002_orcl
oracle 3587 0.0 40.1 6833360 6572468 ? Ss 16:35 0:01 ora_s000_orcl
oracle 3646 0.0 0.0 103296 812 pts/9 S+ 17:47 0:00 grep ora_s
oracle 13280 0.0 40.0 6831784 6567888 ? Ss 16:45 0:01 ora_smco_orcl
[oracle@station90 ~]$ . oraenv
ORACLE_SID = [orcl] ? +ASm
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/grid
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[oracle@station90 ~]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-JUN-2014 17:49:25
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:42 refused:0 state:ready
LOCAL SERVER
Service "orcl.example.com" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
Handler(s):
"DEDICATED" established:25 refused:0 state:ready
LOCAL SERVER
"D001" established:5 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 979>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=7561))
"D000" established:4 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 3530>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=47604))
"D002" established:5 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 1019>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=32058))
Service "orclXDB.example.com" has 1 instance(s).
Instance "orcl", status READY, has 0 handler(s) for this service...
The command completed successfully
[oracle@station90 ~]$ ps aux | grep ora_d000
oracle 3530 0.0 40.1 6837908 6569312 ? Ss 16:35 0:01 ora_d000_orcl
oracle 17547 0.0 0.0 103300 812 pts/9 S+ 18:02 0:00 grep ora_d000
[oracle@station90 ~]$ kill -9 3530
[oracle@station90 ~]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-JUN-2014 18:02:34
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:56 refused:0 state:ready
LOCAL SERVER
Service "orcl.example.com" has 1 instance(s).
Instance "orcl", status READY, has 4 handler(s) for this service...
Handler(s):
"DEDICATED" established:25 refused:0 state:ready
LOCAL SERVER
"D001" established:11 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 979>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=7561))
"D000" established:10 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 3530>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=47604))
"D002" established:15 refused:0 current:3 max:1022 state:ready
DISPATCHER <machine: station90.example.com, pid: 1019>
(ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=32058))
Service "orclXDB.example.com" has 1 instance(s).
Instance "orcl", status READY, has 0 handler(s) for this service...
The command completed successfully
[oracle@station90 ~]$ ps aux | grep ora_d000
oracle 17717 0.0 0.0 103296 808 pts/9 R+ 18:02 0:00 grep ora_d000
[oracle@station90 ~]$ ps aux | grep ora_d000
oracle 17732 0.0 0.0 103296 812 pts/9 S+ 18:02 0:00 grep ora_d000
[oracle@station90 ~]$ ps aux | grep ora_d000
oracle 17747 0.0 0.0 103296 808 pts/9 R+ 18:02 0:00 grep ora_d000
[oracle@station90 ~]$ ps aux | grep ora_d000
oracle 17751 0.0 0.0 103296 808 pts/9 R+ 18:02 0:00 grep ora_d000
[oracle@station90 ~]$ ps aux | grep ora_d003
oracle 17749 1.1 40.1 6837908 6569340 ? Ss 18:02 0:01 ora_d003_orcl
oracle 19469 0.0 0.0 103300 812 pts/9 S+ 18:04 0:00 grep ora_d003
[oracle@station90 ~]$ kill -9 17749
[oracle@station90 ~]$
|
|
发表于 2014-6-29 21:11:06
