Xref: alice comp.databases.oracle.server:42104
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.algonet.se!algonet!news-fra.maz.net!newsreader.gigabell.de!newsreader.ipf.de!not-for-mail
From: Frank Zuern <fzuern@gmx.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Calling all Server Gurus
Date: Wed, 03 Mar 1999 17:18:09 +0000
Organization: gigabell.de
Lines: 42
Message-ID: <36DD6ED1.C5FB1F8A@gmx.net>
References: <36d7d6bd.782963@news.paradise.net.nz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.ipf.de 920477956 51618 195.88.132.77 (3 Mar 1999 16:19:16 GMT)
X-Complaints-To: abuse@ipf.de
NNTP-Posting-Date: 3 Mar 1999 16:19:16 GMT
X-Mailer: Mozilla 4.5 [de] (WinNT; I)
X-Accept-Language: de

It depends which OS you're using.
Generally you have to start two parts of Oracle.
First part is the so called SGA which is your physical oracle instance.
Second part is the Listener, which connects your sql/net to your
database.
The tools vary completely between NT and Unix, so you have to
figure out yourself which tools you're needing to start

actionis@hotmail.com schrieb:

> 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