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

Thread: shutdown and startup problem

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    shutdown and startup problem

    Hi,

    I have 2 databases on the same M/c iam able to startup and shutdown one database ORACLE 7.3.4 but for another database ORACLE 8.0.4 iam unable to shutdown or startup . Any one Plz help me.


    All backgroundare running.


    $ echo $ORACLE_SID
    ops5
    $ sqlplus internal

    SQL*Plus: Release 8.0.4.0.0 - Production on Wed Jul 2 23:5:37 2003

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    Error accessing PRODUCT_USER_PROFILE
    Warning: Product user profile information not loaded!
    You may need to run PUPBLD.SQL as SYSTEM

    Connected to:
    Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
    With the Partitioning and Objects options
    PL/SQL Release 8.0.4.0.0 - Production

    SQL> select * from v$database;
    select * from v$database
    *
    ERROR at line 1:
    ORA-01507: database not mounted


    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-01102: cannot mount database in EXCLUSIVE mode


    SQL> shutdown
    unknown command "shutdown" - rest of line ignored.
    SQL> !
    (f1n01) /home/oracle
    $ ps -ef |grep ora_
    oracle 13132 1 0 03:13:11 - 0:00 ora_dbw0_ops5
    oracle 14918 1 0 May 27 - 0:24 ora_ckpt_ops3
    oracle 15426 1 0 May 27 - 1:45 ora_lgwr_ops3
    oracle 17994 1 0 May 27 - 14:40 ora_smon_ops3
    oracle 19002 1 0 May 27 - 0:42 ora_pmon_ops3
    oracle 20052 1 0 03:13:11 - 0:00 ora_lgwr_ops5
    oracle 22334 1 0 May 27 - 180:37 ora_dbwr_ops3
    oracle 22606 1 0 May 27 - 0:00 ora_reco_ops3
    oracle 23620 1 0 03:13:11 - 0:00 ora_pmon_ops5
    oracle 24420 1 0 03:13:12 - 0:00 ora_smon_ops5
    oracle 24924 1 0 03:13:11 - 0:00 ora_ckpt_ops5
    oracle 28424 27114 3 23:07:01 pts/2 0:00 grep ora_
    (f1n01) /home/oracle
    $
    J Gangadhar

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you run catproc.sql on this?

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