-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|