Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

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

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
twodollar
Asked:
twodollar
1 Solution
 
mikezhouCommented:
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
 
twodollarAuthor Commented:
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
 
riazpkCommented:
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now