◎筱米加步枪◎.Blog

Happy coding

Oracle出现ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务解决方法

筱米加步枪 posted @ 2010年12月13日 11:49 in [ 数据库 ] with tags oracle TNS , 3698 阅读

遇到此问题多次了,于是决定记一下.

找到listener.ora文件打开,

# listener.ora Network Configuration File: f:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
      (SID_DESC =
        (GLOBAL_DBNAME = ORCL)
        (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)  
        (SID_NAME = ORCL)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

上面红色标记部分为增加的部分,根据具体数据库安装的不同,分别更改GLOBAL_DBNAME、ORACLE_HOME、SID_NAME三个值,然后重新启动Oracle服务即可

deep cleaning dubai 说:
2020年2月21日 22:59

Given that the name means, deep maintaining represents another a better standard of cleaning together your office or house. Basic maintaining includes general clean like wiping and even vacuuming your kitchen, bathroom, bedroom and great room floors, plus cleaning that cupboard exterior doors, tables, patio chairs, and such like, using liquid or all other basic maintaining products; then again, deep cleaning talks about watching the aspects and elliminating hidden mud, dirt, and even small intrinsic and extrinsic stains. It is known as a top to help you bottom scrubbing of your residence, from ceilings to help you floors, And also the deep maintaining include maintaining what’s concerning the tiles, behind the washing machine, under that sink, while in the oven, cleaning the family room corners…etc.

cleaning company dub 说:
2020年2月22日 18:13

The final thing you need to check upon before employing a rug cleaning company is actually they kind of carpet cleansing equipment as well as methods they use and when they focus on any a particular type associated with service. You should also ask when they understand your specific kind of rugs as well as carpets and when they uses the right approach to cleaning for that which you have. The final thing you would like is for the Oriental carpets and rugs or Local carpets to become ruined just because a company used the incorrect carpet cleansing process or even chemicals.

civaget 说:
2023年12月11日 06:38

Header tags, the signposts of your content's structure, are a crucial element in the labyrinth of 구글 seo, ensuring your message is heard loud and clear.

civaget 说:
2023年12月17日 03:08

인천출장마사지: Your path to relaxation. Experience on-site massages that cater to your needs and schedule. Stress relief has never been easier.

civaget 说:
2023年12月19日 03:02

오피's charm lies in its discretion and premium atmosphere. A sought-after choice for adults seeking exclusivity.

civaget 说:
2023年12月23日 07:59

Don't miss out on the 부산휴게텔 experience when in Busan. You won't regret it.

civaget 说:
2023年12月25日 03:20

The world of soccer bows to 해외축구중계 for its incredible service.


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter