Re: create db in VMS - urgent

Leng,

There is a VMS logical that defines the connect string. it is ORA_DFLT_HOSTSTR. This should be set in the format:

   net protocol:host:ORACLE_SID

   e.g. T:ADMIN:OSID

   will allow
   connections via TCP/IP to host ADMIN, database OSID.    Just make sure sqlnet is running.

Hope this helps

Beverly Norwood, Systems Manager/DBA
Augusta College
(706) 737-1484 or GIST 337-1484
Internet: bnorwood_at_admin.ac.edu

        /////////////////  MAY THE FORKS BE WITH YOU! ////////////////

>
> I've gone thru the oracle installer many times as suggested below but the
> outcome is the same:
>
> DBA-00314: unable to attach to default host
> ORA-06400: NETCMN: No default host string specified
>
> Yes, the installer prompts me for things. But when it gets to the part of
> executing the create db script in sqldba, it fails with the above messages.
>
> I'm still stuck. Please help.
> Leng.
> ----------
> From: Wolf^..^Eyes
> To: LKaing
> Subject: create db
> Date: Tuesday, January 30, 1996 9:31AM
>
>
> Greetings - your best bet for creating a new database instance under VMS
> is to use the ORACLEINS.COM. This is located in the
> install sub directory of the software root directory.
> like :
> $ set def disk$whatever:[oracle.root.install]
>
> $ @ORACLEINS
>
> It will prompt you for information. It will take care
> of a lot of things that you don't want to do manually.
>
> A few cautions : Create the directory structure for the
> database files before attempting to create the database.
>
> Be sure that your VMS account has the correct privliges and
> process rights identifiers, and that your UIC is greater than
> max sysgroup.
> Nice R.Taylor sucb dba ^..^
>
Received on Wed Jan 31 1996 - 13:20:45 CST