-
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
-
-
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
-
sigh, if your ORACLE_SID is pointing to the old one of course it says the database is already up and running
-
Last edited by hrishy; 02-06-2004 at 07:35 AM.
-
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
-
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
-
and you think someone who claims to be OCP knows it too
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|