هل تريد التفاعل مع هذه المساهمة؟ كل ما عليك هو إنشاء حساب جديد ببضع خطوات أو تسجيل الدخول للمتابعة.

    ORA-12514 and ORA-12560 .. how to fix this

    redasaleh
    avatar
    redasaleh


    عدد المساهمات : 2
    نقاط : 4
    تاريخ التسجيل : 13/06/2014
    العمر : 50
    • مساهمة رقم 1

    ORA-12514 and ORA-12560 .. how to fix this Empty ORA-12514 and ORA-12560 .. how to fix this

    مُساهمة من طرف redasaleh الجمعة يونيو 13, 2014 5:52 pm

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

    ارجو المساعده لديى قاعده بيانات 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 هل توجد امكانيه لاعاده تشغيل نفس قاعده البيانات فى سيرفر جديد.

    ولكم خالص الشكر
    • الرجوع الى أعلى الصفحة
    redasaleh
    avatar
    redasaleh


    عدد المساهمات : 2
    نقاط : 4
    تاريخ التسجيل : 13/06/2014
    العمر : 50
    • مساهمة رقم 2

    ORA-12514 and ORA-12560 .. how to fix this Empty رد: ORA-12514 and ORA-12560 .. how to fix this

    مُساهمة من طرف redasaleh السبت يونيو 14, 2014 12:24 am

    وين الخبراء !!!!!!!!!!!!!
    • الرجوع الى أعلى الصفحة

      الوقت/التاريخ الآن هو الخميس مايو 02, 2024 7:27 am