摘要： A.List the prerequistites necessarey for database creation 1)确定数据库类型(OLTP or OLAP) 2)规划数据库架构, 如datafile, logfile 等存放磁盘, tablespace, 性能安全 (可以参考Oracle 建议的OFA:Optimal Felxible Arch) 用DBCA创建后的目录结构如下: orad... 阅读全文

摘要： conn / as sysdba 因为我们已经通过密码验证进入了操作系统这一层,这样的话,oracle就默认为你有了起动和关闭DB的权限. shutdown -> nomount(instance started) -> mount(control file open) -> open ----------------------------------- startup nomount p... 阅读全文

摘要： Do not use the pfile init.ora as it is to old for us. we can copy from expert. if we use the dbca to setup the db, it will create one pfile ans spfile automaticlly. -----------------------------------... 阅读全文