How can you know that the database has connected to your
weblogic server
- 13 Answers
- 29959 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / zahid
in admin console you can go to the JDBC->connection pool-> test
it will test the pool and display the result, if the
application is connected to the db it will show a test
successful message else error
| Is This Answer Correct ? | 35 Yes | 1 No |
Answer / eswaran
you can get the connection details by executing netstat -a
| grep <ipaddress of DB Server
| Is This Answer Correct ? | 19 Yes | 1 No |
Answer / vivek tripathi
1.In admin console you can go to the JDBC->connection pool->
You will find status as running if DB is up i.e connected.
And to be more confident
JDBC->connection pool-> test
- Test connection successfully ( test connection attributes
in the advance configuration of the connection pool should
be checked and there should be a dummy table -- "dual" is by
default)
- If "Test connection" attributes are not checked then a
warning will appear.
2. If a DB connection is not available , you can find
related message in the server logs also.
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / enigma
All the database connections are logged during server
startup in the server logs.
| Is This Answer Correct ? | 15 Yes | 4 No |
Answer / john
The database never connects to WebLogic Server: the WebLogic Server connects to it :) .
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / gopal
Do a netstat -an | grep 1521 | wc -l will display how many
DB connection made.
and also netstat -an | grep <IP of the DB>
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ravi kumar
if you give# netstat -n | grep <database id> in unix box
it will show the connection between the DB and Weblogic
server.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mohit
You can check the availability of the Database to your WLS,
by testing the connection pool in admin console.
Before testing from console, you should make sure to check
if either of the properties to check DB is enabled for
connection pool (eg. Test connection on reserve) as well as
test query for DB is provided.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinivas
telnet <DB box IP> 1521 from weblogic box, if response is
coming DB is avialable.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kantha
Use the following Steps to make sure that you are able to
connect to the DataBase Box from the WLS Server Box…
Step1). Add JDBC Driver also in the Classpath or Better run
“setWLSEnv.sh”
Step2). Use WLS DB Ping utility:
Syntax:
java -classpath /bea103/wl_server103/server/lib/weblogic.jar
utils.dbping ORACLE_THIN <dbUserName> <dbPasswoes> <dbURL>
Example:
java -classpath /bea103/wl_server103/server/lib/weblogic.jar
utils.dbping ORACLE_THIN scott tiger
databaseHostName:1521:P15215h
| Is This Answer Correct ? | 2 Yes | 0 No |
What Is The Advantage Of Clustering ?
What are the enhancements in ejb 2.0 with respect to cmp?
how to create a sub domain in domain ?
What is meant by full gc and explain it?
How do I restrict access to servlets and jsps? : BEA Weblogic
what are the gbx,gdb and other tools in linux for core dump,and how to configure stdout,stderr..what is the difference between stdout ,stderr and coredump. how to create core dump and view that one? please can anybody explain me?
What is the major difference between managed server and admin server?
Difference between Weblogic server and websphere server?
What are the ways in which weblogic servers can run on multiple machines?
1. What is clustering? How do weblogic instances communicate in a clustered environment! 2. In a cluster, if one of the servers has issues and is not accessible, will the other servers know about it? and how??
How can the nm be made to work with web logic? Explain?
What Are The Various Types Of Weblogic Installations ?
Core Java 
