oracle客户端无法连接服务器?怎么办

[复制链接]
查看11 | 回复9 | 2009-3-10 21:19:05 | 显示全部楼层 |阅读模式
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 15:06:07 2007
Copyright (c) 1982, 2005, Oracle.All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
我用普通帐户登陆不进去报上面的错
[oracle@rdfz oracle]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 15:07:41 2007
Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
ORA-03113: end-of-file on communication channel
用管理员去启动实例就报这个错,我根据Fenng老大以前的帖子,去查看了我的linux内核发现没错,防火墙什么的也没事,主要是昨天我还能正常使用,今天就不成了。。老大们帮忙看下 谢谢
我的是10G linux系统
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
实例应该起来了,使用以下步骤单独执行
startup nomount
alter database mount;
alter database open;
估计会在mount这个阶段报错误,感觉这种错误应该是上次关闭数据库的时候引起的,看一下alert文件,找找可能发现些什么。
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
最初由 nw5452 发布
[B]SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 15:06:07 2007
Copyright (c) 1982, 2005, Oracle.All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
我用普通帐户登陆不进去报上面的错
[oracle@rdfz oracle]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 15:07:41 2007
Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
ORA-03113: end-of-file on communication channel
用管理员去启动实例就报这个错,我根据Fenng老大以前的帖子,去查看了我的linux内核发现没错,防火墙什么的也没事,主要是昨天我还能正常使用,今天就不成了。。老大们帮忙看下 谢谢
我的是10G linux系统 [/B]

試試這個
oracle@rdfz oracle]$ sqlplus /nolog

SQL> connsys/sys@test as sysdba;
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1136
Fri Oct 12 14:52:25 2007
starting up 1 shared server(s) ...
Fri Oct 12 14:52:28 2007
Errors in file /oracle/admin/g12adb/bdump/g12adb_pmon_1116.trc:
ORA-07445: exception encountered: core dump [pdy8M39_Size_Proc_Arguments()+5647953] [SIGSEGV] [Address not mapped to object] [0xFFFFFFBB] [] []
Fri Oct 12 14:52:32 2007
Errors in file /oracle/admin/g12adb/udump/g12adb_ora_1141.trc:
ORA-07445: exception encountered: core dump [kkeSetDefaultNdvForJoin()+13557160] [SIGSEGV] [Address not mapped to object] [0xBE372DE0] [] []
Fri Oct 12 14:53:28 2007
PSP0: terminating instance due to error 472
Instance terminated by PSP0, pid = 1118
Fri Oct 12 14:58:36 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes
= 150
__shared_pool_size = 285212672
__large_pool_size= 16777216
__java_pool_size = 16777216
__streams_pool_size= 0
sga_target
= 1224736768
control_files
= /oracle/oradata/g12adb/control01.ctl, /oracle/oradata/g12adb/control02.ctl, /oracle/oradata/g12adb/control03.ctl
db_block_size
= 16384
__db_cache_size
= 889192448
compatible
= 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest= /oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=g12adbXDB)
job_queue_processes= 10
background_dump_dest = /oracle/admin/g12adb/bdump
user_dump_dest = /oracle/admin/g12adb/udump
core_dump_dest = /oracle/admin/g12adb/cdump
audit_file_dest
= /oracle/admin/g12adb/adump
db_name
= g12adb
open_cursors
= 300
pga_aggregate_target = 407896064
PMON started with pid=2, OS id=1218
PSP0 started with pid=3, OS id=1220
MMAN started with pid=4, OS id=1222
DBW0 started with pid=5, OS id=1224
LGWR started with pid=6, OS id=1226
CKPT started with pid=7, OS id=1228
SMON started with pid=8, OS id=1230
RECO started with pid=9, OS id=1232
CJQ0 started with pid=10, OS id=1234
MMON started with pid=11, OS id=1236
Fri Oct 12 14:58:37 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1238
Fri Oct 12 14:58:37 2007
starting up 1 shared server(s) ...
Fri Oct 12 14:58:40 2007
Errors in file /oracle/admin/g12adb/bdump/g12adb_pmon_1218.trc:
ORA-07445: exception encountered: core dump [pdy8M39_Size_Proc_Arguments()+5647953] [SIGSEGV] [Address not mapped to object] [0xFFFFFFBB] [] []
Fri Oct 12 14:58:43 2007
Errors in file /oracle/admin/g12adb/udump/g12adb_ora_1243.trc:
ORA-07445: exception encountered: core dump [kkeSetDefaultNdvForJoin()+13557160] [SIGSEGV] [Address not mapped to object] [0xBE372DE0] [] []
Fri Oct 12 14:59:39 2007
PSP0: terminating instance due to error 472
Instance terminated by PSP0, pid = 1220
Fri Oct 12 15:07:54 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes
= 150
__shared_pool_size = 285212672
__large_pool_size= 16777216
__java_pool_size = 16777216
__streams_pool_size= 0
sga_target
= 1224736768
control_files
= /oracle/oradata/g12adb/control01.ctl, /oracle/oradata/g12adb/control02.ctl, /oracle/oradata/g12adb/control03.ctl
db_block_size
= 16384
__db_cache_size
= 889192448
compatible
= 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest= /oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=g12adbXDB)
job_queue_processes= 10
background_dump_dest = /oracle/admin/g12adb/bdump
user_dump_dest = /oracle/admin/g12adb/udump
core_dump_dest = /oracle/admin/g12adb/cdump
audit_file_dest
= /oracle/admin/g12adb/adump
db_name
= g12adb
open_cursors
= 300
pga_aggregate_target = 407896064
PMON started with pid=2, OS id=1293
PSP0 started with pid=3, OS id=1295
MMAN started with pid=4, OS id=1297
DBW0 started with pid=5, OS id=1299
LGWR started with pid=6, OS id=1301
CKPT started with pid=7, OS id=1303
SMON started with pid=8, OS id=1305
RECO started with pid=9, OS id=1307
CJQ0 started with pid=10, OS id=1309
MMON started with pid=11, OS id=1311
Fri Oct 12 15:07:55 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1313
Fri Oct 12 15:07:55 2007
starting up 1 shared server(s) ...
Fri Oct 12 15:07:58 2007
Errors in file /oracle/admin/g12adb/bdump/g12adb_pmon_1293.trc:
ORA-07445: exception encountered: core dump [pdy8M39_Size_Proc_Arguments()+5647953] [SIGSEGV] [Address not mapped to object] [0xFFFFFFBB] [] []
Fri Oct 12 15:08:02 2007
Errors in file /oracle/admin/g12adb/udump/g12adb_ora_1318.trc:
ORA-07445: exception encountered: core dump [kkeSetDefaultNdvForJoin()+13557160] [SIGSEGV] [Address not mapped to object] [0xBE372DE0] [] []
Fri Oct 12 15:08:57 2007
PSP0: terminating instance due to error 472
Instance terminated by PSP0, pid = 1295
我是新手,所以还看不太懂,我alert贴出来了,大家帮忙看下 谢谢
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
退出sqlplus,重新登陆,
conn / as sysdba
startup
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
最初由 棉花糖ONE 发布
[B]退出sqlplus,重新登陆,
conn / as sysdba
startup [/B]


但是有時很奇怪:
conn / as sysdba 不能進
conn sys/sys@testas sysdba能進
不知什么原因?
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
最初由 棉花糖ONE 发布
[B]退出sqlplus,重新登陆,
conn / as sysdba
startup [/B]

SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
ORA-03113: end-of-file on communication channel

还是这错
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
最初由 hbwp2008 发布
[B]
試試這個
oracle@rdfz oracle]$ sqlplus /nolog

SQL> connsys/sys@test as sysdba; [/B]

您说的这个我也试了,也进不去。。。
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
晕,我把oracle所在的服务器重起了一下,就能进去了,这是为什么吗?老大们有这方面的经验吗?能给小弟说说吗?
回复

使用道具 举报

千问 | 2009-3-10 21:19:05 | 显示全部楼层
能说说吗?或是有什么经验传授下 谢谢
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行