oracle安装出现01078,安装oracle 11g 遇到的问题ORA-01078 ORA-01034

因为服务器挂载了磁盘阵列,磁盘阵列分了F,G两个盘 我将Oracle装在了F盘,在安装到最后一步的时候,出现了ora-01038 lrm-00109 链接运行:connect /as sysdba 在sqlplus中运行startup命令报错 ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'F:\app\Administrator\product\11.2.0\dbhome_1\dbs\INITorcl.ora' 在F:\app\Administrator\product\11.2.0\dbhome_1\database下果然没有INITorcl.ora,于是我参考我自己的笔记本,拷贝了一份过去,修改相应链接和ip INITorcl.ora文件内容如下 orcl.__db_cache_size=1442840576 orcl.__java_pool_size=16777216 orcl.__large_pool_size=16777216 orcl.__oracle_base='F:\app\Administrator'#ORACLE_BASE set from environment orcl.__pga_aggregate_target=1308622848 orcl.__sga_target=1946157056 orcl.__shared_io_pool_size=0 orcl.__shared_pool_size=436207616 orcl.__streams_pool_size=0 *.audit_file_dest='F:\app\Administrator\admin\orcl\adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='F:\app\Administrator\oradata\orcl\control01.ctl','F:\app\Administrator\flash_recovery_area\orcl\control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='orcl' *.db_recovery_file_dest='F:\app\Administrator\flash_recovery_area' *.db_recovery_file_dest_size=4102029312 *.diagnostic_dest='F:\app\Administrator' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' *.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=192.168.2.199)(Port=1521)))' (这个ip是服务器的ip) *.memory_target=3251634176 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1' 这个情况下运行startup命令,会报 ora-00119 ora-00130 是因为监听的host不对 这时修改监听文件: F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora 文件内容如下: # listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521))    【host是服务器IP】     )   ) ADR_BASE_LISTENER = F:\app\Administrator 再运行就不会报错了: SQL> startup ORACLE 例程已经启动。 Total System Global Area 3240239104 bytes Fixed Size                  2180104 bytes Variable Size            1778387960 bytes Database Buffers         1442840576 bytes Redo Buffers               16830464 bytes 数据库装载完毕。 数据库已经打开。 SQL> 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc tion With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值