Error while login to Sqlplus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error while login to Sqlplus

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Error while login to Sqlplus

    Hi All,
    Greetings,

    OS-sunsolaris
    oracle 8.0.6
    when i try connecting sqlplus with user name and password.i am getting below error.

    ERROR:
    ORA-27500: inter-instance IPC error
    ORA-27300: OS system dependent operationort_create failed with status: 134
    ORA-27301: OS failure message: Transport endpoint is not connected
    ORA-27302: failure occurred at: skgxpcini1

    Please help in this

    TIA
    Adil

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    To fix this, you need to increase no. of tcp/ip sockets on the unix side. Better contact your sysadmin for the fix.

  3. #3
    Join Date
    Apr 2001
    Posts
    110
    Hi,

    Can you telnet to the server and check if the Oracle instance is running?
    Check the alert.log, see what other errors or what happened before you encounter this error.

    From the error ORA-27300: "OS system dependent operation:"port_create" failed with status:134", it may seem that your Oracle instance did not startup properly.

    Did anyone changed the server IP address recently?

    Cheers
    Oracbase
    What's next after 10g?

  4. #4
    Join Date
    Apr 2001
    Posts
    110
    Hi,

    Please go with Sunil's advice. He should be right.

    Cheers
    What's next after 10g?

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