Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    4

    Unanswered: Can connect Oracle SQL Developer

    Hi! I'm learning how to use Oracle data base 10g with Oracle SQlL Developer, but now I can't connect the data base and I don't know why. Whe I try to connect, this error appears:

    An error was encountered performing the requested operation:

    Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given
    in connect descriptor
    The Connection descriptor used bye the client was:
    localhost:1521:xe

    Vendor code 0

    PD: In case of misspellings I don't speak english very well, so if I made any mistake, please correct me!

    Greetings,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Was the database started?
    Is the database online?

    open command window
    issue the following commands

    set
    lsnrctl status
    lsnrctl service


    CUT commands and results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2010
    Posts
    4
    When I typed the commands, the commands line tell me this:

    "Environment variable isnrctl not defined."

    well, I updated my PC, then restared and the program launched with no problems. It Could be that the trouble ?

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    read up on NET SERVICES to learn how to diagnose these types of issues.
    Contents


    it sounds like you had a local database on your machine which you could not connect to.
    Ana was asking you to determine if the listener was up or not.
    read up on (starts with an "L") lsnrctl and how to use effectively.
    also read up on tnsping.

    use sqlplus commandline too.

    FYI - rebooting the machine restarted the database and the listener which solved your immediate issue. This of course does not solve the issue of you learning how to diagnose these problems when they come up.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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