Ora-12514 And Ora-12560 .. How To Fix This

بتاريخ: 13 يونيو 201411 سنة

السلام عليكم ورحمه الله

ارجو المساعده لديى قاعده بيانات SMARTHR والسيرفس شغال بدون مشاكل ولا كن Listener/instance لم يتعرف عليها عموما حاولت وفشلت فى تصحيح الخطأ , فقمت بإنشاء قاعده بيانات اخرى وسميتها SMARTRH و عموما توجد سيرفس اخرى تشتغل بصوره طبيعيه وهيا SMARTBK, التفاصيل بالاسفل

##########################################################################################

## Listener.ora

##########################################################################################

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = E:\app\administrateur\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\administrateur\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = AGADEZ.bsicne.lan)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

 

ADR_BASE_LISTENER = E:\app\administrateur

 

##########################################################################################

## tnsnames.ora

##########################################################################################

SMARTHR =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.100.15)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = SMARTHR)

    )

  )

 

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

 

SMARTBK =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.100.15)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = SMARTBK)

    )

  )

 

ORACLNT =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.100.15)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = SMARTBK)

    )

  )

 

SMARTRH =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.100.15)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = smartrh)

    )

  )

 

##########################################################################################

## lsnrctl status

##########################################################################################

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl status

 

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 12-JUN-2014 19:32:07

 

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                12-JUN-2014 19:15:37

Uptime                    0 days 0 hr. 16 min. 33 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Log File         e:\app\administrateur\diag\tnslsnr\AGADEZ\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

Services Summary...

Service "SMARTBKXDB" has 1 instance(s).

  Instance "smartbk", status READY, has 1 handler(s) for this service...

Service "smartbk" has 1 instance(s).

  Instance "smartbk", status READY, has 1 handler(s) for this service...

Service "smartrh" has 1 instance(s).

  Instance "smartrh", status READY, has 1 handler(s) for this service...

Service "smartrhXDB" has 1 instance(s).

  Instance "smartrh", status READY, has 1 handler(s) for this service...

The command completed successfully

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>

 

##########################################################################################

## lsnrctl stop & Start

##########################################################################################

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl stop

 

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 12-JUN-2014 19:33:03

 

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

The command completed successfully

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl start

 

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 12-JUN-2014 19:33:10

 

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 

Starting tnslsnr: please wait...

 

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

System parameter file is E:\app\administrateur\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to e:\app\administrateur\diag\tnslsnr\AGADEZ\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                12-JUN-2014 19:33:15

Uptime                    0 days 0 hr. 0 min. 7 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   E:\app\administrateur\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File         e:\app\administrateur\diag\tnslsnr\AGADEZ\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

##########################################################################################

## lsnrctl service

##########################################################################################

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl service

 

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 12-JUN-2014 19:34:27

 

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AGADEZ.bsicne.lan)(PORT=1521)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0

         LOCAL SERVER

Service "SMARTBKXDB" has 1 instance(s).

  Instance "smartbk", status READY, has 1 handler(s) for this service...

    Handler(s):

      "D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER <machine: AGADEZ, pid: 6504>

         (ADDRESS=(PROTOCOL=tcp)(HOST=AGADEZ.bsicne.lan)(PORT=53058))

Service "smartbk" has 1 instance(s).

  Instance "smartbk", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0 state:ready

         LOCAL SERVER

Service "smartrh" has 1 instance(s).

  Instance "smartrh", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0 state:ready

         LOCAL SERVER

Service "smartrhXDB" has 1 instance(s).

  Instance "smartrh", status READY, has 1 handler(s) for this service...

    Handler(s):

      "D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER <machine: AGADEZ, pid: 4628>

         (ADDRESS=(PROTOCOL=tcp)(HOST=AGADEZ.bsicne.lan)(PORT=52716))

The command completed successfully

 

##########################################################################################

## sqlplus /nolog

## conn / as sysdba

##########################################################################################

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>set ORACLE_SID=smarthr

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 12 19:36:01 2014

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

SQL> conn sys / as sysdba

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

SQL>

 

 

 

E:\app\administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN>exp xxxxx/0000@smarthr

 

Export: Release 10.2.0.1.0 - Production on Thu Jun 12 19:37:53 2014

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

EXP-00056: ORACLE error 12514 encountered

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

وشكرا لكم , ارجو منكم الرد فى اسرع وقت ممكن ؟؟

ملاحظه : فى حاله اردت انشاء نفس قاعده البيانات باسم اخر فى نفس السيرفر او بنفس الاسم فى سيرفر اخر ماهيا الخطوات لنقل البيانات datafiles و controlfile و logs هل توجد امكانيه لاعاده تشغيل نفس قاعده البيانات فى سيرفر جديد.

ولكم خالص الشكر

اقتباس

تقديم بلاغ

بتاريخ: 14 يونيو 201411 سنة

كاتب الموضوع

وين الخبراء الروس ؟؟

اقتباس

تقديم بلاغ

بتاريخ: 16 يونيو 201411 سنة

السلام عليكم اخي

الداتا بيس الي عندك غير مسجله في اليسينر ..... not registered in listener

لحل المشكله حاول شغل ال net manager و حاول اكتب اسم الداتا بيس هناك

هذه المقاله يمكن ان تساعدك

http://neeraj-dba.blogspot.ae/2011/10/how-to-register-listener-in-database.html

و هناك طريقه اسهل لنقل اداتا بيس و ذلك من خلال cold cloning

اتمنى اني ساهمة في مساعدتك بالموضوع

اقتباس

تقديم بلاغ

تسجيل دخول

Ora-12514 And Ora-12560 .. How To Fix This

Featured Replies

انضم إلى المناقشة

برجاء الإنتباه

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)