1.登录oracle用户,登录dba,显示乱码???[root@redhat4 ~]# su - oracle[oracle@redhat4 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 22 18:27:40 2014Copyright (c) 1982, 2005, Oracle. &nb
方法一:1.windows 下查看注册表开始 输入regedit 查看HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\ORACLE_SID就是 2 linux或者unix下可以echo $ORACLE_SID 注意:ORACLE_SID要大写方法二:在sql命令下可以查看连接之后查询: &nb
故障现象:ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/array/ora/oracle/product/11.2.0/db_1/dbs/initorc1.ora' 原理:在oracle9i和oracle10g中,数据库默认将使用spfile启动数据库,
故障:ORA-00845: MEMORY_TARGET not supported on this system Oracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可能会报错: SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号