装上orcle 10g,用了几天之后,sqlplus启动后,输入用户名和密码后,提示:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist检查了服务,都是开启了的。也重启了的。但是在运行里面输入 sqpplus,输入用户名和密码后却能进入,但非得要以system/password as sysdba 才能进入。请问ora-27101 shared memory realm does not exist如何解决? 到底是哪儿出问题了呢?
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist检查了服务,都是开启了的。也重启了的。但是在运行里面输入 sqpplus,输入用户名和密码后却能进入,但非得要以system/password as sysdba 才能进入。请问ora-27101 shared memory realm does not exist如何解决? 到底是哪儿出问题了呢?
解决方案 »
- 新手求教
- pl/sql中,如何导出压缩表的表结构?
- 这个应该怎么写 select max(3,4,5,6) from dual
- 超级用户SYSTEM修改用户scott的密码?
- 表的字段名称如何与字段的值关联?
- 请问如何在SQL中使用多条件的XPath表达式
- 使用em管理数据库还有什么前提吗
- 从oracle 主页上下载的oracle 9i企业版是几用户的,有何限制
- 【求助】8.0.5 用Oracle Database Assistant建立了数据库 下一步该做什么?
- 把一条数据写成两条、各位大神求帮助
- 请教一个报名系统的数据库设计
- 求助:reporting services有关数据源类型为oracle的exec问题
sqlplus /nolog
conn / as sysdba
startup force
exit
sql>connn as sysdba
sql>startup
Successful open of redo thread 1
Mon Oct 20 18:31:29 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Oct 20 18:31:29 2008
SMON: enabling cache recovery
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 02:16:34 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:440M/1023M, PG:1740M/2462M, VA:1945M/2047M
Wed Oct 22 02:16:34 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 02:21:19 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:410M/1023M, PG:1729M/2462M, VA:1945M/2047M
Wed Oct 22 02:21:19 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 02:22:38 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:408M/1023M, PG:1708M/2462M, VA:1945M/2047M
Wed Oct 22 02:22:38 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 12:14:14 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:643M/1023M, PG:2075M/2462M, VA:1945M/2047M
Wed Oct 22 12:14:14 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 12:29:32 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:554M/1023M, PG:1851M/2462M, VA:1945M/2047M
Wed Oct 22 12:29:32 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Wed Oct 22 14:02:30 2008
Starting ORACLE instance (force)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Dump file d:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Wed Oct 22 22:02:23 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:597M/1023M, PG:2022M/2462M, VA:1945M/2047M
Wed Oct 22 22:02:23 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Wed Oct 22 22:07:03 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0