Dear Sir.
Now i have some problem about ORACLE
-------------------------------------------------------------
SQL> startup mount pfile='/oracle/app/oracle9i/product/9.2.0/dbs/
initTHRBTE.ora'
ORACLE instance started.
Total System Global Area 1309743464 bytes
Fixed Size 452968 bytes
Variable Size 503316480 bytes
Database Buffers 805306368 bytes
Redo Buffers 667648 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL>
SQL>
SQL>
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
------------------------------------------------------------------------
Please help me
kamolp
@gmail.com wrote in news:1177796020.062426.159810
@q75g2000hsh.googlegroups.com:
> Dear Sir.
> Now i have some problem about ORACLE
> -------------------------------------------------------------
> SQL> startup mount pfile='/oracle/app/oracle9i/product/9.2.0/dbs/
> initTHRBTE.ora'
> ORACLE instance started.
> Total System Global Area 1309743464 bytes
> Fixed Size 452968 bytes
> Variable Size 503316480 bytes
> Database Buffers 805306368 bytes
> Redo Buffers 667648 bytes
> ORA-01102: cannot mount database in EXCLUSIVE mode
> SQL>
> SQL>
> SQL>
> SQL> select open_mode from v$database;
> select open_mode from v$database
> *
> ERROR at line 1:
> ORA-01507: database not mounted
> SQL> alter database open;
> alter database open
> *
> ERROR at line 1:
> ORA-01507: database not mounted
> ----------------------------------------------------------------------
--
> Please help me
Might it already be opened?
01102, 00000, "cannot mount database in EXCLUSIVE mode"
// *Cause: Some other instance has the database mounted exclusive or
shared.
// *Action: Shutdown other instance or mount in a compatible mode.
You neglected to post the WHOLE session; like starting BEFORE you issued
the sqlplus command. What happens if you:
SQL> SHUTDOWN ABORT
SQL> startup mount
pfile='/oracle/app/oracle9i/product/9.2.0/dbs/initTHRBTE.ora'
-----------------------------------------------Reply-----------------------------------------------
kamolp
@gmail.com wrote:
> Dear Sir.
> Now i have some problem about ORACLE
> -------------------------------------------------------------
> SQL> startup mount pfile='/oracle/app/oracle9i/product/9.2.0/dbs/
> initTHRBTE.ora'
> ORACLE instance started.
> Total System Global Area 1309743464 bytes
> Fixed Size 452968 bytes
> Variable Size 503316480 bytes
> Database Buffers 805306368 bytes
> Redo Buffers 667648 bytes
> ORA-01102: cannot mount database in EXCLUSIVE mode
> SQL>
> SQL>
> SQL>
> SQL> select open_mode from v$database;
> select open_mode from v$database
> *
> ERROR at line 1:
> ORA-01507: database not mounted
> SQL> alter database open;
> alter database open
> *
> ERROR at line 1:
> ORA-01507: database not mounted
> ------------------------------------------------------------------------
> Please help me
Tail the alert log. What does it say?
--
Daniel A. Morgan
University of Washington
damor
@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org