Re: Create Database ...

Jones Chung wrote in message <357c9841.341806906_at_news.seed.net.tw>...
> 1. I try to see the instance that I just created by using the
> instance manager (VAI.exe), giving the entrance condition:
> UserName: internal
> Password: test
> Service: TEST
> Connect As: Normal
> It failed! It told me there was no such service. How do I
> achieve it?

It likely fails as you have not define a TEST alias in the TNSNAMES.ORA file. Use SQL*Net Easy Config to create a TNS alias for your database. You will then also need to configure the listener (LISTENER.ORA file) and startup the listener to enable it to receive connection requests for your database.

> 2. In fact, I can use the server manager to connect by the
> previous entrance condition, why ?

Because you're using a local connection. Using a special protocol, the client application communicates directly with the Oracle instance, unlike the standard client-server connections that have to connect via the Oracle Listener (the network component that allows other machines connection to Oracle).

> 3. How can I use internal to connect to SQL- Plus to create
> database? I already tried many times but it always told me :
> insufficient privileges (username: internal / password: test),
> why ? It confused me many days.

You should use the Server Manager program instead to create the database (program svrmgrxx.exe where xx is 23 for Oracle 7.3 or 30 for Oracle 8). You also need to setup the ORACLE_SID environmental variable first.

> 4. Is it possible to create a database by using schema
> manager, enterprise manager or server manager?

I suggest doing it manually instead. Read the Oracle Documentation - it's specifies step by step on how to create an Oracle database, and what admin scripts to run to create the data dictionary catalogs etc.

Here's a quick example (let's say the database is called DW80): 1. Create the init.ora file (use an exisiting one as template

2. Create the instance:
C:> oradim80 -NEW -SID dw80 -INTPWD sa -STARTMODE AUTO
-PFILE c:\orant\database\initdw80.ora

3. Set the environement variable:
C:> SET ORACLE_SID=TEST 4. Connect cia Server Manager and create the database: C:> SVRMGR30
> connect internal/sa
Connected to an idle instance

5. Do a startup nomount and create the database.

regards,
Billy Received on Mon Jun 08 1998 - 06:20:30 CDT