RE: Oracle On Linux Cluster Issue

From: Scott Canaan <srcdco_at_rit.edu>
Date: Fri, 12 Feb 2016 20:55:04 +0000
Message-id: <928c1ad64ed249eaa5b5b3a60e55ac2d_at_ex04mail01d.ad.rit.edu>



Red Hat 7.2

Scott Canaan ’88 (srcdco_at_rit.edu<mailto: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] 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<mailto: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<http://www.dimensionaldba.com>

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto: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<mailto: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<mailto: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<mailto:srcdco_at_rit.edu>)
(585) 475-7886<tel:%28585%29%20475-7886> – work (585) 339-8659<tel:%28585%29%20339-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
Received on Fri Feb 12 2016 - 21:55:04 CET

Original text of this message