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 |
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???
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the use of home directory???
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How do you add a data file to a tablespace?
How would you determine the time zone under which a database was operating?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the recovery models for a database? : sql server DBA
what is the difference between hot backup n rman backup?
What are the commands used in dcl? : sql server DBA
Give two examples of referential integrity constraints.
when does an alert gets signaled?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)