Re: ORADIM - Service Created but not started....

What happens if in the script you use the actual sid name and not environment variable?

Steve Bell <stephen.bell_at_sympatico.ca> wrote:

>Thank you for your help Yang,
>
>I had a burtst of optimism and pulled out the copy of the
>script..unfortunately it was me that typed it here incorrectly (typed from a
>hard copy)..the second '%' is in the script.
>
>Interestingly, the service starts if the server is rebooted, but running the
>script alone, or typing the command manually won't start it.
>
>Thanks again.
>
>Yang wrote:
>
>> you have ommitted the right % in ORACLE_SID name :
>> -sid %ORACLE_SID -start...
>> should be :
>> -sid %ORACLE_SID% -start...
>>
>> btw, I don't think you 'have previously able to use the script to...'
>>
>> Stephen Bell wrote in message <3B03FB30.5DCD093_at_cgi.ca>...
>> >Hi all,
>> >
>> >I've been asked to search out some thoughts on an issue by a coworker:
>> >
>> >They use the ORADIM utility in a script (8.1.7 on NT) to create a
>> >service then start it....they have previously been able to use the
>> >script to both create and start the appropriate services..
>> >Recently tho' although the script creates the service it doesn't start
>> >it (of course they can go start it after the fact...)
>> >
>> >Here's the syntax of the command that's supposed to start the service:
>> >
>> >d:\orant\bin\oradim80 -startup -sid %ORACLE_SID -starttype srvc, inst
>> >-usrpwd ora8 -pfile d:\oradir\ini\initsid.ora
>> >
>> >I'd appreciate any thoughts on syntax or advice on determining where to
>> >look to determine why it used to work but doesn't now....
>> >If this is too general , let me know and I'll provide any further
>> >detail.
>> >
>> >Thanks in advance,
>> >Steve
>> >
Received on Mon May 21 2001 - 09:05:24 CDT