Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sun Cluster3.2 And Oracle10g
Operating Systems Solaris Sun Cluster3.2 And Oracle10g Post 302449954 by fugitive on Wednesday 1st of September 2010 05:01:44 AM
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>]

 

8 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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
All times are GMT -4. The time now is 04:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy