Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

error ora-12154 when try to access oracle http server

claudioaragaoSep 3 2014 — edited Nov 13 2014

Hi.

I hava OHS 12C in my machine and I´m trying to call a procedure from a database( Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 ) installed on my net , but i receive this error 503.

If I access localhost:7777,   it  works fine.

If I access by sqlplus, or pl/sql developer works too.

I try to use DEV10205 and DEV10205.DEVINT  on PlsqlDatabaseConnectString but doesn´t works.

this is my dad

<Location /pls/plsqlapp>

  #SetHandler pls_handler

  Order deny,allow

  AllowOverride None

  PlsqlDatabaseUsername         wfiti

  PlsqlDatabasePassword         wfiti

  PlsqlDatabaseConnectString    10.13.238.23:1521:DEV10205.DEVINT

  PlsqlDefaultPage              teste_web

  PlsqlDocumentTablename        scott.wwdoc_document

  PlsqlDocumentPath             docs

  PlsqlDocumentProcedure        scott.wwdoc_process.process_download

  PlsqlAuthenticationMode       Basic

</Location>

and this is my tnsnames

DEV10205 =

    ( DESCRIPTION =

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

        ( CONNECT_DATA = ( SERVER = DEDICATED ) ( SERVICE_NAME = DEV10205.DEVINT ) )

    )

the error log

[2014-09-02T15:49:11.6161-03:00] [OHS] [ERROR:32] [OHS-9999] [mod_plsql.c] [client_id: 10.167.68.247] [host_id: BRSPO01] [host_addr: 10.167.71.203] [tid: 2032] [user:

[ecid: 00iOAzQcJHJFw0zlfH02Rz3^b8y3zwYw000018k00005R] [rid: 0] [VirtualHost: main]  MODPLSQL-00054: mod_plsql: HTTP-503 ORA-12154 ORA-12154: TNS:could not resolve the connect identifier specified\n

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2014
Added on Sep 3 2014
2 comments
1,465 views