Re: Oracle On Linux Cluster Issue

I'm not sure about where you have your log files but your BDUMP variable has a different value on each node. I suggest using adrci to view your logs.

Seth Miller

On Fri, Feb 12, 2016 at 3:42 PM, Dimensional DBA < dimensional.dba_at_comcast.net> wrote:

> There are a variety of references
>
>
>
>
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/pdf/High_Availability_Add-On_Overview/Red_Hat_Enterprise_Linux-7-High_Availability_Add-On_Overview-en-US.pdf
>
>
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/pdf/High_Availability_Add-On_Administration/Red_Hat_Enterprise_Linux-7-High_Availability_Add-On_Administration-en-US.pdf
>
>
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/pdf/High_Availability_Add-On_Reference/Red_Hat_Enterprise_Linux-7-High_Availability_Add-On_Reference-en-US.pdf
>
>
>
> these references will give the cluster commands to check status of the
> cluster and force the resources to the right node.
>
>
>
> 2.6. Displaying the Full Cluster Configuration Use the following command
> to display the full current cluster configuration.
>
> pcs config
>
>
>
> It sounds like there was a cluster failover and all the cluster services
> did not failover between the servers, mainly some of the file systems.
>
>
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *Dimensional DBA*
>
> *425-891-7934 (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
>
>
> *From:* Scott Canaan [mailto:srcdco_at_rit.edu]
> *Sent:* Friday, February 12, 2016 12:55 PM
> *To:* Dimensional DBA; andrew.kerber_at_gmail.com
>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: Oracle On Linux Cluster Issue
>
>
>
> Red Hat 7.2
>
>
>
> Scott Canaan ’88 (srcdco_at_rit.edu)
>
> (585) 475-7886 – work (585) 339-8659 – cell
>
> “Life is like a sewer, what you get out of it depends on what you put into
> it.” – Tom Lehrer
>
>
>
> *From:* Dimensional DBA [mailto:dimensional.dba_at_comcast.net
> <dimensional.dba_at_comcast.net>]
> *Sent:* Friday, February 12, 2016 3:55 PM
> *To:* andrew.kerber_at_gmail.com; Scott Canaan
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: Oracle On Linux Cluster Issue
>
>
>
> Which Linux and what version are you on?
>
>
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *Dimensional DBA*
>
> *425-891-7934 (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Andrew Kerber
> *Sent:* Friday, February 12, 2016 12:00 PM
> *To:* Scott Canaan
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Oracle On Linux Cluster Issue
>
>
>
> Are you on physical servers or virtual servers?
>
>
>
> On Fri, Feb 12, 2016 at 1:56 PM, Scott Canaan <srcdco_at_rit.edu> wrote:
>
> We are just getting into running Oracle on a Linux cluster. The SAs
> create the cluster and l create the database. We are using Oracle
> 12.1.0.2. Last night, something strange happened and I can’t figure out
> what to do to fix it. The database is running on node A, but the log files
> (alert log, trace files, etc.) are only on node B. The database files are
> being updated on both nodes. The DNS listener that is used to access the
> database thinks the database is running on node B, so anything using that
> to connect fails (CommVault backups failed because it couldn’t find the
> database up on node B).
>
>
>
> Unfortunately, the key SA is out today and the others don’t know anything
> about the Linux cluster. Is there anything I can do to get it straightened
> out or do I have to wait for him to get back on Monday?
>
>
>
> From node A:
>
>
>
> oracle_at_prosamtest02a:PSAMTEST>ps -ef | grep smon
>
> oracle 60180 19859 0 14:54 pts/1 00:00:00 grep --color=auto smon
>
> oracle 117329 1 0 Feb11 ? 00:00:00 ora_smon_PSAMTEST
>
> oracle_at_prosamtest02a:PSAMTEST> cd $BDUMP
>
> -ksh: cd: /oracle/data/admin/PSAMTEST/diag/rdbms/psamtest/PSAMTEST/trace:
> [No such file or directory]
>
> oracle_at_prosamtest02a:PSAMTEST>
>
>
>
> From node B:
>
>
>
> oracle_at_prosamtest02b:PSAMTEST>ps -ef | grep smon
>
> oracle 54002 130642 0 14:55 pts/2 00:00:00 grep --color=auto smon
>
> oracle_at_prosamtest02b:PSAMTEST>cd $BDUMP
>
> oracle_at_prosamtest02b:PSAMTEST>pwd
>
> /oracle/PSAMTEST/admin/diag/rdbms/psamtest/PSAMTEST/trace
>
> oracle_at_prosamtest02b:PSAMTEST>
>
>
>
> Scott Canaan ’88 (srcdco_at_rit.edu)
>
> (585) 475-7886 – work (585) 339-8659 – cell
>
> “Life is like a sewer, what you get out of it depends on what you put into
> it.” – Tom Lehrer
>
>
>
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l