Q

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."

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)?

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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close