Database startup script not working. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Database startup script not working.

  1. #11
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Abhay,

    In fact, I start the 'OracleServicePROD' service prior to starting the database if you looked at the script above.

    I am sorry to misguide you.

    Should I add 'extproc' lines in my listener.ora?

    Thanks a lot guys for taking pain for helping me. I really appreciate.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you have external procedures? if not why add those extproc lines?

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by samdba
    Hi Abhay,

    In fact, I start the 'OracleServicePROD' service prior to starting the database if you looked at the script above.

    I am sorry to misguide you.

    Should I add 'extproc' lines in my listener.ora?

    Thanks a lot guys for taking pain for helping me. I really appreciate.
    SAMDBA:
    Pando is correct extproc has nothing to here, but do add other lines.

    Well to overcome ur probelm try the last thing i can suggest u.
    1) Comment out NTS authentication in SQL*NET.ora
    2) Check in registry if u have set ORACLE_SID as ur dbname in the path HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME
    3) If not set it to PROD in ur case whcich will make this DB as defualt as u dont use connect string in ur batch pgm...
    4) Now loging using pswd of SYS or Internal.
    5) If u can login then ur scripts shud run properly.

    Regards
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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