sqlplus Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlplus Urgent

  1. #1
    Join Date
    Aug 2000
    Posts
    32

    sqlplus Urgent

    Hi,
    Database is up and Running.Listner is also up and running.Problem is I am not able to connect to sqlplus.After shutting down the database and again restarting the database and listener I am able to connect.What is the causes.I checked in logs and trace files also.Nothing was generated.Any suggestion.

    Rgds
    Venkatesh Babu

  2. #2
    Join Date
    Dec 2002
    Location
    India & Australia
    Posts
    68

    Re: sqlplus Urgent

    Originally posted by venkattr
    Hi,
    Database is up and Running.Listner is also up and running.Problem is I am not able to connect to sqlplus.After shutting down the database and again restarting the database and listener I am able to connect.What is the causes.I checked in logs and trace files also.Nothing was generated.Any suggestion.

    Rgds
    Venkatesh Babu

    Is it giving the TNS related connection is lost?

    Check out?

    If that is so find proper NET connection established.

    Perhaps checkout from its scratch

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why dont you try posting the error message, might be able to help then

    tried tnsping?

    contents of tnsnames.ora sqlnet.ora listener.ora?

    version?

    didnt get a crystal ball for xmas over here.
    Last edited by davey23uk; 12-26-2002 at 06:17 PM.

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    UNIX or Windows? Where are you starting SQL*Plus from? TNS_ADMIN? Path?

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