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

Cannot Mount Database In Exclusive Mode In Windows

I stopped two of the services and used the following from command prompt. Now the database can start. Verify that file $ORACLE_HOME\dbs\sgadef{sid}.dbf does not exist where sid is your actual database SID. From alert log if you see error related to permission denied" then ensure that in the file/directory oracle has permission and ensure that oracle is owner of the file. Check This Out

Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: Re: Re: ora-01102 cannot mount the standby database 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 operating system is windows NT. http://www.orafaq.com/forum/t/37693/

Database dismounted. Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-09-2001,08:19 PM #1 konnurured View Profile View Therefore, the ORA-01102 error is misleading and may have occurred due to one of the following reasons: - there is still an "sgadef.dbf" file in the "ORACLE_HOME/dbs" directory - the processes This tool uses JavaScript and much of it will not work correctly without it enabled.

Good luck. if so how is it?. Oliver Pereira Nov 22, 2003, 19:35 Under UNIX maybe, but Windows! If you are not able to shutdown the database properly.

when i startup the database it is giving the error ora-01102 cannot mount the database in exclusive mode. Total System Global Area 135339844bytes Fixed Size 454468bytes Variable Size 109051904bytes Database Buffers 25165824bytes Redo Buffers 667648bytes ORA-01102: cannot mount database in EXCLUSIVE mode SQL> alter database open; alter database open Hudspith 8500 10 A. Is the problem because Instance names are same?

Let me know if any errors were reported on shutdown. Can you shutdown all Oracle database services/instances etc on that machine and restart only the standby instance, and see if the error occurs. A file named ORACLE_HOME\dbs\sgadef{sid}.dbf exists where SID is your actual database SID. I am unable to start the instances.

pullahni Veetil Lacit Nov 24, 2003, 11:57 Check you environment variable ie. Hidayathullah ... 11300 9 A. Karam) The Oracle docs note this on the ora-01102 error: ORA-01102 cannot mount database in EXCLUSIVE mode Cause: Some other instance has the database mounted exclusive or shared. Nick.

ORA-01012: not logged on ORA-01102: cannot mount database in EXCLUSIVE mode... his comment is here Nick. users last 24h16Act. Re: ORA-01102: cannot mount database in EXCLUSIVE mode Aman....

give me the solution . Action: Shut down the other instance or mount in a compatible mode. ORA-01102 occurs when you are mounting (opening) a database, typically because another instance is already opened in parallel (exclusive) You can have two databases running on the same machine but you should have sufficient real memory for SGAs of both the databases. http://ecoflashapps.com/cannot-mount/ora-01102-cannot-mount-database-in-exclusive-mode-rac.html should i have to change the mode to startup the database?.

is this problem because of two databases or any other problem?. Wisse 13350 6 J. Then I started the next service by setting ORACLE_SID=mysid and did the same steps as above.

Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New?

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 Solution: Verify that there are no background processes owned by "oracle" $ ps -ef | grep ora_ | grep $ORACLE_SID. Join this Blog for direct reference of any post into your inbox. is it possible.

what is exclusive mode?. 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 I have three databases on the same machine. navigate here Posted by Shahid Ahmed at 1:03 pm Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Ora-Errors 0 comments: Post a Comment Subscribe to: Post Comments (Atom) Certification Popular Posts Install

The real cause of ORA-01102 would be found in the alert log file where you will find additional information. Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication So before u run svrmgrl for each instances, u have to set environmental variable i.e. From your alert log if your instance was shutdown properly the last time. 2.

Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select name from v$database 2 ;NAME---------ORACLE10SQL>ReplyDeleteAdd commentLoad more... Copy your init.ora with OS commands, change the required parameters in the second init.ora and then open both databases one by one with pfile=' '. jigar doshi Nov 22, 2003, 09:06 hi jigar in alert.log i am getting only the erro......