Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ORA_24327: Oracle 8i and Weblogic Server

Posted on 2001-09-07
4
1,055 Views
Last Modified: 2007-12-19
Hello,

I hope someone can help me with the following problem:

When starting Weblogic Server on Linux, I get the following error message after loading of native jDriver for Oracle is started:

... Starting Loading jDriver/Oracle .....
----------  LOGIN ERROR CODE: 24327
<Error> <JDBC Connection Pool> <Cannot startup 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 -
(SCOTT/********@oralin)
at weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:92)...

ORA-24327 has the following contents:
-need explicit attach before authenticating a user-
-a server context must be initialized before creating a session-
-create and initialize a server handle manager-

What does that all mean? What steps in detail do I need to perform?

Thanks in advance.
0
Comment
Question by:wnotn
4 Comments
 
LVL 3

Accepted Solution

by:
ramkb earned 20 total points
ID: 6465732

Hi there,

In Weblogic, try configuring the pool connections definition as follows and see if it works..


weblogic.jbdc.connectionPool.<Your pool>=\
url=jdbc:weblogic:oracle,\
...
props=user=<user>;password=<pwd>:server=<connection TNS string>


Cheers,
Ramesh
0
 
LVL 1

Expert Comment

by:balasubram
ID: 6466345
Hi,
Please ensure that there is entry in the "weblogic.properties"  file for the connection pools which it has to create at Weblogic server startup.Ensure that you are using the correct version of Oracle - jdbc driver.If not you could download it from
http://technet.oracle.com/
If u still face problems please copy your weblogic.properties here by which everyone could have a look at it.
Hope this helps,
Bala
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7086061
Hi wnotn,
You've requested to delete this question, but its status remains as 'Pending Delete' because one or more comments have been added.  Normally, the only way to fully delete such a Question is to post a message to Community Support and ask for assistance.

EE is making a one-time database sweep to purge the Pending Delete Questions automatically.  During this sweep:

    wnotn -- To allow the deletion to proceed:  Do nothing.
    EXPERTS -- Please DON'T POST a comment except to contest this deletion.

In the future, please refer to http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.

DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7093236
This question was finalized today.  If more is needed, comment please and I'll return as quickly as I can.
Thank you for your help, Dan, in bringing these Pending items to all of our attention for resolution.
Moondancer - EE Moderator
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question