Ask the Expert

Unable to log in after installing Oracle Client 9i

I've installed Oracle Client 9i on Windows XP but I cannot log in. I get the error "ORA-12560: TNS:protocol adapter error." Before the installion completed I had a message saying "Database Configuration Assistant fails."

The options I selected are a) Oracle 9i Database 9.0, b) Enterprise Edition and c) General purpose.

I tried to log in using system/manager but I couldn't. Is the reason that the DB Assistant fails or because I didn't enter the host (I didn't know what to enter in this field)?

    Requires Free Membership to View

If the Database Configuration Assistant (DBCA) has failed, it is likely that you do not have a functioning database. Something went wrong or errors were encountered during the creation of your database and the procedure was halted by the DBCA. Check for any log files in $ORACLE_HOMEassistantsdbcalogs -- the DBCA should have created a log file in this directory. Log files may help to pinpoint the source of this problem.

If, in fact, you do have a database created, and it is open and available but you still get these errors trying to log in through SQL*Plus, here are a few more things to check. It could be that your ORACLE_SID and ORACLE_HOME are not set correctly. The problem may also stem from not having the appropriate privileges at the OS level. You must connect to the server with an appropriately privileged account. If you do not have operating system authentication, you will need to provide a username and password that has SYSDBA privileges.

One more thing to watch for is that the SID name you have chosen for your database does not contain a non-alphanumeric character such as an underscore or a dash. The SID can only contain alphanumeric characters.

This was first published in November 2005

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: