NLS_LANG
ORACLE_SID
ORACLE_HOME
ORACLE_BASE
LD_LIBRARY_PATH
第1题:
WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed:TZsettoAmerica/New_yorkOC4JConfigurationissue./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully?()
A.NLS_LANG
B.ORACLE_SID
C.ORACLE_HOME
D.ORACLE_BASE
E.LD_LIBRARY_PATH
第2题:
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.()
A.The PGA_AGGREGATE_TARGET parameter is set to zero.
B.The STATISTICS_LEVEL parameter is setto basic.
C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
第3题:
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
第4题:
You manually create an additional listener process,L1,for databases PROD, PAYDB and FINDB. While starting up the listener process,you get the following error message: LSNRCTL> start l1 Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899)) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use Listener failed to start. See the error message(s) above... What action would you take to overcome this error without disrupting any existing database communications?()
第5题:
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
第6题:
Youmanuallycreateanadditionallistenerprocess,L1,fordatabasesPROD,
PAYDBandFINDB.Whilestartingupthelistenerprocess,yougetthefollowingerrormessage:LSNRCTL>startl1
Starting/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr:pleasewait...
TNSLSNRforLinux:Version10.1.0.2.0-Production
Systemparameterfileis/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.oraLogmessageswrittento/u01/app/oracle/product/10.1.0/db_1/network/log/l1.logErrorlisteningon:
(ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899))
TNS-12542:TNS:addressalreadyinuseTNS-12560:
TNS:protocoladaptererrorTNS-00512:Addressalreadyinuse
LinuxError:98:Addressalreadyinuse
Listenerfailedtostart.Seetheerrormessage(s)above...
Whatactionwouldyoutaketoovercomethiserrorwithoutdisruptinganyexistingdatabasecommunications?()
第7题:
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true?()
第8题:
Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?()
A./u01/app/oracle/product/11.1.0/db_1
B./u01/app/oracle
C.$ORACLE_HOME/bdump
D.$ORACLE_HOME/log
第9题:
You executed the following command to start the database: SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205: error in identifying controlfile, check alert log for more info Which view would you query at this stage to investigate this missing control file?()
第10题:
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()