AIX5.3+Oracle10g
操作步骤如下:
1.shutdown数据库实例,并将lsnr进程关闭.
2.运行oracle10g安装程序,将oracle10g所有组件选中并安装完毕,整个过程在"Linking"环节报了错,但选择了continue.
3.start监听进程成功。
4.sqlplus / as sysdba 时,报错:TNS-12547: TNS:lost contact我已经尝试过relink all命令了,但问题依旧,请高手指教。
操作步骤如下:
1.shutdown数据库实例,并将lsnr进程关闭.
2.运行oracle10g安装程序,将oracle10g所有组件选中并安装完毕,整个过程在"Linking"环节报了错,但选择了continue.
3.start监听进程成功。
4.sqlplus / as sysdba 时,报错:TNS-12547: TNS:lost contact我已经尝试过relink all命令了,但问题依旧,请高手指教。
解决方案 »
- 请问oracle如何自动清理日志。
- System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本
- oracle的round是否有误?
- imp导入*.dmp发现触发器不见了
- oracle使用Function批量创建同义词时提示权限不足
- 能否设置oracle10 xe 内存占用不超过20m
- 如何清理警告日志和TRC文件(急)
- windows2003(安在C分区中)系统瘫痪,如何恢复ORACLE9i(安在D分区中)
- JDBC中怎样提高数据库的查询速度
- oracle多表查询中如何用rownum分页?
- 有谁能帮忙看看这个存储过程语法哪错了?
- Creat Trigger 问题
------------
可能是机器超负荷了
文档 ID: 381566.1 类型: PROBLEM
上次修订日期: 09-OCT-2006 状态: MODERATED In this Document
Symptoms
Cause
Solution
References--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.4
This problem can occur on any platform.
SymptomsConnect / as sysdba fails with ORA-12547.The OS Oracle environment variables are correctly set (ORACLE_HOME and ORACLE_SID)
You trace the sqlplus using truss
(
truss -aefo sqlplus.txt sqlplus /nolog
connect / as sysdba
)and analyzing the resulting trace file you find inside the actual error, ie ORA-27100:
2654: write(5, " O R A - 0 0 6 0 0 : i".., 81) = 81
2654: write(5, "\n", 1) = 1
2654: write(5, " O R A - 2 7 1 0 0 : s".., 45) = 45CauseLeftovers from previous instances for both shared memory segment and semaphores.
'ipcs -a' should display these left overs.SolutionTo implement the solution, please execute the following steps:
1. Determine which semaphores and shared memory segments belong to the failing instance:
<NOTE 68281.1> - DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS
2. Remove all the problematic shared memory segments from the memory:
ipcrm -m <shared memory id>
3. Remove all the problematic semaphores from the memory:
ipcrm -s <semaphore id>
4. check the $ORACLE_HOME/dbs directory for lk<SID> files and remove them.
5. Restart the database.
这篇文档和你的现象最像,看下解决办法貌似是
Solution
Mount the /proc file system TIP: Click help for a detailed explanation of this page.
书签 转到末尾 主题: ORA-12547 connecting to sqlplus / as sysdba on IBM AIX 5L
文档 ID: 372143.1 类型: PROBLEM
上次修订日期: 30-JAN-2008 状态: PUBLISHED In this Document
Symptoms
Cause
Solution
References--------------------------------------------------------------------------------Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2
AIX5L Based Systems (64-bit)
Oracle 10.2.0.2.0 on IBM AIX 5L
Symptoms
- A sqlplus connection with '/ as sysdba' is producing ORA-12547 or TNS-12547:SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 16 14:10:19 2006 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. ERROR:
ORA-12547 : TNS:lost contact - A truss is producing error 0915-015 Cannot create subject process:truss -fae -o trace.truss sqlplus "/as sysdba"
truss: 0915-015 Cannot create subject process.
wait4all: i: 0, status: 589833, pid: 13729998, created: 0- An Oracle trace file might also be generated with the next messages:*** 2008-01-17 16:09:38.291
kgepop: no error frame to pop to for error 27141
*** 2008-01-17 16:09:38.291
ksedmp: internal or fatal error ORA- 27141 is: Error: ORA-27141
Text: invalid process ID
---------------------------------------------------------------------------
Cause: process operation attempted using invalid process ID Cause
The /proc file system is not mounted.Solution
Mount the /proc file system References
Keywords
SYSDBA; AIX; KGEPOP; SQLPLUS;
参考文章:
http://blog.csdn.net/math_is_OK/archive/2006/03/09/619409.aspx