?
Solved

cant connect to local database once pc is restart...oracle8i personal on win xp.

Posted on 2003-03-31
4
Medium Priority
?
585 Views
Last Modified: 2011-09-20
hi guys,

got a problem here, i am installing oracle 8i personal edition on my windows xp. once the installation is complete, i am able to connect to the database using SQL PLUS. but when i restart my pc, and try to connect again, i encounter this error ORA - 013034 cant connect to oracle.

i took a look at the local services and realise that my database is not starting. i try to start it manually and it failed.

then i try to delete the database and create a new one. with the new one i can connect to it. but the problem surface again when i restart my pc. apparently i my local service for that new database is not starting when i restart my pc.

anyone know of any solution or have encounter similar problem before, i would greatly appreciate your help. thanks mate!

0
Comment
Question by:twodollar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Accepted Solution

by:
mikezhou earned 80 total points
ID: 8244042
You can start your server under manual mode as follows:

Open your dos environment (Command Prompt) and type following:
set oracle_sid=your_instance (type enter)

svrmgrl (type enter)

svrmgrl>connect internal/oracle

Oracle will give a message showing database connected and then type

svrmgrl>startup pfile='[type your init file full path here, for example d:\oracle816\admin\init_your_instance.ora]'

If everything is fine, Oracle will normally give your startup message and tell your that database is opened.

Then you can exit the window and use SQL PLUS to try the connection.

Good luck,

Mike.Z
0
 

Author Comment

by:twodollar
ID: 8244649
yup. thanks. it works....can just enter

1) run : cmd
2) svrmgrl
3) connect internal
4) shutdown abort
5) startup
6) go to SQL*PLUS and enter username and password

anyway thanks alot! :)
0
 
LVL 13

Expert Comment

by:riazpk
ID: 10684868
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept mikezhou's Comment as Answer

Please leave any comments here within the next four days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Muhammad Riaz Shahid
EE Cleanup Volunteer
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question