plsql ora-12154 TNS service name can not be processed

Just install a version of the client
1, open. Start - Program - Oracle - OraHome92 - Configuration and Migration Tools - Net Configuration Assistant
2, select the "naming configuration" - the next step - check the "local", "host name", "Oracle Names" - Next
3, confirmed OK.

Installed two versions of the client to open PLSQL, prompted to enter user name password is canceled, so the main interface into the PLSQL Developer,
Menu Tools-Preferences, the settings window, select the Oracle-Connection, the corresponding settings window, locate the Oracle Home, select OraHome92, save the settings,
And then restart the PLSQL Developer, then you can normally logged.

分类:Database 时间:2010-02-09 人气:236
分享到:
blog comments powered by Disqus

相关文章

  • Oracle Connection Exception ERROR: ORA-01033: ORACLE initialization or shutdown in progress 2011-04-03

    Exception: ERROR: ORA-01033: ORACLE initialization or shutdown in progress There reasons: the general is the physical address corresponding table space files to delete, so when the database appear in the loader can not find signs of the corresponding

  • PLSQL Developer 8 to connect Oracle 11g X64 Edition 2010-07-04

    PLSQL Developer 8 to connect Oracle 11g X64 Edition Before I do Flex, Oracle is no longer just science ... ... ... ... ... ..., but after I test the following are Because the PLSQL Developer not support 64-bit Oracle So the Internet to find a lot of infor

  • PLSQL Developer + Oracle client Easy Installation 2010-08-22

    Eclipse until all that comes with the Data Source Explorer to access the Oracle database, but only a simple view, and many fields are not compatible. Today started using PLSQL Developer connect to a remote Oracle database, when, suggesting that I did not

  • PLSQL Developer to connect remote oracle database shows 2011-09-28

    Preliminary work: Check oracle server-side monitor is working properly and understand the monitoring information. 1 First check whether the listener can start, start, run cmd ---> lsnrctl start, check whether the monitor is in normal operation, if

  • plsql连接oracle数据库报ora 12154错误解决方法 2015-04-20

    今天遇到一个问题,plsql连接oracle数据库报ora 12154错误,本文将为您详细介绍此等问题的解决方法 plsql连接oracle数据库报ora 12154错误 今天遇到一个问题,使用sqlplus能够连接到远程的数据库,但是使用plsql却连接不上,报错"ORA-12154: TNS: 无法解析指定的连接标识符" 解决方法如下: 1.先检查服务器端的监听服务是否打开,如果没有打开请启动其监听 客户端:tnsping <tns_name> 服务器Linux下: #>l

  • PLSQL Developer to use. Settings and shortcut keys 2010-09-04

    PLSQL Developer to use, setup and shortcut keys 1, login by default automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand tables directory, normally have to Wait a

  • An example of incorrect address to connect ORACLE: ORA-01033: ORACLE initialization or shut down is 2010-07-13

    Customers found to have problems connecting to the database, errors are: ORA-01033: ORACLE initialization or shut down is ORA-00600: internal error code chart as follows: First, modify environment variables, to ensure access to the right under cmd oracle

  • ORA-01033: ORACLE initialization or shutdown in progress 2010-07-20

    错误现象: 因误操作,数据库中某一数据文件被误删,控制面板的Oracle相关服务显示已启动,但用SQL*Plus无法连接,显示以下错误: ORA-01033: ORACLE initialization or shutdown in progress 解决: C:\Documents and Settings\Administrator>sqlplus/nolog SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 7月 20 22:28:27

  • oracle tnsping & ora-12154 2011-01-05

    Use the command sqlplus user / pwd @ tnsname time, reported the error ora-12154: tns: could not resolve connection identifier specified using the command tnsping tnsname found oracle sqlplus connection using client directory wrong. The machine instal

  • [Exception handling] ORA-01033: ORACLE initialization or shut down is 2010-11-30

    ORACLE database error message: ORA-01033: ORACLE initialization or shut down is ORA-00600: internal error code Successful approach: and Settings \ Administrator> sqlplus / nolog SQL * Plus: Release 10.2.0.1.0 - Production on Monday, July 5 09:50:3

iOS 开发

Android 开发

Python 开发

JAVA 开发

开发语言

PHP 开发

Ruby 开发

搜索

前端开发

数据库

开发工具

开放平台

Javascript 开发

.NET 开发

云计算

服务器

Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 黔ICP备15002463号-1

processed in 0.198 (s). 12 q(s)