| ORA-1041 internal error. [message #66479] |
Tue, 02 July 2002 04:04  |
Avtar Mahajan
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
Problem:
We get the error message ORA-1041 internal error.
Communication channel seems to drop between production Weblogic Server and Database Server. We are starting the Weblogic Server with 10 database connections (by setting initial connections parameter of connection pool to 10 ). For couple of hours we are able to do the transactions on the website which acceess the database. Then the connection is dropped. Niether the Weblogic Server nor the database is down but they cannot communicate i.e we can access the database from SQL*Plus and Weblogic Server can display the pages which do not require database access. When this error occurs we restart the Weblogic server and the problem disappears.The possible causes:
1. Network connection problem between the Webloc Server and Databae Server
2. Timeout of the database connections.
Please can anyone tell me how to trace out this problem. This problem happens once every day at random. But there was a strech of 3 days when this problem didn't occur. This has reduced the possibility of timeout.
Any help will be very much appreciated.
Technology Stack
- iPlanet Webserver 4.0 Enterprise edition on Sun Solaris Server
- Weblogic Application Server 6.1 on Windows 2000 Server
- Oracle 8.1.5 on Sun Solaris Server
We are running three instances of the Oracle Databases on this server
Software
- J2EE (EJB/JSP/Servlet)
JDBC Driver
- Weblogic Server talks to Oracle database using Oracle Driver 8.1.7
|
|
|
|
|
|
| Re: ORA-1041 internal error. [message #66489 is a reply to message #66479] |
Thu, 04 July 2002 03:01  |
Avtar Mahajan
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
Dear Mahesh,
Thanks for your reply.
I have done the follwoing:
On Clinet Side:
1. Modified the sqlnet.ora : added the following parameters
==== BEGIN SQLNET.ORA ON CLIENT ======
trace_file_client = sqlnetserver1.trc
trace_level_client = ADMIN
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
names.default_zone = world
automatic_ipc = off
names.log_directory = /oracle/app/oracle/product/8.1.5/network/log
names.log_file = sqlnetserver.log
names.log_stats_interval = 5
names.trace_directory =/oracle/app/oracle/product/8.1.5/network/log
names.trace_file = sqlnetserver.trc
names.trace_level = ADMIN
sqlnet.expire_time = 10
===============================================
QUESTIONS ABOUT SQLNET.ORA ON CLIENT SIDE
===============================================
Q1. It has generated the trace file on the client side. How to interpret it ?
Q2. No SQLNet Logfile has been generated ? Why ? When do the SQLNET log file is created ?
Q3. I am not sure the usage of names.trace_file ?
Q4. Am I right sqlnet.expire_time = 10 has no meaning on client side.
=========================================
SQLNET*ORA on SERVER SIDE
=========================================
The parameters are same as the client side except the change has been made to the file and directory names.
=======================================
QUESTIONS
=======================================
1. No entry has been made to SQLNet Logfile has been generated ? Why ? When do the SQLNET log file is created ?
2. Since it is a production box I did not stop the listener. Is that could be the reason it didn't generated the SQLNET Log.
===============================================
LISTENER.ORA file on the SERVER
===============================================
1. It produes the TRACE Files and LOG Files and have connetion_timeout parameter set to 10 seconds
=============================================
Question
==============================================
Q1. How to interpret the trace file? Is there any help available on line for this ?
Could you be kind enough to answer the above question.
Many Thanks,
Avtar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
