ORA-12514: TNS:listener does not currently know of service requested in connect descriptor--这个很明显是监听文件配置的问题，首先查看口令文件，如果没有先建立orapwd file='$ORACLE_HOME/dbs/orapw$ORACLE_SID' password=oracle entries=10 force=y再查看SQL> show parameter passNAME TYPE VALUE--------------------- ----------- ------------------------------remote_login_passwordfile string NONE --如果不是EXCLUSIVE需要修改spfileSQL> alter system set remote_login_passwordfile=exclusive scope=spfile;如果还是不行那就应该是listener.ora的格式问题，以防万一还是先查看下tnsnames.ora格式tnsnames.oraORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GOLBAL_DBNAME = ETMCDB) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (SID_NAME = ETMCDB) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.localdomain)(PORT = 1521)) ) )修改好后问题解决,随后遇到 ORA-01031: insufficient privileges出现这种问题可能性我遇到两个①有人说需要配置这个sqlnet.oraSQLNET.AUTHENTICATION_SERVICES= (NTS)--但是这个带来影响就是,它表示采用os认证sqlplus / as sysdba在unix下会有问题②我最后的解决是正确赋予用户权限重点就是rman需要sysdba
转载于:https://www.cnblogs.com/buro79xxd/archive/2010/02/05/1682592.html
