The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following comma

题目

The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）

A. The listener is not running on the database node.

B. The TNS_ADMIN environment variable is set to the wrong value.

C. The orcl.oracle.com database service is not registered with the listener.

D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E. The listener is running on a different port.

相似考题

1.They were married in 1978 and had a daughter the () year.A、followingB、followedC、to followD、follows

2.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.

3.Youexecutedthefollowingcommandstofindthelocationofthealertlogfile:Whereisthealertlogfilestored()A.intheBACKGROUND_DUMP_DESTlocation；intextformatB.intheBACKGROUND_DUMP_DESTlocation；inXMLformatC.intheBACKGROUND_DUMP_DESTlocation；inbothtextandXMLformatD.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；intextformatE.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；inXMLformatF.intheDIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alertdirectory；inbothtextandXMLformat

4.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

更多“The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping comm ”相关问题

  • 第1题：

    YouworkasadatabaseadministratoratCertkiller&ensp

    YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

    01578：ORACLEdatablockcorrupted（file#5，block#51）

    ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’

    Youneedtorectifythecorruptionwhileensuringthefollowing：

    Thedatafileshouldremainonline.

    Themeantimetorecover（MTTR）shouldbeminimal.

    Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.

    Whichoptionwouldyouchoose？（）


    参考答案：D

  • 第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题：

    在Oracle中,下面哪条语句当COMM字段为空时显示0,不为空时显示COMM的值()。

    A.select ename,nvl（comm.,0）from emp

    B.select ename,null（comm.,0）from emp

    C.SELECT ename,NULLIF（comm,0）FROM emp

    D.SELECT ename,DECODE（comm.,NULL,0）FROM emp


    参考答案：D

  • 第4题：

    如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )()

    A. INSTANCE_NAME

    B. DB_NAME

    C. DB_UNIQUE_NAME

    D. SERVICE_NAMES

    E. GLOBAL_NAMES


    参考答案A

  • 第5题：

    Youreceivedtheseerrormessagesbecausetheclientcannotfindthedesireddatabase：ORA-12198：TNS：couldnotpathtodestinationORA-12203：TNS：unabletoconnecttodestinationWhichactionwouldbeappropriateinhelpingtoresolvetheerrors？（）

    A.A

    B.B

    C.C


    参考答案：C

  • 第6题：

    题示代码的功能为:循环遍历输出Map当中的每一个元素。《插入代码》处应填入的代码是（）Map map=new HashMap（); map.put（“jessica”,100); map.put（“tom”,200); map.put（“den”,300); Set《插入代码1》 set =《插入代码2》; for （《插入代码3》 per : set) { System.out.println（per.getKey（) + ":" + per.getValue（)); }

    A.＜Entry＞ map.keySet() Entry#B.＜Entry＞ map.entrySet() Entry#C.＜Map.Entry＜String, Integer＞＞ map.keySet() Map.Entry＜String, Integer＞#D.＜Map.Entry＜String, Integer＞＞ map.entrySet() Map.Entry＜String, Integer＞
    Person person:list

相关内容