Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Re: ORA24327: Oracle 8i and Weblogic Server
Re: ORA24327: Oracle 8i and Weblogic Server [message #76450] Sun, 14 July 2002 22:21 Go to next message
Nitin raodeo
Messages: 1
Registered: July 2002
Junior Member
Open the ADMIN console.
In the Properties for the JDBC connection pool, in server name give the TNS name
server=HPDNA2_INCGCIDD.world.
This solves the problem.

The URL will be :
jdbc:weblogic:oracle:incgcidd

SO the problem is related to Tnsnames.ora file and not path or classpath.
hpdna2 is my server and incgcidd is my database.

regards
Nitin
Re: ORA24327: Oracle 8i and Weblogic Server [message #76468 is a reply to message #76450] Fri, 02 August 2002 05:30 Go to previous messageGo to next message
uma
Messages: 67
Registered: May 2001
Member
Hi,

Tried your suggestion.
This is the entry we have in our tnsnames.ora on the machine on which the database resides.

idec817 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (Host = 198.179.201.213) (Port = 1555))
(CONNECT_DATA = (SID = idec817))
)

In weblogic, admin console we have defined the following:
URL=jdbc:weblogic:oracle:idec817

In Properties
server=idec817

We still get the error,
... Starting Loading jDriver/Oracle .....
---------- LOGIN ERROR CODE: 24327
connection pool
"oraclePool" weblogic.common.ResourceException:
Could not create pool connection.
The DBMS driver exception was:
java.sql.SQLException: Error while trying to retrieve
text for error ORA-24327 -
(apps/********@idec817)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
at
weblogic.jdbcbase.oci.Driver.connect(Driver.java:92)...

We are using Weblogic 6.0, SP2.
Any help is appreciated.

Thanks
Uma
Re: ORA24327: Oracle 8i and Weblogic Server [message #76472 is a reply to message #76450] Fri, 09 August 2002 11:40 Go to previous messageGo to next message
Nice guy
Messages: 1
Registered: August 2002
Junior Member
DO NOT DO THIS
In weblogic, admin console we have defined the following:
URL=jdbc:weblogic:oracle:idec817

JUST DO THIS...
In Properties
server=idec817

this worked for me
Re: ORA24327: Oracle 8i and Weblogic Server [message #76475 is a reply to message #76472] Tue, 13 August 2002 00:01 Go to previous messageGo to next message
uma
Messages: 67
Registered: May 2001
Member
Hi,

Tried your suggestion too.
It still doesn't work !

Thanks
Uma
Re: ORA24327: Oracle 8i and Weblogic Server [message #76537 is a reply to message #76450] Wed, 06 November 2002 23:21 Go to previous message
Anil Sonkar
Messages: 1
Registered: November 2002
Junior Member
Following configuration should be done prior starting Weblogic. This error comes when you are using JDriver for Oracle.

1.JDriver being a Type2 driver requires an Oracle Client installation on the server.
2. Set parameters like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH to include correct paths for Oracle installation.
3. Check whether LD_LIBRARY_PATH includes proper 'oci' driver path in it.
4. Do not put any duplicate classpaths inside JAVA_CLASSPATH or WEBLOGIC_CLASSPATH for the oci drivers.
5. Try direct connection from server oracle client SQLplus to connect to Oracle. This should be working.
6. IF not, then modify the TNSNAMES.ORA file to contain the SID properly included.
7. Cheeck the weblogic.properties file, and include this 'SID' as the paramter for connection pool.
Do not include any IP address or path in the connection pool properties.
Foreg: Check the below two parameters :

url=jdbc20:weblogic:oracle:$SID,

and

props=user=$usr;password=$pass;server=$SID,

This should definetly solve the problems.

Thanks
Anil
Previous Topic: Re: ORACLE CERTIFIED PROFESSIONAL TEST EXAM
Next Topic: 9iAS
Goto Forum:
  


Current Time: Thu Mar 28 20:50:27 CDT 2024