Re: create database and new instance

orclnewbee_at_gmail.com wrote:

> Hi guys I am new to oracle - I am a informix dba.
> I was experimenting and wanted to start learning oracle.
> I have installaed oracle 9 on my windows XP and wanted to create a new
> instance and a new database on it.
>
> Please guide me.

First off ... learn the language. In Oracle a database is the physical files on the hard disk. The instance is the processes (or threads) running in memory. There is the ability to have a 1:M relationship between the two.

Likely you already have both already. What you likely want is to create a schema which is a combination of a userid and password.

To check whether a database exists look at Windows Services and see if you have services with names like: OracleOraDbHomeTNSListner (should be Started) OracleServiceorcl (should be Started)

Then log in to SQL*Plus with
User Name: / as sysdba

If that is successful just create a user.

I'd suggest a quick trip to http://tahiti.oracle.com for general research and to http://www.psoug.org click on Morgan's library
click on Users
for how to create a user account.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)