How would you begin to troubleshoot an ORA-3113 error?



How would you begin to troubleshoot an ORA-3113 error?..

Answer / braj123

> Check the setup files for the Net8 driver.
> Net8 software is correctly installed on the server or not?
> Check the trace file for tracing the problem.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB Administration Interview Questions

the process of adding a cpu in sql server is called..?

2 Answers   TCS,


how can you enable flashback feature?

0 Answers   Oracle,


How do you open a cluster administrator? : sql server DBA

0 Answers  


how can you schedule a job in database?

0 Answers   Oracle,


what are the types of connection load-balancing?

0 Answers   Oracle,






How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  


From the database level, how can you tell under which time zone a database is operating?

1 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  


How many memory layers are in the shared pool?

3 Answers  


What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,


Explain materialized views and how they are used.

0 Answers  


Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  


Categories