Error ORA-12154 When you try to access HTTP Oracle server

[aramatos]

Hey Good afternoon.


I have ohs 12c on my machine and I am trying to call a procedure from a database (Oracle Database 10g Enterprise Edition version 10.2.0.5.0) installed in my Network, but I receive this error 503.

If I access localhost:7777 it works well.
If I access SQLPLUS, or PL / SQL Developer works as well.
I try to use DEV10205 and DEV10205.DEVINT in PlsqlDatabaseConnectString but does not work.

This is my DAD

Select all

<Location / pls / plsqlapp> 
   #SetHandler pls_handler 
   Ordem negar, permitir 
   AllowOverride None 
   PlsqlDatabaseUsername wfiti 
   PlsqlDatabasePassword wfiti 
   PlsqlDatabaseConnectString 10.13.238.23:1521:DEV10205.DEVINT 
   PlsqlDefaultPage teste_web 
   PlsqlDocumentTablename scott.wwdoc_document 
   docs PlsqlDocumentPath 
   PlsqlDocumentProcedure scott.wwdoc_process.process_download 
   PlsqlAuthenticationMode Básico 
</ Location> 

and this is my tnsnames

Select all

DEV10205 = 
     (DESCRIPTION = 
         (ADDRESS = (PROTOCOL = TCP) (PORT = 1521) (HOST = 10.13.238.23)) 
         (CONNECT_DATA = (SERVER = DEDICADO) (SERVICE_NAME = DEV10205.DEVINT)) 
     ) 

The error log

Select all

[2014-09-02T15: 49: 11,6161-03: 00] [SST] [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] [livrar: 0] [VirtualHost: main] MODPLSQL-00054: mod_plsql: HTTP-503 ORA-12154 ORA-12154: TNS: não poderia resolver a conexão identificador especificado \ n 

Thanks.

[stcoutinho]

Aramatos,

I do not know if it was your spelling error, but I noticed this text in your connection string:

Select all

SERVER = DEDICADO

Would not it be by chance DEDICATED?
Some points to review:
(a) If your system is Linux / UNIX, have you checked access permissions to the tnnames.ora file?
B) The TNSNAMES file is situated in $ORACLE_HOME/network/admin?
c) Have you tried to take a test with TNPING <nome_servico> on the server where TNSNAMES.ORA is situated, to see if everything is ok?

Hugs,

Sergio Coutinho

[aramatos]

Sergio Coutinho, good afternoon.
Yes, it was typing error. This dedicated

A - Windows environment. 7 Prof 64bit
B - TNSNAMES This in \\10.13.238.32\tns is a network path but SQLPLUS works and PLSQL Developer
c- Yes, tnsping works with DEV10205.

And this is the log I receive when I try to call a procedure.

Select all

 MODPLSQL-00054: mod_plsql: HTTP-503 ORA-12154 ORA-12154: TNS:could not resolve the connect identifier specified\n

Thanks.

[stcoutinho]

I found this note in the Oracle documentation:




i See the error "http-503 or-12154" in the file oracle_home / Apache / apache / conf / error_log. What Does This Mean?

This error Means that mod_plsql is unable to connect to the database.

Ensure that:

The database is up and running.
The username and password information in the dad is correct.
The middle-tier is abke to connect to the database using the plsqldatabaseconnectstring parameter in the dad.
In Most situations, The Problem Occurs Because SQL * NET IS NOT ABLE TO SOLVE THE CONNECT STRING PARAMETER USING THE CONFIGURATION INFORMATION Under Oracle_Home / Network.101 / admin.

for Configured Entries with TSFormat or NetServiceNameFormat, Validate The Connect String Information By Using Tnsping Dad_Connect_String. For example:
tnsping "cn = IASDB, CN = oracleContext"
[/quote]

What would be the "ohs 12c" that you mention in your Initial question? Would you like any kind of application server? In this case, it is not just enough for you to check tnsnames. You need to see other configuration files in the application.

Hugs,

Sergio Coutinho