This discussion is archived
1 2 3 Previous Next 35 Replies Latest reply: Feb 25, 2013 9:08 AM by jgarry Go to original post RSS
  • 15. Re: Parallel instances?
    EdStevens Guru
    Currently Being Moderated
    newbieDBA wrote:
    Aman.... wrote:
    The error means that if you are running database instances without installing clusterware software and has not enabled RAC, oracle won't let a db open more than one instance. If you are going to mount one instance, the another instance won't be able to get mounted and if you want to do that, you would need RAC to be installed and the db has to be a RAC db. In the absence of the RAC, you would be able to only go ahead with different instances for different databases.
    let me try to be more specific

    old instance name : ordb (have its database)
    1.used oradim to create new instance
    2.i didnt created database
    3.i used old instance's pfile to start database , it started ,
    4.i created Spfile from pfile and then Pfile from SPfile
    5.i tried open database with new instance but "cannot open database in xclusive mode"
    6.changed SID to old one ,shutdown database
    7.changed SID to New one opened database , and it was opened

    Now i am realizing that unknowingly i was trying to set up RAC ( lol )
    am i right sir?
    I disagree with Aman on this one (and hang around long enough and you'll see he and I disagree very little). But the disagreement stems from a difference in our understanding of what you have and are trying to do. See my response to him.
  • 16. Re: Parallel instances?
    EdStevens Guru
    Currently Being Moderated
    newbieDBA wrote:
    EdStevens wrote:
    newbieDBA wrote:
    Hello guy, i have created an another instance on a single machine
    i got error when starting up a new one - error starting up database in exclusive mode
    , so i shutdown older database instance , to start new one
    ......now is it possible to run both instance parallel? without shutting anyone

    Thanks
    I have a test server with 10 separate instances running at the same time.
    10 separate instances sharing one database?? single machine?
    Yes. Not an ideal situation, but they are all test systems and most of them are idle most of the time.
  • 17. Re: Parallel instances?
    EdStevens Guru
    Currently Being Moderated
    newbieDBA wrote:
    EdStevens wrote:
    Duplicate thread makes life even more confusing


    Parallel instances?
    I apologize for that , but when i clicked " post new thread" it hanged i clicked twice and it was double thread ..
    i tried to find delete thread , i couldnt , i had to leave the place ...when i came back both got replies , and i was trying to be nice to replying back to them
    YOu can't delete a thread, but you can edit a posting ... which means you can delete all content and leave an empty message. The 'double' posting happens a lot here. First, be patient and don't double click. Second, if you DO get a multi-post, just edit all but one of them. Delete all the original content and replace it with "deleted duplicate post". People will understand.
  • 18. Re: Parallel instances?
    Aman.... Oracle ACE
    Currently Being Moderated
    Aman,

    I really don't think RAC or lack of clusterware is his problem. It looks to me like he has/wants two distinct databases. I strongly suspect that the issue is that his two init/spfiles are identical except in name only, so they are both trying to start with the same DB_NAME value.
    Yes Ed, I think I got too confused with what's going on. Read a little more carefully and found that there was a talk for two databases ORDB and ORACLE and I think that's what you mentioned that the OP is trying to start second db with the files of it being copied from one and still referring to first db. Wow, even this sentence is confusing :) .

    Thanks for the correction and regards
    Aman....
  • 19. Re: Parallel instances?
    jgarry Guru
    Currently Being Moderated
    I think you are both talking about the same error from different viewpoints. Oracle has the ability to do RAC - multiple instances for the same database - and there is some init.ora error that is setting that off.
    $ oerr ora 1102
    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.
    I'd guess the controlfiles ought to be different, at least. There might want to be a reference to the ORACLE_SID in the pathnames for everything, as well as in the names of the spfiles. Haven't totally thought the necessary differences through in years.

    Edit: Oh, now I see this is explained in the, excuse the term, parallel thread.

    Edited by: jgarry on Feb 21, 2013 4:59 PM
  • 20. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    EdStevens wrote:
    newbieDBA wrote:
    Version : 10.2.0
    No longer supported but unfortunately often required because app vendors won't certify their apps. I've got one like that.
    does it supports 11 r2?
    Does "what" supports 11 r2. What are you asking about?
    i thot u said multiple instances cant share a single database !! what u actually said about "no longer supported"
    >>>
    Exact Error : ORA 01102 : cannot mount database in exclusive mode
    sharing same oracle_home, different sid
    i can only open database alternative , cant parallel

    .. i jst created instance using oradim , and then used same pfile to open , then created spfile and pfile visa versa
    That's probably your problem. init.ora and spfiles contain values that are specific to a given database instance. When you create a new db/instance, you can use the init.ora file from another database as a template, but you must modify it accordingly before using it
    Thanks for the advice sir! but what it will make difference and where? ( my database is already running ) & what could be the disadvantages of them ? or mayb thats why only im facing this problem of running parallel instances?
    Your database is running only one at a time. Probably because both think they are the same, because you didn't modify the init/spfile correctly. So when you try to start the second, his init. ora or spfiile tells him he's the same as the one that is already running. Show us the contents of both init.ora files
    Now i doubt thats the main Mistake of all

    >>
    And what is the current value of ORACLE_SID when you start sqlplus?
    c:\ cd %ORACLE_HOME%\database
    c:\ dir init*
    c:\ dir spf*
    c:\ set ORACLE_SID=nameofdatabase
    c:\ sqlplus / as sysdba
    sql> shutdown immediate
    sql> startup
    i change accordingly as per need to open database , i have 2 instances ( means 2 database right? ) ORDB and ORACLE
    i change SID and open database after shutting down another one !!
    I was trying to access both database without shutting any one , ....like just change SID and access that database
    Well, I gave you that series of commands expecting you to execute them, the copy and paste the entire session so we could see for ourselves instead of depending on your interpretations.
    Sorry Sorry !! here it is...


    M+icrosoft Windows [Version 6.1.7601]+
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

    C:\Users\Administrator>E:

    E:\>cd oracle\product\10.2.0\db_1\database
    The system cannot find the path specified.

    E:\>F:

    F:\>cd oracle\product\10.2.0\db_1\database

    F:\oracle\product\10.2.0\db_1\database>dir init*
    Volume in drive F is Oracle
    Volume Serial Number is 0A44-8FF6

    Directory of F:\oracle\product\10.2.0\db_1\database

    +20-02-2013 17:22 1,142 INIToracle.ORA+
    +1 File(s) 1,142 bytes+
    +0 Dir(s) 59,430,772,736 bytes free+

    F:\oracle\product\10.2.0\db_1\database>dir spf*
    Volume in drive F is Oracle
    Volume Serial Number is 0A44-8FF6

    Directory of F:\oracle\product\10.2.0\db_1\database

    +22-02-2013 11:20 3,584 SPFILEORACLE.ORA+
    +22-02-2013 11:30 3,584 SPFILEORDB.ORA+
    +2 File(s) 7,168 bytes+
    +0 Dir(s) 59,430,772,736 bytes free+

    F:\oracle\product\10.2.0\db_1\database>





    Check here also....





    C:\Users\Administrator>sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 22 11:32:25 2013

    Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SYS : ordb> select open_mode from v$database;

    OPEN_MODE
    ----------
    READ WRITE

    SYS : ordb> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    C:\Users\Administrator>set oracle_sid=oracle

    C:\Users\Administrator>sqlplys / as sysdba
    +'sqlplys' is not recognized as an internal or external command,+
    operable program or batch file.

    C:\Users\Administrator>sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 22 11:33:08 2013

    Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SYS : oracle> select open_mode from v$database;
    select open_mode from v$database
    *+
    ERROR at line 1:
    ORA-01507: database not mounted


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





    NOw i wanna add that , if i wants to open database with "oracle" instance , i need to go to "ordb" and shutdown database .  after this i can open and "read write" database with "oracle" instance ( i hav done that)

    Edited by: newbieDBA on Feb 21, 2013 10:45 PM

    Edited by: newbieDBA on Feb 22, 2013 1:12 PM

    Edited by: newbieDBA on Feb 22, 2013 1:15 PM
  • 21. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    i changed my sqlplus's login file to give you better idea which instance and which user is signed on
  • 22. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    EdStevens wrote:
    Aman.... wrote:
    The error means that if you are running database instances without installing clusterware software and has not enabled RAC, oracle won't let a db open more than one instance. If you are going to mount one instance, the another instance won't be able to get mounted and if you want to do that, you would need RAC to be installed and the db has to be a RAC db. In the absence of the RAC, you would be able to only go ahead with different instances for different databases.

    HTH
    Aman....
    Aman,

    I really don't think RAC or lack of clusterware is his problem. It looks to me like he has/wants two distinct databases. I strongly suspect that the issue is that his two init/spfiles are identical except in name only, so they are both trying to start with the same DB_NAME value.
    see here its my <oracle_home>database directory

    Directory of F:\oracle\product\10.2.0\db_1\database

    21-02-2013 18:02 <DIR> .
    21-02-2013 18:02 <DIR> ..
    31-01-2013 12:18 <DIR> archive
    20-02-2013 17:57 114 core_oracle_pid_2392_tid_x3C0_2013_2_20_15_32_52.log
    07-02-2013 18:01 114 core_ordb_pid_2248_tid_x8E0_2013_2_7_15_8_47.log
    06-02-2013 17:59 114 core_ordb_pid_2260_tid_x8E8_2013_2_6_12_36_9.log
    19-02-2013 18:01 114 core_ordb_pid_2268_tid_x8F0_2013_2_19_10_25_45.log
    01-02-2013 17:59 114 core_ordb_pid_2272_tid_x90C_2013_2_1_10_32_8.log
    05-02-2013 17:59 114 core_ordb_pid_2364_tid_x950_2013_2_5_10_29_3.log
    08-02-2013 18:00 114 core_ordb_pid_2380_tid_x980_2013_2_8_10_30_28.log
    07-02-2013 15:07 114 core_ordb_pid_2424_tid_x9B4_2013_2_7_11_7_29.log
    12-02-2013 18:03 114 core_ordb_pid_2436_tid_x998_2013_2_12_10_29_52.log
    14-02-2013 18:02 114 core_ordb_pid_2472_tid_x9BC_2013_2_14_11_40_27.log
    13-02-2013 17:59 114 core_ordb_pid_2532_tid_x9FC_2013_2_13_10_29_8.log
    20-02-2013 17:57 114 core_ordb_pid_2540_tid_xA0C_2013_2_20_10_31_29.log
    11-02-2013 17:57 114 core_ordb_pid_2596_tid_xA58_2013_2_11_10_29_53.log
    16-02-2013 18:00 114 core_ordb_pid_2924_tid_xB80_2013_2_16_10_26_46.log
    21-02-2013 18:02 114 core_ordb_pid_2940_tid_xB94_2013_2_21_10_27_31.log
    18-02-2013 18:05 114 core_ordb_pid_3132_tid_xC24_2013_2_18_10_29_30.log
    15-02-2013 18:02 114 core_ordb_pid_3468_tid_xA88_2013_2_15_10_41_53.log
    04-02-2013 17:55 114 core_ordb_pid_3604_tid_xE58_2013_2_4_10_31_46.log
    31-01-2013 18:00 114 core_ordb_pid_3744_tid_xF28_2013_1_31_14_54_12.log
    31-01-2013 14:52 114 core_ordb_pid_4768_tid_x1254_2013_1_31_12_23_53.log
    20-02-2013 17:57 2,048 hc_oracle.dat
    31-01-2013 14:52 2,048 hc_ordb.dat
    20-02-2013 17:22 1,142 INIToracle.ORA
    08-06-2005 17:19 31,744 oradba.exe
    22-02-2013 11:16 2,969 oradim.log
    20-02-2013 17:20 2,560 PWDoracle.ORA
    16-02-2013 11:49 1,536 PWDordb.ora
    21-02-2013 17:30 7,061,504 SNCFORDB.ORA
    22-02-2013 11:20 3,584 SPFILEORACLE.ORA
    22-02-2013 11:30 3,584 SPFILEORDB.ORA
    30 File(s) 7,114,999 bytes
    3 Dir(s) 59,430,772,736 bytes free

    Edited by: newbieDBA on Feb 21, 2013 10:40 PM
  • 23. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    Aman.... wrote:
    Aman,

    I really don't think RAC or lack of clusterware is his problem. It looks to me like he has/wants two distinct databases. I strongly suspect that the issue is that his two init/spfiles are identical except in name only, so they are both trying to start with the same DB_NAME value.
    Yes Ed, I think I got too confused with what's going on. Read a little more carefully and found that there was a talk for two databases ORDB and ORACLE and I think that's what you mentioned that the OP is trying to start second db with the files of it being copied from one and still referring to first db. Wow, even this sentence is confusing :) .
    *"OP" ? wats that*
    i had database named "ordb", i created instance "oracle" using oradim ( does it create Database also? i didnt define to create database )
    Now, its confusing again  !!
    *"ORDB" and "ORACLE" both are instances and DATABASE is "ORDB" .. so "ORACLE" is not Database its just instance*



    see here when i execute this command :


    SYS : oracle> select open_mode from v$database;

    OPEN_MODE
    ----------
    READ WRITE

    SYS : oracle> select name from v$database;

    NAME
    ---------
    ORDB

    SYS : oracle>

    ##sys:oracle>## sys =user and oracle=sid (instance name) , its giving database name "ORDB"

    >
    Thanks for the correction and regards
    Aman....
    you both guys are Awesome ! sorry for my poor presentation !! m trying to get better

    Thanks

    Edited by: newbieDBA on Feb 22, 2013 1:20 PM

    Edited by: newbieDBA on Feb 22, 2013 1:27 PM

    Edited by: newbieDBA on Feb 22, 2013 1:30 PM

    Edited by: newbieDBA on Feb 22, 2013 1:31 PM

    Edited by: newbieDBA on Feb 22, 2013 1:32 PM
  • 24. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    jgarry wrote:
    I think you are both talking about the same error from different viewpoints. Oracle has the ability to do RAC - multiple instances for the same database - and there is some init.ora error that is setting that off.
    $ oerr ora 1102
    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.
    I'd guess the controlfiles ought to be different, at least. There might want to be a reference to the ORACLE_SID in the pathnames for everything, as well as in the names of the spfiles. Haven't totally thought the necessary differences through in years.

    Edit: Oh, now I see this is explained in the, excuse the term, parallel thread.
    So i put wrong title? :( i was just trying to make 2 parallel instances to share a single database
    My bad Mayb
  • 25. Re: Parallel instances?
    Aman.... Oracle ACE
    Currently Being Moderated
    newbieDBA wrote:
    *"OP" ? wats that*
    Original Poster, who started the thread and in this thread, it's you .
    *i had database named "ordb", i created instance "oracle" using oradim
    Which is what Ed said and I couldn't notice before, you were actually having one database and trying to make another one on top of it's file without really modifying them . Thanks for making it clear with this post of yours.
    ( does it create Database also? i didnt define to create database )*
    Nope, ORADIM simply creates a service for you that's needed only in the Windows . It does not create a database. FOr that tohappen, you need to fire the "create database" command either using DBCA or manually.
    Now, its confusing again  !!
    Not really! Spend more time on reading, documentation, books and you should be okay.
    *"ORDB" and "ORACLE" both are instances and DATABASE is "ORDB" .. so "ORACLE" is not Database its just instance*
    The database name is the same name that's given to the instance. So in your case, ORDB and ORACLE names stand for the databases and for their respective instances too.
    see here when i execute this command :
    SYS : oracle> select open_mode from v$database;

    OPEN_MODE
    ----------
    READ WRITE

    SYS : oracle> select name from v$database;

    NAME
    ---------
    ORDB

    SYS : oracle>
    No idea, what to see here!
    you both guys are Awesome ! sorry for my poor presentation !! m trying to get better
    Hang around in this forum for long and you are going to be better definitely as this place probably is one of those few places on the internet where you can actually intereact with real guru's like Ed, Jonathan, Hans, Joel, Hemant, Justin, Uwe , Howard, Billy (and the list goes on and on and on) and learn from them. That's what I do!

    Aman....
  • 26. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    *"ORDB" and "ORACLE" both are instances and DATABASE is "ORDB" .. so "ORACLE" is not Database its just instance*
    The database name is the same name that's given to the instance. So in your case, ORDB and ORACLE names stand for the databases and for their respective instances too.
    Look below my post of command


    see here when i execute this command :
    SYS : oracle> select open_mode from v$database;

    OPEN_MODE
    ----------
    READ WRITE

    SYS : oracle> select name from v$database;

    NAME
    ---------
    ORDB

    SYS : oracle>
    No idea, what to see here!
    I was trying to Show you that when i Change SID to "oracle" and check database name , its showing "ORDB" the old one ...( select name from v$database -this query shows ur DB name right? )
    So i guess "ordb" and "oracle" both are not databases , only "ordb" is database as well as instance also ! and "oracle" is just an instance


    you both guys are Awesome ! sorry for my poor presentation !! m trying to get better
    Hang around in this forum for long and you are going to be better definitely as this place probably is one of those few places on the internet where you can actually intereact with real guru's like Ed, Jonathan, Hans, Joel, Hemant, Justin, Uwe , Howard, Billy (and the list goes on and on and on) and learn from them. That's what I do!

    Aman....
    Edited by: newbieDBA on Feb 22, 2013 1:53 PM
  • 27. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    >
    you both guys are Awesome ! sorry for my poor presentation !! m trying to get better
    Hang around in this forum for long and you are going to be better definitely as this place probably is one of those few places on the internet where you can actually intereact with real guru's like Ed, Jonathan, Hans, Joel, Hemant, Justin, Uwe , Howard, Billy (and the list goes on and on and on) and learn from them. That's what I do!

    Aman....
    wow!! it gave me instant goosebumps when i read " where you can actually interact with real gurus like ..."

    Edited by: newbieDBA on Feb 22, 2013 1:58 PM
  • 28. Re: Parallel instances?
    Aman.... Oracle ACE
    Currently Being Moderated
    newbieDBA wrote:
    wow!! it gave me instant goosebumps when i read " where you can actually interact with real gurus like ..."
    It's the truth, trust me, you won't find many places where such elite experts come and answer questions and make us all learn from their knowledge, for free!

    Aman....
  • 29. Re: Parallel instances?
    newbieDBA Newbie
    Currently Being Moderated
    All Hail King "Gurus"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points