Service OracleTNSListener80 start pending.
Service OracleTNSListener80 started.
TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production
System parameter file is C:\orant\NET80\admin\listener.ora
Log messages written to C:\orant\NET80\log\listener.log
Trace information written to C:\orant\NET80\trace\listener.trc
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=240)(HOST=127.0.0.1)(PORT=1521))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=252)(HOST=127.0.0.1)(PORT=1526))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=mspark)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 -
Prod
uction
Start Date 07-MAR-01 01:00:30
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level user
Security OFF
SNMP OFF
Listener Parameter File C:\orant\NET80\admin\listener.ora
Listener Log File C:\orant\NET80\log\listener.log
Listener Trace File C:\orant\NET80\trace\listener.trc
Services Summary...
ORCL has 1 service handler(s)
extproc has 1 service handler(s)
The command completed successfully
*************************
LISTENER.ORA FILE
*************************
# C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration
File:C:\orant\NET80\ADMIN\LISTENER.ORA
# Generated by Oracle Net8 Assistant
STARTUP_WAIT_TIME_LISTENER = 2
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mspark)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = mspark)(PORT = 1526))
(ADDRESS = (PROTOCOL=IPC)(KEY=EXTPROC0))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mspark)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
)
TRACE_LEVEL_LISTENER = USER
**************
JDBC SOURCE
**************
import java.sql.*;
class JdbcTest
public static void main (String args []) throws SQLException
// Load Oracle driver
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
// Connect to the local database
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@127.0.0.1:1521:ORCL",
"scott", "tiger");
// Query the employee names
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select ename from emp");
// Print the name out
while (rset.next ())
System.out.println (rset.getString (1));
}
}
****************
TRANSNAME.ORA
***************
# C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration
File:C:\orant\NET80\ADMIN\TNSNAMES.ORA
# Generated by Oracle Net8 Assistant
CMEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
(ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = YES)
)
TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
NMPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA = (SID = ORCL))
)
EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)
BEQ-LOCAL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 =
oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
(CONNECT_DATA = (SID = ORCL))
)
SPXEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))
)
TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
*************
ERROR MESSAGE
*************
C:\jdk\bin>java JdbcTest
Exception in thread "main" java.sql.SQLException: ORA-01033: Message 1033
not fo
und; No message file for product=RDBMS80, facility=ORA
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:224)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:251)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at JdbcTest.main(JdbcTest.java, Compiled Code)
The message
Message 1033 not found; No message file for product=RDBMS80
seems to point to a installation problem. Obviously the driver
tries to interpret the error code with a message text, but its
definition can't be found.
I'd suggest to set try-catch-blocks around the statements
DriverManager.registerDriver( ...
.. DriverManager.getConnection( ...
.. conn.createStatement( ...
.. stmt.executeQuery( ...
to see where the exception is thrown.
If you can point out the wrong statement, post again.
Regards,
Hartmut
the following one of my simplest listener.ora.
looks rather similar to yours. TNSNAMES.ORA is
not a player in case of thin driver.
Try to cut down unnecessary entries in your LISTENER.ORA
(always backup starting settings)
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Default)
(SID_NAME = ORCL)
)
# *** may be removed also ?????
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
# *************************
)
AlexV
"mspark" <linuxcr...@yahoo.co.kr> wrote in message
news:9872q5$a9u$1...@hiline.shinbiro.com...