Connect oracle database error in sqlplus: ORA-12560: TNS: protocol adapter error

最新推荐文章于 2024-07-30 15:24:25 发布

转载最新推荐文章于 2024-07-30 15:24:25 发布 · 198 阅读

文章标签：

#数据库

本文提供了确保Oracle数据库正常连接的方法，包括启动TNS监听器和服务、设置环境变量及注册表编辑等步骤，适用于遇到数据库连接障碍的技术人员。

First make sure the TNS listener and other database services are started in the services control panel, then choose one of the following methods.

C:>set ORACLE_SID = S01 before connecting
Edit registration. Type regedit in command line, to HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0, change the variance ORACLE_SID to your database sid (From sap forums)

Right click ‘my computer’, propertiesà advancedà environmental variancesàsystem variancesà new name=oracle_sid, value=your database sid (From sap forums)

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8433094/viewspace-965575/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8433094/viewspace-965575/