Error While restarting 10g Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error While restarting 10g Database

  1. #1
    Join Date
    Sep 2005
    Posts
    278

    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

    SQL>startup pfile=<>
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Are your environmental variable proper ?

    what operating system is this ?

    regards
    Hrishy

  3. #3
    Join Date
    Sep 2005
    Posts
    278
    I am using Windows 2000

    Can u tell me wat environmental variables needs to be set?

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    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.


    regards
    Hrishy
    Last edited by hrishy; 01-18-2006 at 02:21 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width