Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pool problem

 
Mary Cole
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am creating a oracle connectionpool using weblogic5.1
All the parameters in the weblogic properties file are passed correctly.
When I start the weblogic server I get an error saying
ORA 24327 -need explicit attach before authenticatin a user.
Pl help me where I am wrong or any settings I have to make
Thanx in advance
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mary, I am moving this to the WebLogic forum as you are more likely to get a response there.
 
sandy gupta
Ranch Hand
Posts: 228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Seems like your database will not allow remote connectivity to the database ... try to log on from the sql plus screen and see if u can log in using the same login name , pass, and the host string and if yes contact your DBA for the problem...
HTH
Sahil
 
sandy gupta
Ranch Hand
Posts: 228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I Case the db is remote, modify the tnsnames.ora appropriately
 
hanumanth reddy
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

U need to set up Connection pooling in the properties file and see tha u have permission to connect to the database
see jdbc documentation for more help
 
zhljgh
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, which database driver you use, is oci or thin? if thin, you
'd better select the compatible driver to the Oracle Database, if oci, you must set the config right.
 
Jim Baiter
Ranch Hand
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got into a battle with this using the Weblogic drivers. When I switched and used the Oracle drivers, (classes12.zip), I had no problem.
Originally posted by Mary, Cole:
Hi All,
I am creating a oracle connectionpool using weblogic5.1
All the parameters in the weblogic properties file are passed correctly.
When I start the weblogic server I get an error saying
ORA 24327 -need explicit attach before authenticatin a user.
Pl help me where I am wrong or any settings I have to make
Thanx in advance

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic