Oracle SQL Prompt commands

[Former Member]

1) How to identify the problem of Oracle database from SQL command prompt

By executing a set of SQL commands one by one after connecting /as sysdba

2)what could be possible errors and how to resolve from SQL prompt

e.x db corrupt

not mounted

recovery

.....etc

Please give more example

Thanks in ton

[markus_doehr2 · Accepted solution]

I suggest you taken an Oracle class on this topic. It's out of the scope of this forum to tell you what kind of problems may occur on an Oracle database and how to fix them.

Markus

[Former Member · Accepted solution]

Any quick SQL commands to check the status of Oracle to act accordingly

[valeriocicchiel · Accepted solution]

Hello flemingnett,

you can enter this sqlplus query:

SQL> select * from dual;

this should return:

D
-
X

If sqlplus returns an error code, read the error code and act accordingly

Best Regards,

Valerio

[former_member204746 · Accepted solution]

Ok,

I am locking this topic.

SDN is not a substitute for training.

go get your self trained with SAP course ADM505

more about this at http://www12.sap.com/services/education/catalog/netweaver/globaltabbedcourse.epx?context=%5b%5bADM_D...

[Former Member]

Do not use shutdown abort without knowledge...

Suggest you to close this thread and do the same as mentioned by Markus...

Regards,

Nick Loy