Ask the Expert

Database Configuration Assistant error after install

I am trying to install an Oracle9i database server on a Dell Pentium 4 (2.6ghz, 750 MB ram, 80 GB hard disk) running Windows XP Pro. After the install completes, the Database Configuration Assistant starts and tries to set up the sample databases. Soon after sqlplus.exe starts, I get an error: "TNSLSNR.exe has a problem and has to close." This is the generic windows message. There is no specific error message from the module which failed (I believe it's the listener which establishes physical connections to the database on behalf of a client). The remaining tools do not install and the Oracle system is unusable. I have tried running the install with my virus scan and privacy software disabled (McAfee Security Center), but I get the same error. I would greatly appreciate any help you could offer.

    Requires Free Membership to View

If the first error you receive is during the Database Configuration Assistant's activities, then your installation is likely just fine, but you have no running database. You can run the Database Configuration Assistant at any time after the installation. It sounds like your issue isn't related to the installation directly, but rather to the first use of the listener following installation. Here are some troubleshooting tips (in no particular order):

1. Completely deinstall the security product you mentioned (McAfee Security Center). I'm not familiar with that product, but it sounds like a product that may effect the networking on the system in some way.
2. Look in the listener.log file (%ORACLE_HOME%networkloglistener.log) for any output.
3. Open a command prompt and use the lsnrctl.exe utility to start the listener (%ORACLE_HOME%binlsnrctl.exe start) and see if the output shows any errors.
4. Enable tracing on the listener by setting the trace_level_server = 16 in the %ORACLE_HOME%networkadminsqlnet.ora file and re-examine the listener log file and any trace files in %ORACLE_HOME%networktrace on the server.
5. Ensure that the built-in firewall capabilities in Windows XP are disabled.

One of those steps will likely yield additional information that may point you to the problem. At the very least, you should have enough information to do some additional Internet searches for possible causes.

This was first published in March 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: