Problem with Oracleservice

Hi

my OracleServiceVis is not staritng automtically
In services it show automatic but i am doing manual startup and after that  it shows OracleServiceVIS - Started

but in SQL promot when in give Userid & password it shows some errors

ORA-01034: ORACLE NOT AVAILABLE
ORA-27101: SHARED MEMORY REALM DOES NOT EXIST

could u give a solution how to start the my OracleServiceVIS

skdasari
skdasariAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

seazodiacCommented:
Ok, skdasari:
I think this will work for you:

in the Dos command line (follow step by step strictly)

C:\>ORADIM -DELETE -SID VIS

then go back to the windows Services applet , make sure the OracleServiceVIS is gone.

then go back to the DOS window:

C:>ORADIM -NEW -SID VIS -INTPWD oracle -STARTMODE a -PFILE=d:\oracle\visdb\8.1.7\dbs\InitVIS.ORA

then your service will automatically start.

Hope this helps
0
skdasariAuthor Commented:
hI

this
C:>ORADIM -NEW -SID VIS -INTPWD oracle -STARTMODE a -PFILE=d:\oracle\visdb\8.1.7\dbs\InitVIS.ORA

is not working it shows
DIM-00003 a argument is missing for parameter
could u tell me what is that

skdasari
0
seazodiacCommented:
sorry, use this:

C:>ORADIM -NEW -SID VIS -INTPWD oracle -STARTMODE a -PFILE d:\oracle\visdb\8.1.7\dbs\InitVIS.ORA
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

boriskalavskyCommented:
Did you try opening command prompt and typing following:

set ORACLE_SID=VIS
sqlplus user/password
0
skdasariAuthor Commented:

Seazodiac

i have done the above one

in services applet it shows STARTING

what is the next step to do
do i need to reboot the system or any futher steps

skdasari
0
seazodiacCommented:
that's good.
Wait until it fully started.

Just wait. In Windows, it usully is slow to start.

Now you are back on track. Congratulation!!!

remember to assign the points though...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skdasariAuthor Commented:
Hi

Seazodiac

OracleServiceVIS  -  STARTED

So could u tell me what is the next step
0
seazodiacCommented:
Thanks.

Please Close this thread too since I also gave you a solution there...

http://oldlook.experts-exchange.com/Databases/Oracle/Q_20739476.html
0
skdasariAuthor Commented:
Hi
seazodiac
this is last question help me out

shall i follow these steps or any changes because do i need to implement the 3rd step
alter database mount or not

1.svrmgrl:\>connect sys/oracle@VIS as sysdba
2.svrmgrl:\>startup nomount pfile= d:\oracle\visdb\8.1.7\dbs\InitVIS.ORA
3.svrmgrl:\>alter database mount;
4.svrmgrl:\>alter database open

after 4 step do i need to restart my computer
0
seazodiacCommented:
No, you don't need to follow these steps any more since your oracle database will automatically start when the computer restarts.
you don't need to configure anything further, you now are open to the database for query or any other activity. the bottom line, your database is fully ready now.

please follow this link to close this thread though, we need to keep this forum clean.

http://oldlook.experts-exchange.com/Databases/Oracle/Q_20739476.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.