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.
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What questions might be they ask in managerial round in capgemini.
how can you find out if a table can be redefined?
how will you see when the database was started using sql prompt?
what do you understand by flashback feature of oracle?
How can we know the exact updation date of a particular database?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
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???
How would you go about generating an EXPLAIN plan?
Explain the concept of the DUAL table.
When creating a user, what permissions must you grant to allow them to connect to the database?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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)