Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    26

    Unanswered: Cannot connect to database

    This morning, I connected to my db as sysdba and then shut it down.

    Then, I used winzip to copy the datafiles but noticed that I was getting winzip warnings that stated that the file was still open and could get corrupted. So I stopped winzip and stopped all Oracle processes, then tried it again. This time with no problems.

    I rebooted my system but now I can't connect using sqlplus or Oracle Enterprise Manager.

    I've got several errors ranging from ORA-12500 to ORA-1113 - during alter database open (aodbalert.log)

    In the event viewer (Win2k Server) it tells me that I have to restore the media on one of my datafiles which I replaced with the latest backup.

    But that doesn't seem to help me if I can't connect to start the database to do the recovery.

    Any ideas?

    Thanks in advance,

    John

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Sounds like you will have to perform media recovery ...
    from SQLPlus or svrmgrl, try to open the database... It should tell
    you what file or tablespace needs media recovery...

    HTH
    Gregg

  3. #3
    Join Date
    Oct 2003
    Posts
    26
    Originally posted by gbrabham
    Sounds like you will have to perform media recovery ...
    from SQLPlus or svrmgrl, try to open the database... It should tell
    you what file or tablespace needs media recovery...

    HTH
    Gregg
    Gregg, The event viewer told me what file to replace (and I did) but now I cannot connect to the database to start/open it to perform the media recovery.

    I tried to log in using sqlplus (using SYSTEM pwd) but get the following error:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory relm does not exist

    When I log into Enterprise Manager, it notifies me that the db is shutdown and that I have to log in as sysdba (which I do as SYSTEM) but it says that I have insufficient privilages...

    John

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Media recovery is not necessarly restoring files from backup... You
    do Oracle media recovery on the file, tablespace or database.

    You should be able to log in to the database (thru sqlplus or svrmgrl)
    as INTERNAL and attempt to bring up the database.

    svrmgrl> connect internal/password@xxx (xxx is the instance)
    svrmgrl> startup pfile=c:\oracle\admin\....\initxxx.ora

    This should start the database and tell you what the problem is
    ie, file .... needs media recovery or some other Oracle error. The
    error number can be looked up in the Oracle Documentation or
    on the Metalink web site ...

    HTH
    Gregg

  5. #5
    Join Date
    Oct 2003
    Posts
    26
    Originally posted by gbrabham
    Media recovery is not necessarly restoring files from backup... You
    do Oracle media recovery on the file, tablespace or database.

    You should be able to log in to the database (thru sqlplus or svrmgrl)
    as INTERNAL and attempt to bring up the database.

    svrmgrl> connect internal/password@xxx (xxx is the instance)
    svrmgrl> startup pfile=c:\oracle\admin\....\initxxx.ora

    This should start the database and tell you what the problem is
    ie, file .... needs media recovery or some other Oracle error. The
    error number can be looked up in the Oracle Documentation or
    on the Metalink web site ...

    HTH
    Gregg
    Gregg, I was having problems logging into sqlplus (svrmgrl is not loaded) and ended up having to restore the pwd file. That worked.

    Then I used your advice regarding recovery of the file and that worked!
    Thanks for your help!

    John
    Last edited by ruluckie; 10-15-03 at 05:35.

  6. #6
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    Originally posted by ruluckie

    I tried to log in using sqlplus (using SYSTEM pwd) but get the following error:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory relm does not exist

    John
    are you using Windows Domains ?
    if yes, try to start the services as a member of this domain (not local admin!)

    you can also try to set SQLNET.AUTHENTICATION_SERVICES=
    (NONE) in SQLNET.ORA
    ^/\x

Posting Permissions

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