DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 20

Thread: Oracle Patchset Issue

Threaded View

  1. #7
    Join Date
    Dec 2010
    Posts
    11
    hey that looks like we're getting somewhere! All services set to autostart. Instance was Idle. Here's the output:

    D:\oracle\product\10.2.0\db_1\BIN>echo %oracle_sid%
    orcl

    D:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

    SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 27 12:19:36 2010

    Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

    SQL> conn / as sysdba
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 612368384 bytes
    Fixed Size 1304752 bytes
    Variable Size 171968336 bytes
    Database Buffers 436207616 bytes
    Redo Buffers 2887680 bytes
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced


    SQL>

    What should I try next? How come I have to manually start the instance? Do I have to do this every time? Why is it terminating?

    Also, nothing in the Application Event Log that tells me why I got the ORA-01092, is there a logfile somewhere?

    Thanks
    Last edited by dontinou; 12-27-2010 at 12:42 PM.

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