Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2008
    Posts
    5

    Unanswered: ORA-1113:Can not open database

    I am getting "ORA-1113:Can not open database" and ORA-01034:Oracle not available" when I am trying to connect to oracle database.

    I haven't found any solution to it on net.

    Anyone faced similar issue? How did you make it working?

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Do you mean you have tried all the solutions you've found on the net, or you can't finad anything to try?

    Try the following threads for advice:

    http://www.orafaq.com/forum/t/47579/0/

    http://www.dbforums.com/archive/index.php/t-928073.html

    http://qaix.com/oracle-database-deve...ase-read.shtml
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Apr 2008
    Posts
    5
    Well I do have seen your links.

    First link has this answer:

    check on the server, if oracle database is running.
    Also check the alert.log file on oracle server.

    I am not sure, how to check if oracle server is running or not? I am running on Windows 98 so services.msc or netstat are not working. Let me know how to see running services on Windows 98. What if user haven't selected it (oracle server) to run it as a windows service? How can I see it running in such case? How can I start a service in Windows 98?

    I am supporting this problem on phone so can't see alert.log file but I have a feeling that log file will also contain the same error with no more useful details.

    http://qaix.com/oracle-database-deve...ase-read.shtml

    Above link mention something about oradmin command. Will it start oracle server? I don't have access of that machine so can't try it out.

    So I wanted an advice of a person who faces similar issue.

    BTW, it's oracle 8i.

    And the left one link has no relation with my problem, I suppose.

    Thanks.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Which version of Oracle RDBMS to four decimal places?

    When was the last time this worked properly?

    What changed since it last worked?
    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 2008
    Posts
    5
    Are you really serious about answering (and helping)?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If you won't answer my questions, then I won't answer yours.

    You're On Your Own (YOYO)!
    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.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The question by Ana is valid. Is this an existing installation that stopped or is it a new installation that will not work?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    metalink no longer shows any compatibility matrix for "8i" or Windows 98.
    My failing & feeble memory is 100% cloudy when it comes to supported configurations that old.

    Rhetorical question - does OP have a supported mix of hardware, OS, & Oracle s/w?
    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.

  9. #9
    Join Date
    Apr 2008
    Posts
    5
    Quote Originally Posted by anacedent
    Which version of Oracle RDBMS to four decimal places?

    When was the last time this worked properly?

    What changed since it last worked?
    1. It's oracle 8i. Is four decimal places required?

    2. It was working before a guy copied an excel file from the same computer to his pen drive. I am not sure what else he did but it (oracle) stopped working after that...

    I thought you asked sarcastically. Sorry.

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >It's oracle 8i. Is four decimal places required?
    What works in 1 version does not work in another.
    Knowing EXACTLY which version being used can help to isolate the issue.
    If "8i" were sufficient, then Oracle would not bother with having 4 decimal places to denote different versions.
    Last edited by anacedent; 04-09-08 at 10:46.
    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.

  11. #11
    Join Date
    Apr 2008
    Posts
    5
    Quote Originally Posted by anacedent
    >It's oracle 8i. Is four decimal places required?
    What works in 1 version does not work in another.
    Knowing EXACTLY which version being used can help to isolate the issue.
    If "8i" were sufficient, then Oracle would not bother with having 4 decimal places to denote different versions.
    It's not that different versions have everything different. As I said, I am supporting this on phone so can't know the decimal places you are talking about...

Posting Permissions

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