Login or Register to Ask a Question and Join Our Community


Solaris

Sun Cluster3.2 And Oracle10g

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris Sun Cluster3.2 And Oracle10g
# 1  
Old 09-01-2010
Sun Cluster3.2 And Oracle10g
I want to configure Sun Cluster3.2 with Oracle10g ... i created 4 resources namely , logical host, sotrage, oracle -server & Listener .. all work fine butoracle resource does not come up .. though i can bring up the oracle outside sun cluster.
Code:

node1:/>clrg online ora-rg
clrg: (C450598) On node node1, resource group ora-rg is online but resource ora-server failed to start
node1:/>clrg status

=== Cluster Resource Groups ===

Group Name Node Name Suspended Status
---------- --------- --------- ------
ora-rg node1 Yes Online faulted

node1:/>clrs status

=== Cluster Resources ===

Resource Name Node Name State Status Message
------------- --------- ----- --------------
ora-store node1 Online Online

ora-lh node1 Online Online - LogicalHostname online.

ora-server node1 Start failed Faulted

ora-listener-res node1 Online Online

Code:
node1:/>clrs create -g ora-rg -t oracle_server -p Resource_dependencies=ora-store -p Oracle_sid=MYORA -x ORACLE_home=/u01/product/10.2.0/Db_1/ -p Alert_log_file=/u01/product/10.2.0/Db_1/admin/test/bdump/alert_test.log -p Parameter_file=/u01/product/10.2.0/Db_1/admin/test/pfile/initMYORA.ora -p Connect_string=sc_fm/sc_fm ora-server-res


Code:
Sep 1 00:15:48 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <hafoip_prenet_start> for resource <ora-lh>, resource group <ora-rg>, node <node1>, timeout <300> seconds
Sep 1 00:15:48 node1 Cluster.RGM.global.rgmd: [ID 944595 daemon.notice] 39 fe_rpc_command: cmd_type(enum):<1>:cmd=</usr/c:tag=<ora-rg.ora-lh.10>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:48 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <hafoip_prenet_start> completed successfully for resource <ora-lh>, resource group <ora-rg>, node <node1>, time used: 0% of timeout <300 seconds>
Sep 1 00:15:48 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <hastorageplus_prenet_start> for resource <ora-store>, resource group <ora-rg>, node <node1>, timeout <1800> seconds
Sep 1 00:15:48 node1 Cluster.RGM.global.rgmd: [ID 944595 daemon.notice] 39 fe_rpc_command: cmd_type(enum):<1>:cmd=</usr/c:tag=<ora-rg.ora-store.10>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <hastorageplus_prenet_start> completed successfully for resource <ora-store>, resource group <ora-rg>, node <node1>, time used: 0% of timeout <1800 seconds>
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <hastorageplus_monitor_start> for resource <ora-store>, resource group <ora-rg>, node <node1>, timeout <90> seconds
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <hafoip_start> for resource <ora-lh>, resource group <ora-rg>, node <node1>, timeout <500> seconds
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 944595 daemon.notice] 39 fe_rpc_command: cmd_type(enum):<1>:cmd=</usr/c:tag=<ora-rg.ora-lh.0>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 863274 daemon.notice] 40 fe_rpc_command: cmd_type(enum):<1>:cmd=</usr/c:tag=<ora-rg.ora-store.7>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <hastorageplus_monitor_start> completed successfully for resource <ora-store>, resource group <ora-rg>, node <node1>, time used: 0% of timeout <90 seconds>
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <hafoip_start> completed successfully for resource <ora-lh>, resource group <ora-rg>, node <node1>, time used: 0% of timeout <500 seconds>
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <hafoip_monitor_start> for resource <ora-lh>, resource group <ora-rg>, node <node1>, timeout <300> seconds
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <bin/o for resource <ora-server>, resource group <ora-rg>, node <node1>, timeout <600> seconds
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <bin/o for resource <ora-listener-res>, resource group <ora-rg>, node <node1>, timeout <300> seconds
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 863274 daemon.notice] 40 fe_rpc_command: cmd_type(enum):<1>:cmd=</opt/S:tag=<ora-rg.ora-server.0>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 944595 daemon.notice] 39 fe_rpc_command: cmd_type(enum):<1>:cmd=</opt/S:tag=<ora-rg.ora-listener-res.0>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:49 node1 Cluster.RGM.global.rgmd: [ID 703477 daemon.notice] 38 fe_rpc_command: cmd_type(enum):<1>:cmd=</usr/c:tag=<ora-rg.ora-lh.7>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:50 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <hafoip_monitor_start> completed successfully for resource <ora-lh>, resource group <ora-rg>, node <node1>, time used: 0% of timeout <300 seconds>
Sep 1 00:15:57 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <bin/o completed successfully for resource <ora-listener-res>, resource group <ora-rg>, node <node1>, time used: 2% of timeout <300 seconds>
Sep 1 00:15:57 node1 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <bin/o for resource <ora-listener-res>, resource group <ora-rg>, node <node1>, timeout <180> seconds
Sep 1 00:15:57 node1 Cluster.RGM.global.rgmd: [ID 944595 daemon.notice] 39 fe_rpc_command: cmd_type(enum):<1>:cmd=</opt/S:tag=<ora-rg.ora-listener-res.7>: Calling security_clnt_connect(..., host=<node1>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Sep 1 00:15:59 node1 Cluster.RGM.global.rgmd: [ID 515159 daemon.notice] method <bin/o completed successfully for resource <ora-listener-res>, resource group <ora-rg>, node <node1>, time used: 1% of timeout <180 seconds>
Sep 1 00:16:00 node1 SC[SUNWscor.oracle_server.start]:ora-rg:ora-server: [ID 876834 daemon.error] Could not start server
Sep 1 00:16:01 node1 Cluster.RGM.global.rgmd: [ID 938318 daemon.error] Method <bin/o failed on resource <ora-server> in resource group <ora-rg> [exit code <1>, time used: 1% of timeout <600 seconds>]

# 2  
Old 09-01-2010
I would remove the trailing slash from the value of the ORACLE_HOME variable:

this:

Code:
ORACLE_home=/u01/product/10.2.0/Db_1/

should become:

Code:
ORACLE_home=/u01/product/10.2.0/Db_1

Is it really ORACLE_home and not ORACLE_HOME (the Oracle variable is ORACLE_HOME, but I supposethat this is Sun Cluster specific spelling?).

After that, I would check the logs in /var/opt/SUNWscore/oracle_server.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Solaris

Can we add Oracle ASM in sun cluster3.3 or 4.0 in failover mode

Hi I am new to this forum & oracle DBA also, I would like to know that can we add Oracle ASM in failover mode in sun cluster 3.3 or 4.0 means that if suppose oracle is running along with ASM on node1 & this node went down due to hardware issue then both oracle along with ASM must move to... (1 Reply)
Discussion started by: hb00
1 Replies

2. Programming

Rupee Sign printing using Pro * C (Unix Platform/Oracle10g) code

Hi All, I want to print new Indian Rupees sign in my report which is developed in Pro*C code. Please help me to know: ->What necessary settings i have to do.. I am looking for free product. Please help (0 Replies)
Discussion started by: msbrd
0 Replies

3. AIX

ODBC Connectivity between Oracle10g on AIX and Mainframe

Hi, I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side. Question: (may be dumb to you) 1. Has anybody done this and would... (3 Replies)
Discussion started by: jvmani_1
3 Replies

4. Solaris

Global device issue in sun cluster3.2

In my 2 node cluster (sun cluster3.2) running on x86 VMs. One of my nodes VM1 does not have the global devices populated due to which i cannot failover my file system to node VM1 , what could be the reason for this and how can i rectify it ? VM1:/>cd /dev/global -bash: cd: /dev/global: No... (1 Reply)
Discussion started by: fugitive
1 Replies

5. Virtualization and Cloud Computing

Sun Cluster3.2 on Vmware Server2.0

I'm trying to configure sun cluster 3.2 on vmware server 2.0 on windows xp host with solaris 10x86 guests VM3 and VM4 and i 'm running scinstall from VM4 .. it fails with following error Initializing cluster name to "laptop" ... done Initializing authentication options ... done Initializing... (0 Replies)
Discussion started by: fugitive
0 Replies

6. Solaris

sun cluster3.2, d3 and d8 are shown as failed

Hello, This is a 2 node sun cluster 3.2 on solaris 10(x86) I am using an unique ~512M disk (c0d1) on each node and slice 6 on this disk for globaldevices. While everything looks like fine, the 'Fail' is bothering me. @ tommy_sun1 @tommy_sun -bash-3.00# cldevice refresh... (10 Replies)
Discussion started by: upengan78
10 Replies

7. UNIX for Advanced & Expert Users

Error with Oracle10g Express in Linux FC6, help...

I just installed Oracle10g Express on Linux FC6. I get errors in Java and SQLPlus when trying to connect to the database, or start it. In SQLPlus as "sysdba" when I type "startup" I get this error... ORA-27100: shared memory realm already exists And in Java or SQLPlus when I try to... (0 Replies)
Discussion started by: Joncamp
0 Replies

8. UNIX for Advanced & Expert Users

oracle10G installation guide

Hello every body I'm looking for the steps of installation oracle10G in solaris plateform (solaris9 or 10) if any one have step by step guide please tell me Thanks (2 Replies)
Discussion started by: asafwat
2 Replies
Login or Register to Ask a Question