Monday, June 30, 2008

#ocrcheck
#crsctl stop crs
---> this actually shutdowns everything, the crs components, listener and oracle as well
#crsctl start crs
---> this starts everything


[root@pw450 bin]$ crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
[root@pw450 bin]$ ps -aef|grep ora_
root 26501 29410 0 16:42:15 pts/6 0:00 grep ora_
[root@pw450 bin]$ ps -aef|grep ora_
root 26503 29410 0 16:42:16 pts/6 0:00 grep ora_
[root@pw450 bin]$
[root@pw450 bin]$ crsctl check crs
CSS appears healthy
Cannot communicate with CRS
EVM appears healthy
[root@pw450 bin]$ ps -aef|grep ora_
root 27225 29410 0 16:42:34 pts/6 0:00 grep ora_

[root@pw450 bin]$ ps -aef|grep ora_
oracle 27555 1 0 16:42:43 ? 0:00 ora_pmon_ooo2
oracle 27611 1 0 16:42:45 ? 0:00 ora_ckpt_ooo2
oracle 27625 1 0 16:42:45 ? 0:00 ora_s000_ooo2
oracle 27557 1 0 16:42:43 ? 0:00 ora_diag_ooo2
oracle 27563 1 0 16:42:43 ? 0:00 ora_lmd0_ooo2
oracle 27565 1 2 16:42:43 ? 0:01 ora_lms0_ooo2
oracle 27613 1 0 16:42:45 ? 0:00 ora_smon_ooo2
root 27787 29410 0 16:42:50 pts/6 0:00 grep ora_
oracle 27576 1 3 16:42:44 ? 0:01 ora_mman_ooo2
oracle 27592 1 0 16:42:44 ? 0:00 ora_dbw0_ooo2
oracle 27569 1 2 16:42:43 ? 0:01 ora_lms1_ooo2
oracle 27609 1 0 16:42:44 ? 0:00 ora_lgwr_ooo2
oracle 27615 1 0 16:42:45 ? 0:00 ora_reco_ooo2
oracle 27619 1 0 16:42:45 ? 0:00 ora_mmon_ooo2
oracle 27617 1 0 16:42:45 ? 0:00 ora_cjq0_ooo2
oracle 27623 1 0 16:42:45 ? 0:00 ora_d000_ooo2
oracle 27621 1 0 16:42:45 ? 0:00 ora_mmnl_ooo2
oracle 27720 1 0 16:42:48 ? 0:00 ora_lck0_ooo2
oracle 27559 1 0 16:42:43 ? 0:00 ora_psp0_ooo2
oracle 27561 1 3 16:42:43 ? 0:02 ora_lmon_ooo2

[oracle@pw450 ~]$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-JUN-2008 16:43:03

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
[oracle@pw450 ~]$
[oracle@pw450 ~]$
[oracle@pw450 ~]$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-JUN-2008 16:43:18

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_PW450
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 30-JUN-2008 16:43:07
Uptime 0 days 0 hr. 0 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/10.2.0/dbhome/network/admin/listener.ora
Listener Log File /app/oracle/product/10.2.0/dbhome/network/log/listener_pw450.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.9)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@pw450 ~]$
[oracle@pw450 ~]$
[oracle@pw450 ~]$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-JUN-2008 16:43:21

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_PW450
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 30-JUN-2008 16:43:07
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/10.2.0/dbhome/network/admin/listener.ora
Listener Log File /app/oracle/product/10.2.0/dbhome/network/log/listener_pw450.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.9)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@pw450 ~]$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-JUN-2008 16:43:23

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_PW450
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 30-JUN-2008 16:43:07
Uptime 0 days 0 hr. 0 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/10.2.0/dbhome/network/admin/listener.ora
Listener Log File /app/oracle/product/10.2.0/dbhome/network/log/listener_pw450.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.9)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@pw450 ~]$
[oracle@pw450 ~]$
[oracle@pw450 ~]$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-JUN-2008 16:46:17

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_PW450
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 30-JUN-2008 16:43:07
Uptime 0 days 0 hr. 3 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/10.2.0/dbhome/network/admin/listener.ora
Listener Log File /app/oracle/product/10.2.0/dbhome/network/log/listener_pw450.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.188.88.9)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ooo" has 2 instance(s).
Instance "ooo1", status READY, has 1 handler(s) for this service...
Instance "ooo2", status READY, has 2 handler(s) for this service...
Service "oooXDB" has 2 instance(s).
Instance "ooo1", status READY, has 1 handler(s) for this service...
Instance "ooo2", status READY, has 1 handler(s) for this service...
Service "ooo_XPT" has 2 instance(s).
Instance "ooo1", status READY, has 1 handler(s) for this service...
Instance "ooo2", status READY, has 2 handler(s) for this service...
The command completed successfully
Posted by at No comments:

Oracle 10gR2 RAC Installation Problems

Problem encountered in Oracle 10gR2 RAC Installation:

1. On Solaris, if raw device is to be used, remember not to use the first cylinder of the disk.
VTOC occupy the 1st cylinder of a Solaris partition 0.

2. Do not ever use IANA reserved private IP addresses ( as your public IP. There will be no error shown when you set those private interface to public. But the VIP instance will mysterious died off, and causing the RAC instances to abort without any errors.

IANA Reserved IP for Private use:
10.0.0.0 - 10.255.255.255
172.16.0.0 - 172.31.255.255
192.168.0.0 - 192.168.255.255
Posted by at No comments:

Saturday, June 21, 2008

Benn Yoong, DaWei, DaJie

Posted by at No comments:

Langkawi Trip


Posted by at No comments:

Thursday, June 19, 2008

Something about Oracle user and Solaris project

here's the findings:

IF you primary Oracle group is not dba (say your primary group is oinstall), and you try to make project group.dba as your primary project, huhh nothing will change when you type "id -p". You still get back the project called default as your primary project. (In fact, i shouldn't use the term "primary project", as this is not accurate).

So create a project something like "user.oracle" and make it your oracle primary project, it will works.

See below:

[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)
[root@pw450 /]$
[root@pw450 /]$ projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" \
> -K "project.max-sem-nsems=(priv,256,deny)" \
> -K "project.max-sem-ids=(priv,100,deny)" \
> -K "project.max-shm-ids=(priv,100,deny)" group.dba
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)



...............oppps..........it doesn't work, you are however being added to the member list of the project group.dba.


so we will create user.oracle instead.

see below:

[root@pw450 /]$ projdel group.dba
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)
[oracle@pw450 ~]$ exit
logout
[root@pw450 /]$
[root@pw450 /]$ projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" \
> -K "project.max-sem-nsems=(priv,256,deny)" \
> -K "project.max-sem-ids=(priv,100,deny)" \
> -K "project.max-shm-ids=(priv,100,deny)" user.oracle
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=100(user.oracle)
[oracle@pw450 ~]$ cat
^C
[oracle@pw450 ~]$ cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-sem-ids=(priv,100,deny);project.max-sem-nsems=(priv,256,deny);project.max-shm-ids=(priv,100,deny);project.max-shm-memory=(priv,4294967296,deny)
[oracle@pw450 ~]$

....
something that's not mentioned in the Oracle RAC installation guide...

...
Posted by at No comments:

Sunday, June 15, 2008

uncompress oracle files

just in case i dont remember...
[root@pw450 oradb]$ gunzip -cd 10gr2_db_sol.cpio.gz | cpio -idmv
Posted by at No comments:
Subscribe to: Posts (Atom)