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.