Re: new user needs help

Hi,

    First things first -

a) Have U installed the Oracle Server software ? If so..
b) Have you created a database on your system ?
c) If yes, Is the instance up ?
d) Can you connect locally ?

For a) try running the Oracle installer ( infact set autorun in your machine and put in your Oracle CD ) and verify what all things are installed on your machine. If you haven't installed go in for the typical install and proceed as instructed.

b) Go to Control panel/Services and check whether U have a couple of services like OracleServiceORCL and OracleStartORCL ( or something similar - Cannot recall exact names in Oracle 8 ) If no specified services are present - then probably U haven't created a database.

c) If in b) U identified that U have a couple of services as specified then make sure U start then..

d) login to the database using the default logins like for system the password is manager; sys is change_on_install. If sqlplus demands an tns connect string.. go to dos prompt, say SET <ORACLE_SID> #where ORACLE_SID is your database name which is also present in the service name like OracleServiceORCL ( ORCL is the ORACLE_SID ) and try using C:\>sqlplus system/manager ( dos version )
U should be able to connect to the database...

HTH,
justvrk

"Rizzo" <rizzo_at_sympatico.ca> wrote in message news:rNJR5.97374$1C6.3893078_at_news20.bellglobal.com...
> I just put NT Server on my computer and Oracle 8i. I'm taking a DBA
> class at the local college and when I log in there I enter my name,
 password
> adn the location is db03 then I get into 8.0SQL and can type in my sql
> statements to create tables, users, etc. My computer is a stand alone
> machine and I used the default settings during the installation of Oracle
> when it asked me for IP address, etc.
>
> When I try to log in on my computer I don't know what to type in these
> fields. I'm still a novice user and I'm assuming that I have to set up
> myself as a user as well an instance, etc. How do I get past the log in
> screen and to the point where I can use the SQL screen to run SQL
> statements. Any help up be great.
>
> Thanks in advance
> SunilS
>
>
Received on Tue Nov 21 2000 - 17:01:39 CET