Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL：ORCL=（DESCRIPTION=（ADDRESS=（PROTOCOL=TCP）（HOST=10.156.24.216）（PORT=1521））（CONNECT_DATA=（SERVER=DEDICATED）（SERVICE_NAME=orcl.oracle.com）））TheTNSPINGcommandexecutessuccessfullywhentestedwithORCL

题目

Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL：ORCL=（DESCRIPTION=（ADDRESS=（PROTOCOL=TCP）（HOST=10.156.24.216）（PORT=1521））（CONNECT_DATA=（SERVER=DEDICATED）（SERVICE_NAME=orcl.oracle.com）））TheTNSPINGcommandexecutessuccessfullywhentestedwithORCLbutyouarenotabletoconnecttothedatabaseinstancewiththefollowingcommand：SQL>CONNECTscott/tiger@orclWhatcouldbethereasonforthis？（）

A.Thelistenerisnotrunningattheserver.

B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.

C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.

D.TheDEFAULT_DOMAINparameterissettoawrongvalueintheSQLNET.ORAfile.

相似考题

1.You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

2.Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

3.Yourdatabaseisnotconfiguredforsessionfailover.Yourtnsnames.orafilecontainsthefollowingdetails：test.us.oracle.com=（DESCRIPTION=（ADDRESS_LIST=（LOAD_BALANCE=off）（FAILOVER=ON）（ADDRESS=（PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））（ADDRESS=（PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））（CONNECT_DATA=（SERVICE_NAME=test.us.oracle.com）））Whichfeatureisenabledinthiscase？（）A.LoadbalancingB.InstancefailoverC.DatabasefailoverD.Connect-timefailoverE.TransparentApplicationFailover（TAF）

4.ExaminetheCREATEDISKGROUPcommandusedtocreateadiskgroup：SQL>CREATEDISKGROUPmiscEXTERNALREDUNDANCYDISK’ORCL：FRA3’NAMEmisc1，’ORCL：FRA4’NAMEmisc2；Inwhichsituationwouldyouusethismethodofdiskgroupcreation？（）A.Whentwo-waydiskmirroringisrequiredfortheallocationunitsB.Whenthree-waydiskmirroringisrequiredfortheallocationunitsC.WhenusinghardwaremirroringorRAIDD.WhendiskmirroringisrequiredfortheAutomaticStorageManagement（ASM）disks

参考答案和解析
参考答案：C
更多“Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL:ORCL=(DESCRIPTION=(ADDRESS= ”相关问题

  • 第1题：

    Youexecutedthefollowingcommandstofindthelocationofthealertlogfile:Whereisthealertlogfilestored()

    A.intheBACKGROUND_DUMP_DESTlocation；intextformat

    B.intheBACKGROUND_DUMP_DESTlocation；inXMLformat

    C.intheBACKGROUND_DUMP_DESTlocation；inbothtextandXMLformat

    D.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；intextformat

    E.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；inXMLformat

    F.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；inbothtextandXMLformat


    参考答案：A, E

  • 第2题：

    如下是某个tnsnames.ora里面的配置, 其中service_name的值与 listener.ora文件中哪个参数的值相对应? db.example.com= (description= (load_balance=on) (address=(protocol=tcp)(host=node1-vip)(port=1521) (address=(protocol=tcp)(host=node2-vip)(port=1521) (connect_data= (service_name=db.example.com)))()

    A. SID_NAME

    B. INSTANCE_NAME

    C. GLOBAL_NAMES

    D. GLOBAL_DBNAME


    参考答案D

  • 第3题：

    YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility：LSNRCTL>STARTStarting/mstgelai/oracle/bin/tnslsnr：pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon：（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521）））Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted？（）

    A.TNSLSNR

    B.LISTENER

    C.LOCAL_LISTENER

    D.DEFAULT_LSRN


    参考答案：C

  • 第4题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()

    A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.

    B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.

    C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.

    D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.


    参考答案：C

  • 第5题：

    YouneedtodesignthestorageoftheapplicationtextsforUIelementstofulfilltherequirements.Whichtableandcolumndesignshouldyouuse?()

    A.Languages(LanguageID,Name)Elements(ElementID,Description)ElementLanguages(ElementID,LanguageID,Text)

    B.Languages(LanguageID,Name)Elements(ElementID,LanguageID,Description,Text)

    C.Languages(LanguageID,Name)ElementTexts(LanguageID,Text)ElementDescriptions(ElementID,Description)

    D.Languages(LanguageID,Name)Elements(ElementID,Description,Text)


    参考答案：A

相关内容