Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Create Database in VMS
Env: Oracle 7.1.3, VMS 6.1
Hello everyone,
I feel really silly asking this... but how does one go about creating a database in VMS? I've done this many times on various flavours of unix. But can't succeed on VMS. Been screwing my eyes and brains out for a LONG day and can't get anywhere.
Here's my ora_instance:orauser_pp_prd.com:
$ define/nolog ora_instance agxprapp07:[oracle7.pp_prd.dba]
$ define/nolog ora_db agxprapp07:[oracle7.pp_prd.dba]
$ define/nolog ora_control1
agxprapp01:[oracle7.pp_prd.ctrl_files]ora_control1.con
$ define/nolog ora_control2
agxprapp03:[oracle7.pp_prd.ctrl_files]ora_control2.con
$ define/nolog ora_dump agxprapp06:[oracle7.pp_prd.trace]
$ define/nolog ora_archive agxprora01:[oracle7.pp_prd.arch]
$ define/nolog ora_pp_prd_arch 'f$trnlnm("ora_archive")
$ define/nolog ora_sid pp_prd
$ define/nolog ora_params ora_system:init.ora
ora_system:init.ora has the usual things, eg:
control_files = (ora_control1, ora_control2) background_dump_dest = ora_dump
When logging into sqldba, I get this message and can't carry on:
DBA-00314: unable to attach to default host ORA-06400: NETCMN: No default host string specified Trying to connect internal gives me this: ORA-06400: NETCMN: No default host string specified
Error messages and codes manual tells me to "use SET INSTANCE command with valid host specification to set up a default host". What this heck does this mean? I just want to create a database and an instance to go with it. Simple as that.
Help!
Leng.
![]() |
![]() |