Skip to Content
avatar image
Former Member

unable to connect pb 12.5 to oracle 11gR2

I am trying to use powerbuilder 12.5 and oracle 11g release 2 for learning purposes but am unable to connect to oracle. Am getting the ORA-12524 error whenever I try to connect the db profile for oracle I have created on powerbuilder. Am certain the db is up and running because I am able to create the old-school odbc on win& via the control panel-administrative tools option.

my db is called orcl,my instance name/sid is still called orcl and I have a servive name called orcl which is linked to a listener which is up and running. From cmd I am able to do "sqlplus hr/hr@Joseph-HP/orcl" and successfully login. What might be causing that error? But am able to connect powerbuilder to my local mysql fine without any problem

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

13 Answers

  • Best Answer
    Feb 21, 2014 at 08:51 AM

    Forgot to mention that this thread may help:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 10:16 AM

    When I try on infomaker.

    am getting the below error

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2014 at 08:27 AM

    Hi Joseph,

    Can you please answer to the following questions:

    a) Which PB db interface is used to connect to your Oracle: ODBC, OLEDB, ORA, etc...

    Can you share your PB connection settings?

    b) Can you also share your Oracle tnsname.ora file?

    c) Can you please enable the PB trace and send us corresponding dbtrace.log?

    For your information, please read the following link to get rid of such error:

    ORA-12154 TNS Could Not Resolve Service Name

    Thanks

    Jacob

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2014 at 08:47 AM

    Can you connect using sqlplus? Or what does TNSPing say. You need to prove your TNSNames.ora is correct.

    ORA-12524:

    TNS:listener could not resolve HANDLER_NAME given in connect descriptorCause: The HANDLER_NAME in the CONNECT_DATA was not found in the listener's tables for the specified SERVICE_NAME and INSTANCE_NAME.
    Action: Check to make sure that the HANDLER_NAME specified is correct.
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 09:55 AM

    For Jacob.

    a) I am using ORA Oracle PB db interface since am using oracle 11gR2.

    b) Below is my tnsnames.ora file

    # tnsnames.ora Network Configuration File: C:\app\Joseph\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

    # Generated by Oracle configuration tools.

    ORACLR_CONNECTION_DATA =

      (DESCRIPTION =

        (ADDRESS_LIST =

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

        )

        (CONNECT_DATA =

          (SID = CLRExtProc)

          (PRESENTATION = RO)

        )

      )

    ORCL =

      (DESCRIPTION =

        (ADDRESS_LIST =

          (ADDRESS = (PROTOCOL = TCP)(HOST = joseph-hp)(PORT = 1521))

        )

        (CONNECT_DATA =

          (SERVICE_NAME = orcl)

        )

      )

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 10:00 AM

    For David.

    Yes, I am able to connect via sqlplus. EZ Connect is also working fine. I can do this "sqlplus hr/hr@Joseph-HP/orcl" from cmd screen and it connects.

    Below is my tnsping result...have run tnsping orcl

    Add comment
    10|10000 characters needed characters exceeded

    • Silly question, you do have a 32-bit oracle installed?

      PB is 32-bit and needs a 32-bit transport. Running the oracle 64-bit means sqlplus will connect but PB will not, there may also be 2 tnsnames.ora files, 1 for each version.

  • avatar image
    Former Member
    Feb 21, 2014 at 10:01 AM

    Below is my listener.ora file.

    # listener.ora Network Configuration File: C:\app\Joseph\product\11.2.0\dbhome_1\network\admin\listener.ora

    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =

      (SID_LIST =

        (SID_DESC =

          (SID_NAME = CLRExtProc)

          (ORACLE_HOME = C:\app\Joseph\product\11.2.0\dbhome_1)

          (PROGRAM = extproc)

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

        )

        (SID_DESC =

          (SID_NAME = orcl)

          (ORACLE_HOME = C:\app\Joseph\product\11.2.0\dbhome_1)

        )

      )

    LISTENER =

      (DESCRIPTION_LIST =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = Joseph-HP)(PORT = 1521))

        )

      )

    ADR_BASE_LISTENER = C:\app\Joseph

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 10:03 AM

    Below is my listener status screen shot

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 10:13 AM

    For Jacob.

    Am new to pb so am not yet familiar with enabling trace.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 11:44 AM

    For Jacob.

    Yeah, I have installed a 32bit oracle. The oci.dll picked after I set path for <oracle>/bin.

    Now how do I resolve this tns error because I can see my listner is up and its pointing to my orcl service name which points to my instance which is named orcl

    Add comment
    10|10000 characters needed characters exceeded