This discussion is archived
2 Replies Latest reply: Jul 4, 2012 1:50 AM by Ahsan Shah RSS

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

946942 Newbie
Currently Being Moderated
Hi Good Evening,r when iam dispalying the results it is comming, can any body tell about this error.


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: S1000 code: 12514 message: [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. (HY000)
SQL Issued: SELECT "Sales Facts"."Amount sold" saw_0 FROM SH
  • 1. Re: Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Looks like you more than 1 oracle instances... Do these steps

    - Wait a moment and try to connect a second time.
    - Check which services are currently known by the listener by executing: lsnrctl services <listener name>
    - Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
    - If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
    - Check for an event in the listener.log file.

    Let me know updates, If helps mark it pls.
  • 2. Re: Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    Ahsan Shah Expert
    Currently Being Moderated
    From the OBIEE server, try to issue a tnsping and lsnrctl command on DOS prompt for the instance you are accessing. Confirm you are using the right Oracle home, listener is up and you can tnsping the instance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points