This content has been marked as final. Show 9 replies
something is wrong if this is the case. It looks like $OH or the SIDs are wrong.
can you do sqlplus "/ as sysdba" with nothing else ?
emca logs probably in either cfgtoollogs or $OH\sysman\logs or $OH\SID_HOST
The $OH and the $SID is correct. I can do a "/ as sysdba" without any problem.
I found the log at /cfgtoollogs. Except a "ORA-01034 error - Oracle not available" it does not give me any clues.
There is an issue with this install however: If i set the $OH without a trailing /, I get an error saying "Connected to an idle instance" when connecting "/ as sysdba". If I add the trailing / it works nicely. Could this be a part of the problem? From what I've seen earlier its the opposite that have been a problem.
Where does emca get the ORACLE_HOME and ORACLE_SID information? There are no changes in how emca responds whether I use a trailing / or not.
EMCA uses the environment OH and SID
looks like Unix but the trailing slash shouldn't need to be set, as you say when it is set then it usually causes problems
this may be the root of the issue
Found that my databases $OH is missing in /etc/oratab. It only contains the $OH of Repository creation assistant.
Could this be an issue regarding the described problems?
I tried to add the $OH instance in /etc/oratab. Now the DBCA finds my database instance. But it says that my instance is not mounted when I select it in DBCA. Most likely it is due to the "trailing /" issue in earlier referenced thread.
If I set my $OH without a trailing / when connecting with "sys as sysdba", I get the "connected to an idle instance" error.
Yes, dbca uses /etc/oratab, and if there are no lines with your ORACLE_HOME, then no DBs are shown. I did some tests on my Linux machine, and the trailing / is not relevant to me (for dbca), but I'm using 10.2, and I don't have your exact version on hands at the moment.
Did you try with and without trailing slash in /etc/oratab ?
Yes, I did. It didn't make any differense.
Also tried different ORACLE_HOME settings when starting DBCA. That also made no impact on the result.
These are the current settings in etc/oratab:
Thanks for your reply!
In any event to configure DB Control is done via emca -configure db control db etc
dbca is a bit misleading in this regard.
it works on both Linux,Solaris, WIndows, Hp fine; <-I've done all of these.