| Re: ORA24327: Oracle 8i and Weblogic Server [message #76450] |
Sun, 14 July 2002 22:21  |
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  |
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 #76537 is a reply to message #76450] |
Wed, 06 November 2002 23:21 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
