ORA-01081 cannot start already-running ORACLE - shut it down first.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ORA-01081 cannot start already-running ORACLE - shut it down first.

  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    118

    ORA-01081 cannot start already-running ORACLE - shut it down first.

    Hi

    on linux 8, with oracle 8i one database created and running successfully. I wanted to create another database on same server. For this I created

    1. a service as export ORACLE_SID ser.name.
    2. Wrote a script to create database.
    3. started Svrmgrl
    4. Connect internal/oracle as sysdba.
    5. issued command startup nomount pfile=name
    6. receive an error message i.e.
    ORA-01081 cannot start already-running ORACLE - shut it down first.

    why ?

    kindly note when I am doing above mentioned the first database is up and running fine.

    Is it like, I have to shutdown first database and only then I can create 2nd database. ?

    Kindly share ur knowledge.

    Thanks
    vishal sood
    OCP 8

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    check env variables

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    Checked the env valiable it is showing ORACLE_SID = SCHB. For 2nd database i have created ORACLE_SID = TESTSCHB. When I creted this no error received.

    another question from where I can see how many ORACLE SIDs are created.
    vishal sood
    OCP 8

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    sigh, if your ORACLE_SID is pointing to the old one of course it says the database is already up and running

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    OCP???
    Last edited by hrishy; 02-06-2004 at 06:35 AM.

  6. #6
    Hey come on guys! I mean we all had to learn at some point! We *all* made mistakes like that at the beginning (and then learned not to do THAT again).

    -B

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I learnt how to use/check/point to a proper ORACLE_SID in my first week working with Oracle, in fact the first thing in my first day I was taught this to not shut down other databases than test ones

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    and you think someone who claims to be OCP knows it too

  9. #9
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    thanks for ur comments.

    Yes I claim that I am an OCP(but also a human being). I asked question because I don't have EGO in asking questions.

    kindly go thru my question, in that I am also surprised why when I am exporting New oracle sid then why it is showing old one. Because it is showing old sid that is why it is giving error 'oracle already started'.

    I just wanted to clear the concept because I am new to Linux and but I have learnt that how to install Oracle and Oracle database in Linux.I know this is small thing for u all but for me i learnt new thing.

    Once again I am thankful for ur comments because after reading those, I realized that Yes I can do it my self. But this heppens only because of u all.

    and please don't mind in future if ask what is init.ora file(justkiding)

    thanks
    vishal sood
    OCP 8

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Vishal

    I think the SID is not being exported properly..Pando is 100% right (as usual :-))

    what shell are you using..after exporting the SID try testing it

    env |grep ORACL_SID and see what is being shown on your terminal

    in BASH and korn you export env variables something like this

    export ORACLE_SID=newsid

    in bourne shell u do soemthing like this
    ORACLE_SID=newsid
    export ORACLE_SID

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width