如果要生成一个新库,在nt下需要先建立一个service,用oradim命令建立
然后,在dos prompt下执行:
set oracle_sid=newdb
然后再运行运行sqlplus /nolog
connect / as sysdba
然后,在dos prompt下执行:
set oracle_sid=newdb
然后再运行运行sqlplus /nolog
connect / as sysdba
已连接到空闲例程。
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: N^7(4r?*2NJ}ND<~ 'F:\ORACLE\ORA92\DATABASE\INITORA01.ORA'
找不到该文件,是不是需要手工建立一个这样的文件啊,如何建呢.
create database ora01
controlfile reuse
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
maxdatafiles 100
datafile 'f:\oracle\oradata\ora01\system01.dbf' size 325M reuse
undo tablespace undotbs datafile 'f:\oracle\oradata\ora01\undotbs01.dbf' size 200M reuse autoextend on next 5120K maxsize unlimited
default temporary tablespace temptbs01
character set zhs16gbk
noarchivelog
logfile group 1 ('f:\oracle\oradata\ora01\redo01.log') size 100M,
group 2 ('f:\oracle\oradata\ora01\redo02.log') size 100M,
group 3 ('f:\oracle\oradata\ora01\redo03.log') size 100M;