Home » Infrastructure » Windows » "Oracle not available" after reboot
"Oracle not available" after reboot [message #479378] Sat, 16 October 2010 09:01 Go to next message
Messages: 1
Registered: October 2010
Location: IN
Junior Member

my problem is not this one...

my problem is

Sir, i have installed oracle8i successfully on my computer but when i reboot my computer & try to run SQL
by using username:- system & password:- manager or scott/tiger i get message "Oracle not available".
sir please mail me the solution to this problem.

im insert the after its working connection of data base
SQL> conn /as sysdba
Connected to an idle instance. (after)
SQL> startup mount
ORACLE instance started.

Total System Global Area 569496844 bytes
Fixed Size 70924 bytes
Variable Size 165638144 bytes
Database Buffers 403709952 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL> alter user system identified by manager ;

User altered.

SQL> conn system/manager
so this is process follwing is working but system is restart its not working...
this is process so please help me....

[LF: Topic split from an unrelated one from the Forms forum]

[Updated on: Sat, 16 October 2010 13:22] by Moderator

Report message to a moderator

Re: problem of query in a procedure [message #479395 is a reply to message #479378] Sat, 16 October 2010 11:35 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: oracle 9i not install
Next Topic: Detecting full DOMAINNAME\USERNAME for connected user
Goto Forum:

Current Time: Fri May 24 15:04:35 CDT 2024