How would you begin to troubleshoot an ORA-3113 error?
- 1 Answers
- 4137 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What is the difference between clustered and non-clustered index? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you find out if a table can be redefined?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Query processing is slow(eg select query)how will u solve that
What are the commands used in dcl? : sql server DBA
how does an oracle clusterware manage crs resources?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you connect from 10g user to 11g user??
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the commands you'd issue to show the explain plan for "select * from dual"?
