Error While restarting 10g Database
I am using Oracle 10g on Windows 2000.
My requirement is to add one parameter to pfile, but there is a strange error which i never come across on 9i.
SQL> shutdown immediate
ORA-24324: Service handle not initialized
ORA-01041: Internal error: hostdef extension doesn't exist
And there is one more strange behaviour while i shutdown the database , the status of database is showing as started in windows services.
thanks in advance
Are your environmental variable proper ?
what operating system is this ?
I am using Windows 2000
Can u tell me wat environmental variables needs to be set?
You need to set the ORACLE_HOME
and the oracle SID at minimum
Oracle_HOME would be the full path to the oracle binary executable.Oracle sid will be the name of the SID you want to connect to.
Are you able to connect through GUI version of sqlplus or enterprise manager.
Last edited by hrishy; 01-18-2006 at 02:21 AM.
Click Here to Expand Forum to Full Width