Home » RDBMS Server » Enterprise Manager » Big Trouble!! Pls. Help
Big Trouble!! Pls. Help [message #68459] Fri, 03 October 2003 01:49 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi all,

I m facing through a serious problem. We have just installed Oracle 9.0.1.1.1 on Windows 2000 Server. We have 2 databases: MIS (Financial Data) & OEMREP (for Oracle Management Server).
Through OEM, I can see that it is using initialization file in ORACLE_HOME/sysman/ifiles/def_mis.ora for MIS& def_oemrep.ora for OEMREP

Why is it so that spfile is not used, then where all the dynamic changes will be made??

Infact the biggest problem is that when I am starting up the MIS database from SQL prompt using: startup pfile='ORACLE_HOME/sysman/ifiles/def_mis.ora' it is showing the instance name as oemrep(select instance_name from v$instance;), although the database is mis (select name from v$database;) which is impossible because db_name=mis & instance_name=mis in the def_mis.ora.
But, I wonder when same pfile is started through OEM, the instance name is shown as mis(by again going in SQL prompt there & running same select instance_name from v$instance;)

Any help highly appreciated.

TIA,
Sachin
Also............. [message #68460 is a reply to message #68459] Fri, 03 October 2003 02:09 Go to previous message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Also when I am starting the MIS database from SQL prompt , I am getting some password file error for OEM repository (which is illogical)& db is only mounted & after that I have to open the db using : ALTER DATABASE OPEN;

TIA,
Sachin
Previous Topic: Oracle 9.2.0 OEM Performance manager!!!!
Next Topic: OEM role
Goto Forum:
  


Current Time: Mon May 16 07:30:19 CDT 2022