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

[vishal sood]

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

[pando]

check env variables

[vishal sood]

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.

[pando]

sigh, if your ORACLE_SID is pointing to the old one of course it says the database is already up and running

[davey23uk]

OCP???

[bmycroft]

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

[pando]

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

[davey23uk]

and you think someone who claims to be OCP knows it too

[vishal sood]

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

[hrishy]

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