Impossible to connect
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Impossible to connect

  1. #1
    Join Date
    May 2003
    Posts
    5

    Question Impossible to connect

    Impossible to connect through 2 tiers (sqlplus) to the database, we are getting the following error message :
    SQL> conn sys/xxxxx@ora10_linux
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    I have installed & configured 100s of oracle databases and never got this kind of connection problem.

    Server :
    RedHat 8.0
    Client :
    Windows 2000 pro

    Client : 9.2.0.1.0
    Server : 9.2.0.2.0 (fresh installation)

    there are no firewall

    I couldn't succeed a server-side loopback on the database server neither...

    please help, this is very urgent, anyone who had something similar would help me alot, thanks in advance,
    Patrick Hamou
    Last edited by phamou; 05-16-2003 at 12:15 AM.
    Patrick Hamou
    Principal Consultant
    Renaps Technology Canada inc.
    http://www.renaps.com

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Somebody didn't reboot after setting values in /etc/system?

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    First check these

    a)wheather the database is up and running ?
    ps- ef|grep ORA

    b)you cann connect locally using a bequeth connection
    with specifying the net8 string

    c)See metalink note Note:122183.1

    regards
    Hrishy

  4. #4
    Join Date
    Sep 2000
    Posts
    305
    Check it again the Oracle Server is runing or not also reboot the server.

    Hope it will help you
    Shailendra

  5. #5
    Join Date
    May 2003
    Posts
    5

    Thumbs down still not working

    Hi,

    The database is running!

    I rebooted the server, checked the metalink note (and applied the 9.2.0.2.0 patch) and I still have the same results :(

    the error does not look that obvious...

    please let me know if you have other ideas,

    thanks again,

    Patrick Hamou
    Principal Consultant
    Renaps Technology Canada inc.
    http://www.renaps.com
    Patrick Hamou
    Principal Consultant
    Renaps Technology Canada inc.
    http://www.renaps.com

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Is the instance registered with the listener..Try connecting soemthing like this

    export ORACLE_HOME=your_oracle_home
    export ORACLE_SID=oracle-sid

    sqlplus system/manager --without the net8 string

    lemm know what happens

    regards
    Hrishy

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I am running Red Hat 8 with Oacle 9.2.0.1 Enterprise with no problems at all

  8. #8
    Join Date
    May 2003
    Location
    hyderabad, India
    Posts
    10
    Hi

    i am not aware of Oracle behaviour with Linux, but I too have faced the same problems on Win Nt 4.0. It happens mainly when the resources available are not enough to allow connections. Try to shutdown any other database and operating system services associated with this database which has been created in this server and then try again.

    One more thing, whenever u connect as sys , please connect with the tag (as sysdba).

    Thanks

    Partha

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by Partha
    ¡One more thing, whenever u connect as sys , please connect with the tag (as sysdba).
    in 9i that´s the only way

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