Home > Cannot Mount > Cannot Mount Database In Exclusive Mode In Windows

Cannot Mount Database In Exclusive Mode In Windows

Noel. Regards. Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: ora-01102 cannot mount the standby database in exclusive Nick. Check This Out

Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: ora-01102 cannot mount the standby database in exclusive mode Kavsek 15550 5 P. I stopped two of the services and used the following from command prompt. There are occasions where the standby shuts down only with shutdown abort. 4. Go Here

It may happen that even though no memory is allocated, Oracle thinks memory is still locked. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select name from v$database 2 ;NAME---------ORACLE10SQL>ReplyDeleteAdd commentLoad more... I have three databases on the same machine. Verify that there is not a "sgadef.dbf" file in the directory "ORACLE_HOME/dbs". % ls $ORACLE_HOME/dbs/sgadef.dbf If this file does exist, remove it. % rm $ORACLE_HOME/dbs/sgadef.dbf 2.

How can i start instances manually? Verify that there are no background processes owned by "oracle" % ps -ef | grep ora_ | grep $ORACLE_SID If background processes exist, remove them by using the Unix command "kill". Cannot see Oracle ODBC driver in datasource admini... Verify that no shared memory segments and semaphores that are owned by "oracle" still exist % ipcs -b If there are shared memory segments and semaphores owned by "oracle", remove the

Errata? Schnackenberg 13300 7 T. and recover the standby database.For applying archive log i am shutting down the database.After that startup nomount alter database mount standby database; ERROR at line 1: ORA-01102: cannot mount database in should i have to change the mode to startup the database?.

Sometimes it cause due to setting incorrect ORACLE_SID environment specially for newly created database check you have set the correct CASE of ORACLE_SID in .base_profile. ORA-01012: not logged on ORA-01102: cannot mount database in EXCLUSIVE mode... set oracle_sid=the active sid name sqlplus /nolog At the sqlprompt... Verify experience!

Nick. Error Code: 0x000000C4 (Windows 8) 5 Comments Steps to Upgrade SAP Support Package Stack using SUM 4 Comments Procedure Before Stopping an SAP System - ABAP Stack 4 Comments User is Database dismounted. is this problem because of two databases or any other problem?.

Re: ORA-01102: cannot mount database in EXCLUSIVE mode 647468 Jan 1, 2009 10:32 AM (in response to user00726) It seems to be previous db instance was not shutdown completely, check any his comment is here You can not post a blank message. SQL> alter system set cluster_database_instances=2 scope=spfile; System altered. Awesome Inc.

Kailash Hingorani Nov 24, 2003, 21:12 Follow up by mail Click here Subject: ora-01102 cannot mount the standby database in exclusive mode Author: pankaj turang, India Date: Nov 22, 2003, 08:11, connect sys as sysdba startup force pfile='.....' from the command prompt and it worked! pullahni Veetil Lacit Nov 24, 2003, 11:57 Check you environment variable ie. this contact form Check the following: 1.

ORACLE_SID is b...... Members Search Help Register Login Home Home» Infrastructure» Windows» ORA-01102: cannot mount database in EXCLUSIVE mode Show: Today's Messages :: Show Polls :: Message Navigator E-mail to friend ORA-01102: cannot can i change the name os the file 'init.ora' now?.

when i startup the database it is giving the error ora-01102 cannot mount the database in exclusive mode.

ORACLE instance started. Powered by Blogger. Oracle 817 Regards, Mabel Report message to a moderator Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #142636 is a reply to message #101377] Mon, 17 October In this case, to start up the database must specify pfile Syntax: startup pfile = OS: Windows 2k Oracle db: 8.1.7 Hope this can help.

can i open 2 databases at a particular point of time by giving startup pfile='.....................' for differnet init.ora files of different databases?. Solution: Verify that there are no background processes owned by "oracle" $ ps -ef | grep ora_ | grep $ORACLE_SID. If these steps leave ORA-01102 unresolved, you may need to try restarting OracleService Oracle DBA Forums contains a good explanation of how ORA-01102 may also be thrown under false pretenses: Question: navigate here Re: ORA-01102: cannot mount database in EXCLUSIVE mode 26741 Jan 2, 2009 1:31 AM (in response to user00726) I wonder why the first two STARTUP attempts resulted in 'insufficient privileges' SQL>

Total System Global Area 1603411968 bytes Fixed Size 2213776 bytes Variable Size 402655344 bytes Database Buffers 1191182336 bytes Redo Buffers 7360512 bytes ORA-01102: cannot mount database in EXCLUSIVE mode I checked SQL> startup pfile='G:\oracle\admin\hotest\pfile\inithotest.ora' ORACLE instance started. Re: ORA-01102: cannot mount database in EXCLUSIVE mode Aman.... Is the problem because Instance names are same?

Results 1 to 5 of 5 Thread: ora-01102 cannot mount database in exclusive mode. ORA-01033: ORACLE initialization or shutdown in pr... HomeAbout ALL CATEGORYOracleSAP BasisLinuxUNIXWebWordpressMySQLGoogleVirtualizationOperating SystemWindowsMaxDBAIXSolarisHP-UXRed HatSuSeMSSQLSoftwareDB2SAPSAP SolmanSAP SecuritySAP ABAPWindows 8Windows 7Windows XPWindows ServerMicrosoftAndroidSAP ParameterOracle Error MessageSAP ProgramASEASE Error Message DatabaseOracleOracle Error MessageMySQLMaxDBMSSQLDB2ASEASE Error MessageInternetWebWordpressGoogleOperating SystemLinuxRed HatSuSeUNIXAIXSolarisHP-UXVirtualizationWindowsWindows 8Windows 7Windows XPWindows ServerAndroidSoftwareMicrosoftSAPSAP BasisSAP If you see you have several databases in your machine and both of them uses have same entry in the parameter control_files and db_name then use correct values belonging to the

V Like Show 0 Likes(0) Actions 2. of course i m talking about unix. While setting the ORACLE_SID environment variable, remember the point it is case sensitive in .bash_profile. You can also try killing oracle.exe as a last resort before restarting the server.