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.