Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can only connect as scott/tiger

I recently installed Oracle 9.2 on my system but am having some problems. I can't connect to the database as sys/change_on_install or system/manager. However I am able to connect as scott/tiger. I want to be able to use the sample schemas such as the OE and HR accounts.

I recently installed Oracle 9.2 on my system but am having some problems. I can't connect to the database as sys/change_on_install or system/manager. However I am able to connect as scott/tiger. I want to be able to use the sample schemas such as the OE and HR accounts. I also want to take the DBA OCA exams -- any advice on sources, books and a better approach to tackle it?
Without any information about the error message you are receiving when you attempt to connect as SYS or SYSTEM, it is difficult for me to provide advice. If you are receiving error messages about the password, it could be that the passwords are not the defaults that you think they are. In this case, you would have to connect as "/ as sysdba" to the database and change the passwords for both SYS and SYSTEM with an "alter user" command. If you are able to connect as the scott user, then the database is open and available.

With respect to the OCA exams, there are some good guides available. A quick search on Amazon or another bookstore will give you some idea of what is available. I have always had good luck with practice exams from SelfTest Software, but I am sure there are others available. My strategy is to read through the guides available prior to the exam, practice what I can with my own personal database, go through the practice exams and then write the exam. Everyone's approach to writing the exams is different, however. Some people prefer to take a course from Oracle University prior to writing the exams so you will need to determine which method works best for you.

Dig Deeper on Oracle DBA jobs, training and certification

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close