Red Hat 7.2
Scott Canaan ’88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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@xxxxxxxxxxx]
Sent: Friday, February 12, 2016 3:55 PM
To: andrew.kerber@xxxxxxxxx; Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx<mailto:Dimensional.dba@xxxxxxxxxxx>
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew Kerber
Sent: Friday, February 12, 2016 12:00 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxx<mailto:srcdco@xxxxxxx>> 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@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@prosamtest02a:PSAMTEST> cd $BDUMP
-ksh: cd: /oracle/data/admin/PSAMTEST/diag/rdbms/psamtest/PSAMTEST/trace: [No
such file or directory]
oracle@prosamtest02a:PSAMTEST>
From node B:
oracle@prosamtest02b:PSAMTEST>ps -ef | grep smon
oracle 54002 130642 0 14:55 pts/2 00:00:00 grep --color=auto smon
oracle@prosamtest02b:PSAMTEST>cd $BDUMP
oracle@prosamtest02b:PSAMTEST>pwd
/oracle/PSAMTEST/admin/diag/rdbms/psamtest/PSAMTEST/trace
oracle@prosamtest02b:PSAMTEST>
Scott Canaan ’88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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.'