Q) How you will stop a listener with name “Listener1”? Q) How you will start Listener with name “Listener1”? EG:- LSNRCTL> services ī) From GUI:- NETCA utility i will explain later. Services => To find the list of services current listener supporting. Status => To find the status of listener.
Q) What is the utility you will use for LISTENER administration?įollowing are the available in lsnrctl utility. It listenes Receives requests from the users and passes to appropriate DB. Listener is a service which is programmed to run on server where DB is hosted. Q) What is the listener and what is the use of this? To avoid this error we will increase the UNDO tablespace size” or “we will tune the undo_retention parameter in init file”. The same error can also be referred as “Snapshot too old error” When users are not able to get read-consistent image we will receive this error.
ORA 00060 DEADLOCK DETECTED WHILE WAITING FOR RESOURCE 64 BIT
What is the advantage of this 64 bit version than 32-bit. Q) What is 32-bit oracle and 64 bit oracle. Oracle: setuid setgid ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.1, dynamically linked (uses shared libs), not stripped We can say with the help of file command under UNIX Platform. Q) How you will find your DB is of 32-bit or 64 bit version. TNS for Linux: Version 9.2.0.8.0 – Production Oracle9i Enterprise Edition Release 9.2.0.8.0 – 64bit Production Q) What version of DATABASES you are supporting now? How you will find version of a DB. Daily DBA has to verify this file for any errors. Format of this file is alert_.log and this is located at background_dump_dest location. System will write information about the database activities like any structural changes, Startup and shutdown details, Checkpoint information,logswitch details etc. Q) What is alert log file and where it is located?Īlert log is log file for DATABASE. In short we can mention as ?/rdbms/admin/catalog.sqlĪbove notation is applicable only in SQLPROMPT only not at OS level. We can use $ORACLE_HOME also.Įg:- If we need to execute a file located at $ORACLE_HOME/rdbms/admin/catalog.sql While executing any scripts instead of $ORACLE_HOME value we can specify “?” so that system will take it as $ORACLE_HOME. Q) What is the meaning of “?” in path location. Q) what will be the status of the instance when you create a controlfile?
Q) what are minimum privs required for any user? and what is significance of each of those? Select sum(bytes) from dba_data_files => This gives the sum of a datafiles. Select file_name,bytes from dba_data_Files => This gives list of files and its size in bytes. Size of each datafile will be available in DBA_DATA_FILES. Size of DB is nothing but sum of size of all datafiles. I will try to put answers to them too shortly = Also Still this document is in-complete like Still i am keep on adding questions, and some questions you may find with out answers.
In the exam you may not get the same question but if you read these question by understanding its complete meaning, then automatically you can answer any question related to that question. =We should not by-hard questions we need to understand the Question and Answers.
0 kommentar(er)
