ECHO connect internal/%3 as sysdba; > %SCRIPT_DIR%\odedbsr.sql
ECHO startup restrict pfile=e:\oa\oracle817\database\init%1.ora; >> %SCRIPT_DIR%\odedbsr.sql
ECHO exit; >> %SCRIPT_DIR%\odedbsr.sql
ECHO connect internal/%3 as sysdba; > %SCRIPT_DIR%\odedbup.sql
ECHO alter system disable restricted session; >> %SCRIPT_DIR%\odedbup.sql
ECHO exit; >> %SCRIPT_DIR%\odedbup.sql
Before these lines, you are not setting up the ORACLE_SID, and that's why you are getting:

ORA-12560: TNSrotocol adapter error
Also, you can connect just as INTERNAL, instead of "internal/password as sysdba". Did you ran the above lines step-by-step from the MS-DOS command line?


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site