08-18-2008
problem connecting to oracle 10g after NCR node reboot
Hi All,
I am facing a connection problem with Oracle 10g on Solaris 10 when my application (started by /etc/rc3.d at node reboot) tries to establish a session after reboot of the node where my application is running (NCR UNIX (MP RAS)).
I find that my application (run as a deamon process) dies (abruptly comes down) when a logon is attempted for the first time after the system reboot. I am pretty confident that there is no other process that is trying to establish a connection with Oracle other than my application after i rebooted the NCR node.
When i bounce my application (stop and restart the application) and try establishing the connection with oracle, it is working fine. The application attempts to make a connection only when it recieves a request from another client application on my NCR box.
I am guessing that there could be a problem when establishing the first connection to Oracle 10gR2 database from the client application. To add, we have Oracle 8i client software installed on the client side (NCR node).
I have also check for all the necesary application that it is dependent upon. All the applications upon which this application is dependent on are started properly even before this application is comming up.
Can some one help me out to resolve this issue?
thank you,
sowjanya
7 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have download Oracle 10g for Solaris and I have configurate environment than I will start runInstaller and I have a messege that my version of solaris is not 5.7 , 5.8 and 5,9 I have 5.10 Solaris version what I shoud do I have download most actuall Oracle databases. (4 Replies)
Discussion started by: Deux
4 Replies
2. UNIX for Dummies Questions & Answers
Can someone tell me how to prevent this?
stty: standard input: Invalid argument
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0306: Invalid option.
Usage: CONN where <logon> ::= <username> | /
ERROR:
ORA-12162: TNS:net service name is incorrectly... (1 Reply)
Discussion started by: goodmis
1 Replies
3. UNIX for Advanced & Expert Users
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Discussion started by: ganapati
2 Replies
4. AIX
hi
can anyone help me by telling step by stem oracle10g installation in AIX 5 .
Munir
mondolsoft
Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies
5. Shell Programming and Scripting
Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it.
#!/bin/ksh
ssh -X root@192.168.2.127 <perimuka>
sleep 5
su - oracle
sqlplus <mraghunandanan>/<peri123> <<eof
Can anyone tell what is wrong... (3 Replies)
Discussion started by: mraghunandanan
3 Replies
6. AIX
Hi,
anyone know if Oracle Database 10g is AIX 7 certified???
thanks in advance.
Regards.
Mario (2 Replies)
Discussion started by: Zio Bill
2 Replies
7. IP Networking
I'm trying to figure out what circumstances would cause an Open Solaris 11.2 host to switch itself from a static to a DHCP ip address upon reboot. This has only happened once but is a cause for some concern as this machine will be part of a web server pool.
Nothing has changed on the LAN that... (2 Replies)
Discussion started by: SmokeyJoe
2 Replies
LEARN ABOUT SUSE
crm_standby
CRM_STANDBY(8) [FIXME: manual] CRM_STANDBY(8)
NAME
crm_standby - manipulate a node's standby attribute to determine whether resources can be run on this node
SYNOPSIS
crm_standby [-?|-V] -D -u|-U node -r resource
crm_standby [-?|-V] -G -u|-U node -r resource
crm_standby [-?|-V] -v string -u|-U node -r resource [-l string]
DESCRIPTION
The crm_standby command manipulates a node's standby attribute. Any node in standby mode is no longer eligible to host resources and any
resources that are there must be moved. Standby mode can be useful for performing maintenance tasks, such as kernel updates. Remove the
standby attribute from the node when it should become a fully active member of the cluster again.
By assigning a lifetime to the standby attribute, determine whether the standby setting should survive a reboot of the node (set lifetime
to forever) or should be reset with reboot (set lifetime to reboot). Alternatively, remove the standby attribute and bring the node back
from standby manually.
OPTIONS
--help, -?
Print a help message.
--verbose, -V
Turn on debug information.
Note
Increase the level of verbosity by providing additional instances.
--quiet, -Q
When doing an attribute query using -G, print just the value to stdout. Use this option with -G.
--get-value, -G
Retrieve rather than set the preference.
--delete-attr, -D
Specify the attribute to delete.
--attr-value string, -v string
Specify the value to use. This option is ignored when used with -G.
--node-uuid node_uuid, -u node_uuid
Specify the UUID of the node to change.
--node-uname node_uname, -U node_uname
Specify the uname of the node to change.
--lifetime string, -l string
Determine how long this preference lasts. Possible values are reboot or forever.
Note
If a forever value exists, it is always used by the CRM instead of any reboot value.
EXAMPLES
Have a local node go to standby:
crm_standby -v true
Have a node (node1) go to standby:
crm_standby -v true -U node1
Query the standby status of a node:
crm_standby -G -U node1
Remove the standby property from a node:
crm_standby -D -U node1
Have a node go to standby for an indefinite period of time:
crm_standby -v true -l forever -U node1
Have a node go to standby until the next reboot of this node:
crm_standby -v true -l reboot -U node1
FILES
/var/lib/heartbeat/crm/cib.xml--the CIB (minus status section) on disk. Editing this file directly is strongly discouraged.
SEE ALSO
???, ???
AUTHOR
crm_standby was written by Andrew Beekhof.
[FIXME: source] 07/05/2010 CRM_STANDBY(8)