Hi guys,

After we upgraded from Oracle application 11.0.3 on WinNT to 11i on W2K, my starting scripts are not working properly. We are on 81730.

on 11.0.3's server, following was the sequence of database and its listener starting.

CALL %SCRIPT_DIR%\odedbctl.cmd %1 start %2 %3 %4
CALL %SCRIPT_DIR%\odelsctl.cmd %1 start %1

The same script does not run successfully on new server with 11i.

it generates following errors in startup.log
SQL*Plus: Release 8.1.7.0.0 - Production on Sun Dec 29 18:41:38 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0640: Not connected

And it generates foll. errors in odedbsr.sql.
SQL*Plus: Release 8.1.7.0.0 - Production on Sun Dec 29 18:41:36 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
ORA-12560: TNSrotocol adapter error

I also want to know that what should be the correct sequence of starting database, listener and 'OracleServicePROD' service on windows server.

Thanks in Adv.


odedbctl.cmd
---------------
ECHO .
IF "%1" == "" GOTO usage
IF "%2" == "" GOTO usage
IF "%3" == "" GOTO usage

SET control_code=%2

IF "%2" == "start" GOTO mode_ok
IF "%2" == "stop" GOTO mode_ok
GOTO usage
:mode_ok

SET ORA_ENVFILE=E:\oa\oracle817\%1env.cmd
SET SCRIPT_DIR=E:\OA\ADMIN\%1\SCRIPTS
SET ORACLE_HOME=e:\oa\oracle817

if "%control_code%" == "stop" GOTO stop_db

IF "%4" == "" GOTO usage
IF "%5" == "" GOTO usage

ECHO .
ECHO Building svrmgrl scripts for %1 ... .
ECHO .

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

ECHO .
ECHO Starting the database %1 ... .
ECHO .

net start OracleService%1
SET LOCAL=
SET ORACLE_SID=%1
E:\oa\oracle817\bin\sqlplus.exe /nolog @%SCRIPT_DIR%\odedbsr.sql >> %SCRIPT_DIR%\odedbsr.log
E:\oa\oracle817\bin\sqlplus.exe /nolog @%SCRIPT_DIR%\odedbup.sql >> %SCRIPT_DIR%\startup.log

GOTO finish

:stop_db

ECHO .
ECHO Building svrmgrl shutdown script for %1 ... .
ECHO .

ECHO connect internal/%3 as sysdba; > %SCRIPT_DIR%\odedbdn.sql
ECHO shutdown immediate; >> %SCRIPT_DIR%\odedbdn.sql
ECHO exit; >> %SCRIPT_DIR%\odedbdn.sql

ECHO .
ECHO Shutting down database %1 ... .
ECHO .

SET LOCAL=
SET ORACLE_SID=%1
E:\oa\oracle817\bin\sqlplus.exe /nolog @%SCRIPT_DIR%\odedbdn.sql >> %SCRIPT_DIR%\shutdown.log
net stop OracleStart%1
net stop OracleService%1

:finish
REM del %SCRIPT_DIR%\*.sql
ECHO success
GOTO end

:usage
ECHO .
ECHO odedbctl.cmd .
ECHO Start / Stop database .
ECHO .
ECHO Usage .
ECHO odedbctl.cmd {appl_config} {start} {internal pwd} {sys pwd} {apps pwd}.
ECHO odedbctl.cmd {appl_config} {stop} {internal pwd} .
ECHO .
GOTO end


odelsctl.cmd
---------------
ECHO .
ECHO You are running odelsctl.cmd .
ECHO .

IF "%1" == "" GOTO usage
IF "%2" == "" GOTO usage
IF "%3" == "" GOTO usage

SET control_code=%2
SET listener_name=%3

IF "%2" == "start" GOTO mode_ok
IF "%2" == "stop" GOTO mode_ok
GOTO usage

:mode_ok

SET ORA_ENVFILE="E:\oa\oracle817\%1env.cmd"
SET ORACLE_HOME=e:\oa\oracle817
SET TNS_ADMIN=e:\oa\oracle817\network\admin

if "%control_code%" == "stop" GOTO stop_lsnr

ECHO .
ECHO Starting listener process %3 ... .
ECHO .

E:\oa\oracle817\bin\lsnrctl start %3

GOTO finish

:stop_lsnr

ECHO .
ECHO Shutting down listener process %3 ... .
ECHO .

E:\oa\oracle817\bin\lsnrctl stop %3

:finish

ECHO success
GOTO end

:usage
ECHO .
ECHO odelsctl.cmd .
ECHO Start / Stop Net8 Listener process .
ECHO .
ECHO Usage .
ECHO odelsctl.cmd {appl_config} {start/stop} {listener} .
ECHO .
ECHO In general, available listeners are: .
ECHO Database Net8 listener : {ORACLE_SID} .
ECHO Applications RPC listener : APPS_{ORACLE_SID} .
ECHO .
GOTO end

:end