Oracle RAC, problem - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 28 of 28

Thread: Oracle RAC, problem

  1. #21
    Join Date
    Jun 2008
    Posts
    2
    Hi,
    I'm trying the 2 following method and everything was succefully configured to install oracle10+11g on Linux .

    I hope will help you .


    During the installation, both RSH and RSH-Server were installed.
    Enable remote shell and rlogin by doing the following.

    # chkconfig rsh on
    # chkconfig rlogin on
    # service xinetd reload

    Create the /etc/hosts.equiv file as the root user.

    # touch /etc/hosts.equiv
    # chmod 600 /etc/hosts.equiv
    # chown root:root /etc/hosts.equiv

    Edit the /etc/hosts.equiv file to include all the RAC nodes:

    +rac1 oracle
    +rac2 oracle
    +rac1-priv oracle
    +rac2-priv oracle


    And testing without asking for a password :

    ON RAC1 as user root
    #
    # su - orale
    rac1$
    $ rsh rac2 -l oracle
    rac2$
    CTR-D
    rac1$
    rac1$ rsh rac2 "ls"
    rac2$


    Everything is OK...





    =========================
    Configure SSH on each node in the cluster.
    Log in as the "oracle" user and perform the following tasks on each node.

    su - oracle
    mkdir ~/.ssh
    chmod 700 ~/.ssh
    /usr/bin/ssh-keygen -t rsa # Accept the default settings.

    The RSA public key is written to the ~/.ssh/id_rsa.pub file and the private key to the ~/.ssh/id_rsa file.

    Log in as the "oracle" user on RAC1, generate an "authorized_keys" file on RAC1 and copy it to RAC2 using the following commands.

    su - oracle
    cd ~/.ssh
    cat id_rsa.pub >> authorized_keys
    scp authorized_keys rac2:/home/oracle/.ssh/

    Next, log in as the "oracle" user on RAC2 and perform the following commands.

    su - oracle
    cd ~/.ssh
    cat id_rsa.pub >> authorized_keys
    scp authorized_keys rac1:/home/oracle/.ssh/

    The "authorized_keys" file on both servers now contains the public keys generated on all RAC nodes.

    To enable SSH user equivalency on the cluster member nodes issue the following commands on each node.

    ssh rac1 date
    ssh rac2 date
    exec /usr/bin/ssh-agent $SHELL
    /usr/bin/ssh-add

    You should now be able to SSH and SCP between servers without entering passwords.

  2. #22
    Join Date
    May 2008
    Posts
    95

    Exclamation Oracle10g RAC, crs target application are OFFLINE

    Dear Friends,

    I have created RAC db on AIX, but some of the crs target application are OFFLINE.

    $ crs_stat -t -v
    Name Type R/RA F/FT Target State Host
    ----------------------------------------------------------------------
    ora....b1.inst application 0/5 0/0 ONLINE ONLINE ariepdb1
    ora....b2.inst application 0/5 0/0 ONLINE OFFLINE
    ora.ariepdb.db application 0/1 0/1 ONLINE ONLINE ariepdb2
    ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb1
    ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb1
    ora....db1.gsd application 0/5 0/0 ONLINE ONLINE ariepdb1
    ora....db1.ons application 0/3 0/0 ONLINE ONLINE ariepdb1
    ora....db1.vip application 0/0 0/0 ONLINE ONLINE ariepdb1
    ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb2
    ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb2
    ora....db2.gsd application 0/5 0/0 ONLINE ONLINE ariepdb2
    ora....db2.ons application 0/3 0/0 ONLINE ONLINE ariepdb2
    ora....db2.vip application 0/0 0/0 ONLINE ONLINE ariepdb2

    Please help me out !!!
    Thanks & Regards,
    Muz

  3. #23
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    start them then?

  4. #24
    Join Date
    May 2008
    Posts
    95

    Exclamation Oracle RAC, TNS error

    Hi,

    Please help me out, I have created Oracle 10g RAC db, when I connect from Node2 it connected then I m trying to connect from Node1 I am getting this error message.

    Enter user-name: /as sysdba
    ERROR:
    ORA-12162: TNS:net service name is incorrectly specified

    Please send me the solution.

    Thanks,
    Muz

  5. #25
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Rtfm

  6. #26
    Join Date
    May 2008
    Posts
    95

    Exclamation Oracle RAC, TNS error

    What is this mean Rtfm

    & End of Oracle 10g RAC db creation I got this error message.



    Failed to start service "[ariepdb_rac' of cluster db 'ariepdb, 'PRKP-1030': failed to start the service ariepdb_rac

    crs-1006: No more member to consider

    crs-0215: could not start resource ora.ariepdb.ariepdb_rac.cs



    PRKT-1001 error starting instance ariepdb1 on ariepdb1

    crs-0215: could not start resource ora.ariepdb1.ariepdb_rac.cs

    PRKT-1001 error starting instance ariepdb2 on ariepdb2

    crs-0215: could not start resource ora.ariepdb2.ariepdb_rac.cs



    when I m trying to connect from Node1 instance, it through out error.



    Enter user-name: /as sysdba

    ERROR:

    ORA-12162: TNS:net service name is incorrectly specified


    please help me out.
    Thanks,

  7. #27
    Join Date
    Nov 2006
    Posts
    158
    Make sure your ORACLE_SID & ORACLE_HOME are set correctly, then restart whatever node/service that's not starting, using either the srvctl utility or sqlplus...
    Regards,

    divroro12

  8. #28
    Join Date
    May 2008
    Posts
    95

    Smile thanks

    Dear divroro,

    Thanks a lot, I solved this issue, previously i have given in .bash_profile as oRACLE_SID=... now I change it to ORACLE_SID=..., I think this is character sensetive issue.

    Once again thanks for your suggestion.

    Regards,
    Muz

Posting Permissions

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



Click Here to Expand Forum to Full Width