-
Ok...now i got the services started...then this is what i did..my pfile is copied from c:\oracle9i\ora92\admin\pfile\heatdb\initheatdb.ora to c:\oracle9i\ora92\database\heatdb.ora
*********************************************************
SQL> connect / as sysdba
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'
**********************************************************
Why is it saying caouldnot open ?...any ideas...
Thanks a lot for all your help
-
It is poiting to different pfile, i.e to " 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'"
where as your pfile is "c:\oracle9i\ora92\database\heatdb.ora"
try
Code:
startup nomount pfile=c:\oracle9i\ora92\database\heatdb.ora
-
Thanks Sameer...Still having problems Creating DB...
**************************************************
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> @c:\createdb.sql
CREATE DATABASE heatdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
***********************************
Any ideas...
thanks
-
This error can occur if the bdump destinations is incorrect or the database server does not have the correct permissions to write in that directory (alert.log file cannot be written)
regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|