Re: Logon & stopping and starting processes on local machine

Mick A wrote:

> Could someone give me a bit of advice. I recently completed
> introduction to 9i course and use Oracle at work.
> I decided to d/l the version of oracle to play around with on my
> laptop.
>
> Two questions:-
>
> I have installed a database, which I can connect through in enterprise
> manager, but when ever I log on in sql+ get this message.
> Ora -12154: TNS: Could not resolve service name.
> What do I need to put into my tnsnames.ora (or where else) to connect
> to the local machine?

Suggest you look for the Network Configuration Assistant to do this.

>
> Also I would like to have a couple of batch files on my pc to stop and
> start the oracle processes, as and when I need them. What do these
> need to contain.

Check if your OS includes dbstart & dbshut. If it does .. Then check the install manual for the config of these. Received on Sun May 11 2003 - 00:46:08 CEST