error JDBC oracle8.1.6
xavier mary
I installed WAS 3.5 with Oracle 8.1.6 on Windows2000
Of course WAS admin server wasn't starting
with those parameter in "admin.config"
com.ibm.ejs.sm.adminServer.dbUrl=jdbc:oracle:thin:@COMPUTER:1521:scott
com.ibm.ejs.sm.adminServer.dbDriver=oracle.jdbc.driver.OracleDriver
WAS won't start with this error:
(from the tracefile:)
FATAL Failed to create a data source: {0} java.sql.SQLException: Io
exception:
Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at java.sql.SQLException.<init>(SQLException.java:45)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at
com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:32)
at
com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:637)
at
com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:590)
at
com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:520)
at
com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:472)
at
com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:424)
at
com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:169)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:113)
at com.ibm.ejs.cm.SMDataSource.getConnection(SMDataSource.java:83)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:183)
at
com.ibm.ejs.sm.server.AdminServer.startConnectionMgr(AdminServer.java:1193)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime(AdminServer.java:984)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:353)
So far I have no idea about the 12505 error message, I 'm
investigating...
Any help very appreciated.
Xavier
Paul Ilechko
Error: Unable to get active column
Cause:
You have a database problem.
Do you have a WAS database created in Oracle ?
Jacques Desmazieres
com.ibm.ejs.sm.adminServer.dbUrl=jdbc:oracle:thin:scott/tiger@COMPUTER:1521:ORCL
or, if you do not want to specify user/password
com.ibm.ejs.sm.adminServer.dbUrl=jdbc:oracle:thin:@COMPUTER:1521:ORCL
I Think there is a confusion between the database SID and the schema name
Jacques Desmazières
"xavier mary" <xav...@nol.fr> a écrit dans le message news: 3AB773C7...@nol.fr...
fred urger
you should create the db scott on the host COMPUTER with a user and password as specified in the same
file...
xavier mary
Do you have a WAS database created in Oracle?
NO what is it?
Do I need to start admin server to create it?
Actualy TNS 12505 says TNS listener could not resolve SID given in connect descriptor
( where is located this definition for this connect descriptor?)
Oracle says to check tnsname.ora and init.ora.
I don't see anything wrong with those.
tnsname.ora
=========
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
CONTROL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Computer)(PORT = 1521))
)
(CONNECT_DATA =
(SID = control)
(SERVICE_NAME = control)
)
)
init.ora
=====
db_name = "control"
instance_name = control
service_names = control
....
Xavier.
Bill Hudacek
I've only used the Enterprise version of Oracle so take from this what you can -- you first create a userid using the Security Manager, then use Storage Manager (IFF you don't want to use defaults for data, index, temp, etc). Then, when WAS starts up, *it* will create the database under the service 'scott' with "schema" equal to your database userid.
Are you sure you want 'scott' there? That would make it a service, and good ol' scott tiger has never been service before :-)
--
William G. Hudacek, M.S.