|
|
硬件配置:
CPU : AMD Atholn 64 3000+
主板 : MIS K8N-NEO4-F (nVidia nForce4)
内存 : DDR400 512M * 2
硬盘 : WD SATA 120G (8M缓存)
显卡 : ELSA nVidia GFroce 6600 (128M/128b)
声卡 : 集成 nVidia AC'97
网卡 : 集成 nVidia 千兆
光驱 : Pioneer DVR-111CH (RW)
系统环境 : SuSE Linux 10.0 (内核版本2.6.13.15, KDE版本3.4.2 Level b, gcc版本4.02)
网络配置 : I P 地址 : 10.0.24.204
子网掩码 : 255.255.255.0
默认网关 : 10.0.24.254
DNS : 192.168.100.100
关闭SuSE的防火墙
主机名 : yanqun 域 : workgroup
软件 : 10201_database_linux32.zip
orarun-1.8-109.5.i586.rpm
参考资料 : SuSE 官方Oracle10g安装指南
详细安装步骤 :
1.安装orarun-1.8-109.5.i586.rpm
# rpm -ivh --nodeps orarun-1.8-109.15.i586.rpm
2.更改新增用户 oracle 的shell为bash,密码为*****
yast操作
3.修改 oracle 环境变量
修改 /etc/profile.d/oracle.sh ,
ORACLE_HOME=$ORACLE_BASE/product/10gR2
ORACLE_SID=mydb
运行 /usr/sbin/rcoracle start
4.解压缩安装文件
#unzip 10201_database_linux32.zip
5.修改安装参数
修改 database/install/oraparam.ini ,在系统需求一行添加 SuSE-10
6.更改安装语言环境,避免中文等出现乱码
更换用户为oracle
export LANG=C
export LC_ALL=C
6.开始安装
运行./runInstaller
安装部分略,安装过程一切顺利,就是在最后配置时出现
ORA-12547:TNS:lost connect
的错误,忽略之,最后也提示安装成功了
尝试登录
oracle@yanqun:~> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 8 09:25:17 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
oraclemydb: error while loading shared libraries: libaio.so.1: cannot open shared object file: No
such file or directory
ERROR:
ORA-12547: TNS:lost contact
出现如上错误
$ORACLE_HOME/network/admin/listener.ora 内容如下
# listener.ora Network Configuration File:
/opt/oracle/product/10gR2/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10gR2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.24.204)(PORT
)
)
$ORACLE_HOME/network/admin/sqlnet.ora 内容如下
# sqlnet.ora Network Configuration File:
/opt/oracle/product/10gR2/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
$ORACLE_HOME/network/admin/tnsnames.ora 内容如下
# tnsnames.ora Network Configuration File:
/opt/oracle/product/10gR2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_MYDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.24.204)(PORT = 1521))
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.24.204)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
oracle@yanqun:~> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-MAR-2006 09:33:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.24.204)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
查阅各种资料均未解决问题,大多针对红帽系列的,恳请大家帮助
谢谢!! |
|