Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help with WinXP install

Re: help with WinXP install

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 13 Jan 2005 12:48:37 +0100
Message-ID: <cs5n4n$4jv$1@news3.zwoll1.ov.home.nl>


dak wrote:
> Well, downloaded 10g at home and installed on my P4, 2.8 whichit took much
> less time and I didn't get any (IP or other) errors. For the time being, I
> give up. I have no idea
> what USERNAME or HOST STRING I should be using to log on. I just accepted
> all the standard defaults during the install and it never asked me for a
> username.
> 1. Can someone tell me what username and host string I should be using and
> where I find this info out ?
> 2. How/where does sysadm log on to create users to the dB ?
> Tks
>
>

[snip!]
Now, it's time to Read The Fine Material in print... One of those defaults (which you did take notice of...) is orcl (as SID name). Open a command box, and type: set oracle_sid=orcl
net start oracleServiceorcl
sqlplus '/ as sysdba'

Line 2 may respond it's already started, which is fine. Just to make sure...
You're now ready to create your instance. For a default starter db, all user accounts are documented, with passwords. You could:
SQL> startup
...

If already started, try:
SQL> connect scott/tiger
This is one of the demonstration accounts; not sure if it's installed on a default installation instance - never tried one...
You should now be able to:
SQL> select * from emp;

-- 
Regards,
Frank van Bortel
Received on Thu Jan 13 2005 - 05:48:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US