oracle installation help

[raja_puligadda]

First of all hello to everybody.
i had installed oracle 9i in my computer.the sql plus is running correctly.
but when i restarted the computer it is not running .
actually when i opened the sql plus it has asked for the password.
but when i enterd the user name and password it is telling that 'initialisation is in progress',and asking for password again.what should i do.
please can anyone tell me what to do.
it is very urgent.
i had downloaded the software from the oracle website.
please please please

[Guptha_S]

1. First take a backup of your database

2. Check the alert log.
You can find alert log at C:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG
if you dont find it use this command

SQL> SHOW PARAMETERS background_dump_dest

That will give you exact location of alert log.

3. Try to analyse alert log and find the possible cause of your error, If you cant makeout anything from alert log Try this
Start SQLPlus and logon as SYSDBA

SQL> SHUTDOWN ABORT

SQL> STARTUP NOMOUNT

SQL> ALTER DATABASE MOUNT

SQL> ALTER DATABASE OPEN

[coolomkar]

i think any server is install in your pc like IIS. if not then after restart machine start your apache server and then try again for isqlplus. i think it will work.