oracle 11g登陸報錯'ORA-12162: TNS:net service name is incorrectly specified'
oracle 11g透過sqlplus登陸資料庫報錯
sqlplus / as sysdba
'ORA-12162: TNS:net service name is incorrectly specified'
在網上搜尋解決方法,建議是設定ORACLES_ID,但設定以後依然報錯
解決方法:
更改環境變數
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_HOME
ORACLE_SID=OTA4G
export ORACLE_SID
ORACLE_UNQNAME=OTA4G
export ORACLE_UNQNAME
PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$CLASSPATH
export CLASSPATH
sqlplus / as sysdba
'ORA-12162: TNS:net service name is incorrectly specified'
在網上搜尋解決方法,建議是設定ORACLES_ID,但設定以後依然報錯
解決方法:
更改環境變數
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_HOME
ORACLE_SID=OTA4G
export ORACLE_SID
ORACLE_UNQNAME=OTA4G
export ORACLE_UNQNAME
PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$CLASSPATH
export CLASSPATH
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2134861/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle案例05——ORA-12162: TNS:net service name is incorrectly specifiedOracle
- 【故障處理】ORA-12162: TNS:net service name is incorrectly specified
- hpux上的定時任務報:ORA-12162: TNS:net service name is incorrectly specifiedUX
- Oracle TNS報錯大全Oracle
- ora-12169 tns net service name given as connect identifier is too longIDE
- ORA-12154: TNS:could not resolve service name / TNS-03505: Failed to resolve nameAI
- windows 下用 as sysdba登陸報錯Windows
- [BUG反饋]onethink 登陸時呼叫$User = new UserApi; 報錯。API
- Tomcat執行報錯,Annotation-specified bean name 'KY_QT_TTomcatBeanQT
- 利用jnbSA啟動netbackup圖形介面報錯無法登陸
- Oracle RAC啟動CRS報錯:登陸許可權問題Oracle
- Oracle SID VS Service NameOracle
- Oracle SID & SERVICE_NAMEOracle
- oracle 登陸Oracle
- Oracle 11g使用MERGE報錯'ORA-02287..The specified sequence number (CURRVAL'Oracle
- mysql登陸報錯mysql: unknown variable 'basedir=MySql
- Oracle 11g下TNS連線報錯ora-12532故障解決Oracle
- DB_NAME&TANCE_NAME&DB_UNIQUE_NAME&ORACLE_SID&GLOBAL_NAME&DB_DOMAIN&SERVICE_NAMEOracleAI
- sqlnet.ora 驗證oracle 登陸方式SQLOracle
- 【Oracle】service_name和service_names的關係Oracle
- Kill all sessions of a specified user nameSession
- 頁面報錯 No input file specified
- mongodb報錯:the limit must be specified as a number。MongoDBMIT
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- oracle 啟動監聽報錯TNS-12547: TNS:lost contactOracle
- 登陸peoplesoft報:Site name is not valid. Check your url syntax and try again.AI
- mysql密碼遺忘和登陸報錯問題MySql密碼
- Oracle修改instance_name、db_name、db_unique_name、service_namesOracle
- oracle 11g安裝報錯Oracle
- oracle 登陸限制ipOracle
- ORACLE登陸包描述Oracle
- 徹底理解初始化引數SERVICE_NAMES和客戶端TNS中SERVICE_NAME(2)客戶端
- 徹底理解初始化引數SERVICE_NAMES和客戶端TNS中SERVICE_NAME(1)客戶端
- oracle中service_name區別總結Oracle
- 新搭建的mysql登陸報錯mysql Segmentation fault (core dumped)MySqlSegmentation
- CUUG 筆記ORACLE db_name instance_name gobal_name service_name db_unique_name分析筆記OracleGo
- ORACLE 11g RAC TNS無法正常登陸之ORA-12537&ORA-01017&SP2-0157Oracle
- [轉]ORACLE中的DB_NAME,SERVICE_NAME,INSTANCE_NAME,ORACLE_SID,GLOBAL_DBNAMEOracle