sqlplus has stopped working

[Former Member]

Hello Experts,

please we have a problem with oracle database.

when i try to connect to database with sqlplus "/as sysdba", but its give me the error "sqlplus has stopped working".

could you please have another method to start the database without sqlplus?

server : windows 2008

database : oracle 11

thx in advance

[Former Member · Accepted solution]

Check all the environment variables, permissions and configure as recommended in standard installation guide.

Regards,

Nick Loy

[Former Member · Accepted solution]

Hi,

Please have a look on the following.

1. Open your service console services.msc and see all oracle related services are in started status.

2. Check your environmental variables are correctly pointing to your ORACLE_GOME.

3. Login at OS level with user id which has DBA privilege. E.g sidadm or orasid user.

4. Try to execute sqlplus "/as sysdba" and see whether its works out.

Best Regards,

Vasanth G

[Former Member]

hello freinds and thanks for your responses,

the problem isresolved, i rebooted the server and its worked fine.

Thanks

[former_member185031]

could you please have another method to start the database without sqlplus?

login with sidadm or orasid

than startdb

Regards,

Subhash

[Former Member]

Hi,

Check ORACLE_HOME and Once Connected sqlplus check listner configuration

[Former Member]

Verify your variable set up, like ORACLE_HOME to where it is pointing