DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: oracle connection problem from win2000 to aix

  1. #1
    Join Date
    Jan 2002
    Posts
    50

    Question oracle connection problem from win2000 to aix

    hello
    friends
    i have oracle 8.1.7 on aix machine and
    i am able to work on the same under aix
    but when i try to connect from the win2000
    client i am getting following errors

    ***************************************
    ora-01034 oracle not available
    ora-27101 shared realm does not exist

    ****************************************


    can any body help me
    why this error is coming

    while my database is working properlly....


    help is allways welcome

    bhushan

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    How are you trying to connect ??

    I hope you are using connect_string to connect to remote database on AIX

    Have you created your tnsnames.ora file ??

    show us the TNSNAMES.ora file...
    and sqlnet.ora
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    it seems that the database which you address in tnsname.ora is down!

    check tnsnames.ora which sid is used for connection. Is the instance started at the aix-server?

    Orca777


  4. #4
    Join Date
    Jan 2002
    Posts
    50

    my tnsnames.ora

    hello
    i think my tnsnames.ora is correct
    i am sending my tnsname.ora from my win2000 os
    ***********************************************************
    i am also getting the following error after the oracle error complete

    IBM AIX RISC system 6000 error:2: NO SUCH FILE OR DIRECTORY

    *********************************************
    *****
    my p and p1 connect string is for the db on win2000 machine
    and
    h and h1 connect string is for the database on the aix server
    ip is 132.147.2.27
    **********************************************************
    p =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = idserver)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = hurtado)
    )
    )

    p1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.147.2.169)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = STARPROD)
    )
    )

    h =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.147.2.27)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = hurtado.hurtado.com)
    )
    )


    h1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.147.2.27)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = hurtado)
    )
    )


    ********************************+
    my sqlnet.ora file is
    *********************************

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES)



    hope to get help

    bhushan
    Last edited by BHUSHAN; 03-06-2003 at 10:42 AM.

  5. #5
    Join Date
    Feb 2003
    Posts
    40
    Bhushan,
    Just a day before U have raised a forum 'Listener hangs'.
    I have posted my reply there .But after that U have not posted ur reply.So I suspect if u have resolved listener issue first?


    Comparing the Listener.ora file which U have presented there
    and tnsnames.ora which u have given in this forum
    I guess that U are trying to connect to 'hurtado'.

    Check with 'tnsping h1 'first.I suspect that it is trying to connect to ORCL in ur aix instead of 'hurtado'.


    When U raise a forum and if someone is spending time to post a reply,
    pls respond to it .

    Even if it doesnot solve the problem update the forum saying so,
    so the person who has posted the reply will come to know if their solution has helped or not.
    K.Chithra
    Oracle DBA

  6. #6
    Join Date
    Jan 2002
    Posts
    50

    conenction problem

    hello friends
    i think my listener is main problem
    as i give any kind command on
    lsnrctl> prompt it gets time outs except starting it...
    that to after a long time....
    so i am again sespecting the problem is listenet ...

    and remaining the connection problem it still the same
    can any body tell me
    where is the problem is


    bhushan

  7. #7
    Join Date
    Feb 2003
    Posts
    40
    Bhushan,

    check out this :

    http://www.dbasupport.com/forums/sho...listener+hangs


    Keep track of what forums u raise.
    Read the previous reply where I have asked if listener probs
    has been solved in the first place.
    K.Chithra
    Oracle DBA

  8. #8
    Join Date
    Jan 2002
    Posts
    50

    LISTENER problem

    it is still having the same problem
    i did tryed the gerp and it shows the process for listener
    but for connection from win2000 i have the same
    ora-27101 prblem


    i am putting the ps -ef | grep tns output

    @aix /oracle$ ps -ef | grep tns
    oracle 11444 9814 0 19:43:48 pts/1 0:00 grep tns
    oracle 12396 1 0 19:56:55 pts/0 0:00 /oracle/app/oracle/product/8.1.7/bin/tnslsnr listener -inherit




    bhushan
    Last edited by BHUSHAN; 03-07-2003 at 05:29 AM.

  9. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Just answer a few questions.

    On AIX

    1. Hostname and ip address of the aix machine
    2. ORACLE_HOME path
    3. give me the output of the following.

    Select * from global_name;

    select instance from v$thread;

    select status from v$instance;

    show parameter db_name;

    Lets first solve the problem on AIX then we will move to 2000 (forget it for the time being)
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  10. #10
    Join Date
    Jan 2002
    Posts
    50

    hello

    i am giving u the info u wanted

    host name AIX
    ip address 132.147.2.27
    home path
    /oracle/app/oracle/product/8.1.7


    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------
    HURTADO.HURTADO.COM


    SQL> select instance from v$thread;


    INSTANCE
    ----------------
    HURTADO


    SQL> select status from v$instance;


    STATUS
    -------
    OPEN


    SQL> show parameter db_name;


    NAME TYPE VALUE
    ------------------------------------ ------- -------------db_name string hurtado

    hello mr. amar
    did the value of parametr db_name hurtado
    in lower case and the instance name HURTADO
    in Upper case make the diffrences


    bhushan

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