| Big Trouble!! Pls. Help [message #68459] |
Fri, 03 October 2003 01:49  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
