While installing Oracle9i Standard Edition I received the following error: "Error in writing to file d:oracleora90assistantstemplatesTransaction_Processing.dfj." After ignoring this I installed the software but I can't connect to the database with scott/tiger.

    Requires Free Membership to View

After the installation of the Oracle software, did the Database Configuration Assistant (DBCA) successfully create a database for you? There is no mention of a database being created in your explanation of the problem so the reason you may not be able to connect to a database is that one does not exist. Another reason I mention this is because the subdirectory mentioned in the error message is one used by the DBCA to store templates. Depending on how you asked the DBCA to create a database, if it cannot store a template from which to create a database from, it may not be able to successfully create a database.

Check the Services panel to see if an Oracle database service has been created. If it has, check the oradim.log file to see whether the service started up successfully. If it has, check the database alert log to determine whether the database creation was successful and whether the database has been opened. If these checks are all successful, it could be that the scott schema does not exist in your database. Log into the database as the SYS user as follows to check for the scott schema:

sqlplus /nolog
connect / as sysdba
select * from dba_users where username='SCOTT';

If this returns a row, then the scott schema does exist. At this point, it could be several issues. The scott password is locked (review the previous SQL output to see if ACCOUNT_STATUS is LOCKED), or the password is not tiger. If the account is not locked, issue the following command to change the password:

alter user scott identified by tiger;

This was first published in May 2006

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: