Re: Calling all Server Gurus

Hi

If it personal Oracle. You have to start the database.

If it is on NT then go to control panale and start all the services.

You can also test it whether the 127.0.0.1 is working properly. You can do this go to c:\windows> ping 127.0.0.1 if it is responding it is OK otherwise try to check your TCP settings. (Also check your ODBC drivers if it is a Personal Oracle)

Then you can log in to SQL Plus using SCOTT and tiger. If you are planning to work on the defalut Database/ Instance which is ORCL I don't think you need to configure the tnsnames.ora. Any way network files will be located in Oracl_home\network\admin directory. (Caution plase keep a copy of this files before you are editing any thing manually, so that even if any thing goes wrong you can copy back)

Regards

Eswar

In article <36d7d6bd.782963_at_news.paradise.net.nz>,   actionis_at_hotmail.com wrote:
> Hi
>
> I have installed Oracle 8 on my machine about 1/2 an hour ago.
>
> The problem I am having is:-
>
> 1) most proberly easy to solve for you, but not me
>
> 2) how do I start the server ???
>
> I have a couple of years experience of coding SQL to Access DB through
> a VB interface. As you may or may not know, Access does all the work
> for you.
>
> I want to run a oracle database on my PC as a standalone.
> I have figured out the connection has something to do with sqlnet.ora
> & tnsnames.ora files. But my Oracle experience is limited to half an
> hour and I have no clue to how the files should be coded
>
> I have tried to connect with Net* Assistant with the following info
> tcp 127.0.0.1
> port 1521
> SID ORCL
>
> But the test cannot connect.
>
> SQL Plus won't login (No suprise)
>
> I thank you for any help to get this started
>
> Action
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 00:22:57 CST