Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Unanswered: Veritas Cluster, problem connecting to DB service with virtual IP

    Dear all

    I'm running Veritas Cluster Server on two Solaris 10 nodes. In service group Oracle, I have configured a database service which can be run either on node1 or node2. Basically, resources that the service relies on are:
    - disk group (external storage) where the database actually resides (which needs to be attached either to node1 or node2, depending on which node currently runs the DB)
    - virtual IP which is used by DB clients to connect to database

    Both startup of the virtual IP interface and attaching the disk group works fine. TNS ping also works fine from both nodes.

    However, the DB service itself does not start. When I try to connect to the database using sqlplus user/pass@service, I get the response "shared memory realm does not exist".

    I tried to play with listeners on both nodes, and I learned that if I configure Oracle listener (listener.ora, tnsnames.ora) with the physical IP address of the node, then everything works fine, the DB service can be started from Cluster GUI and clients can normally connect.

    Any sugestions (even the most obvious ones) will be appreciated.
    Regards
    Tihomir

    % tnsping database

    TNS Ping Utility for Solaris: Version 10.1.0.3.0 - Production on 22-MAR-2007 15:12:41

    Copyright (c) 1997, 2003, Oracle. All rights reserved.

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = database)))
    OK (10 msec)
    %
    % sqlplus system/password as sysdba

    SQL*Plus: Release 10.1.0.3.0 - Production on Thu Mar 22 15:01:55 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 167772160 bytes
    Fixed Size 1301272 bytes
    Variable Size 69477608 bytes
    Database Buffers 96468992 bytes
    Redo Buffers 524288 bytes
    Database mounted.
    Database opened.
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    % sqlplus user/password@database

    SQL*Plus: Release 10.1.0.3.0 - Production on Thu Mar 22 15:03:54 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory


    Enter user-name:

  2. #2
    Join Date
    Mar 2007
    Posts
    2
    Also noticed this, when I try to startup the DB manually:

    % sqlplus /nolog

    SQL*Plus: Release 10.1.0.3.0 - Production on Thu Mar 22 16:23:29 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    SQL> connect / as sysdba
    Connected.
    SQL> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SQL>
    SQL> startup
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SQL> startup mount database
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist

    Is there any place in Oracle configuration where I could make a binding between this virtual IP and hostname for it? I have a feeling that oracle somehow doesn't link between Veritas' virtual IP for oracle, and the virtual hostname which is defined in listener.ora and tnsnames.ora, and which I added into /etc/hosts....

    Or is it Veritas to blame??

    Thanks
    Tihomir

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SEE RESPONSE IN OTHER FORUM
    http://www.orafaq.com/forum/t/78809/74940/
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •