Hi,

Let me give brief you the requirement:

Basically we are planning to have a single database server which will have 3 instances(belonging to different countries).
Ex: Singapore, India and Australia.

The server is going to be located in India.

Our application uses SYSDATE a lot. So whenever I give a query like 'select to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') from dual' I would like to see the country-specific time.

I did a bit of research on this and found out that,

1. Start OracleServiceIndia by setting the Time Zone to India.
2. Start OracleServiceAustralia by setting the Time Zone to Australia and the same method for Singapore.

This gives a impression that whenever the service is started it is picking up the time zone from the OS and based on that
it sets the time zone and the sysdate. If we follow this method then it works fine.

But if someone starts the service(without changing the time zone) then the entire application will go for a toss.

Can we specify the time zone while starting the service or is there any other work around for this.

Thanks.