Results 1 to 14 of 14
  1. #1
    Join Date
    Apr 2009
    Posts
    6

    Unanswered: SID given in connect descriptor could not be resolved

    I am a student and i know nothing about oracle, but i am getting this error when i try to connect to my database. please help me and please keep it simple

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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
    Apr 2009
    Posts
    6

    not helpful

    I googled it before i joined this forum, but it does not make sense to me

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You are NOT HELPFUL either.

    Post Operating System (OS) name & version for DB server system.
    Post Oracle version to 4 decimal place of database s/w.
    Post Operating System (OS) name & version for client system.
    Post Oracle version to 4 decimal place of client s/w.
    Post client environmental variables (either SET or env | sort )


    You have not shown us via CUT & PASTE what you actually did or how Oracle responded.
    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.

  5. #5
    Join Date
    Apr 2009
    Posts
    6
    i do not understand how to bounce the listener..
    lsnrctl status
    # add to listener.ora file new SID entry
    lsnrctl stop
    lsnrctl start

    this does not make sense to me how do i do that
    Edit/Delete Message

  6. #6
    Join Date
    Apr 2009
    Posts
    6

    database

    I have windows 2003 on VM. I installed Oracle 10 on it. I created a database and it was working fine until tonite when i had to do a shutdown on it because the server was hung up and would not respond. when i brought it back up and tried to connect to the database that is when i got that error

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    use cut & paste with following 2 commands as owner or oracle s/w tree
    lsnrctl status
    lsnrctl start
    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.

  8. #8
    Join Date
    Apr 2009
    Posts
    6
    do i use a command prompt or where do I type those commands. I am a beginner

  9. #9
    Join Date
    Dec 2007
    Posts
    253
    Yes, use a command prompt

  10. #10
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Go into Windows Services, you should see a service called "OracleService<your database name>" ; ensure that it has started (I suspect not).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  11. #11
    Join Date
    Dec 2009
    Posts
    8
    hi, saw this thread..
    so u manage to solve ur problem, i facing the same prob as u now.
    when i shut down my oracle server, n start it up, i cannot log into the database.

    any one noe how to solve. all the oracel services is started up.

  12. #12
    Join Date
    Jul 2007
    Posts
    4
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\admin>sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 1 12:14:36 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL>


    Try this and update

    SQL> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 167772160 bytes
    Fixed Size 1247876 bytes
    Variable Size 83887484 bytes
    Database Buffers 75497472 bytes
    Redo Buffers 7139328 bytes
    Database mounted.
    Database opened.
    SQL>


    Try this and update

  13. #13
    Join Date
    Jul 2007
    Posts
    4
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\admin>sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 1 12:14:36 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL>


    Try this and update

    SQL> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 167772160 bytes
    Fixed Size 1247876 bytes
    Variable Size 83887484 bytes
    Database Buffers 75497472 bytes
    Redo Buffers 7139328 bytes
    Database mounted.
    Database opened.
    SQL>


    Try this and update

  14. #14
    Join Date
    Dec 2009
    Posts
    8
    wah, it WORKS.... tks tks...

    But what cause this problem? n i find that everytime i shut down the db server, the same problem appear.. then i have to startup the database again??

Posting Permissions

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