1. 惭愧:本人最耗时的地方在于未考虑系统和软件的兼容性,见问题4
2. ./runInstaller这一步,需要选择y
- 先安装图形界面vncserver
[root@ylm-100 ~]# yum install tigervnc-server
完毕!
[root@ylm-100 ~]# vncserver
You will require a password to access your desktops.
Password:
Verify:
Would you like to enter a view-only password (y/n)? y
Password:
Verify:
xauth: file /root/.Xauthority does not exist
New 'ylm-100:1 (root)' desktop is ylm-100:1
Creating default startup script /root/.vnc/xstartup
Creating default config /root/.vnc/config
Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/ylm-100:1.log
- root用户安装完vncserver后,执行
[root@ylm-100 samples]$ export DISPLAY=机器ip:1
[root@ylm-100 samples]$ xhost +
access control disabled, clients can connect from any host
3. 安装所需软件包
这个东西,建议大家把Oracle 11.2.0.4.0;Oracle Database 11g Release 2 Installer(步骤一)第10步图中的过滤条件
改为show failed下所有软件包全部down下来,先尝试只下载64位软件包,再检查
#检查
yum list libaio*
#下载(带libaio前缀的64位软件包)
yum install -y libaio*
4. INFO: //usr/lib64/libstdc++.so.5: undefined reference to `memcpy@GLIBC_2.14’
- 该日志内容是由Error in invoking target ‘install’ of makefile '/opt/oracle/product/11.2.0/dbhome_1/ctx/lib/ins_ctx.mk’引起的
- 我这个问题是linux系统和oracle软件的兼容性问题
5. 提示swap size检查失败问题
#查看swap空间,按MB单位
free -m
#1、使用root用户,在/tmp(随意),下执行下面语句
dd if=/dev/zero of=swapfree bs=32k count=65515
#(增加swap大小为bs*count,bs为block,count为数量)
#2、将创建的文件用做交换分区
#执行语句:mkswap swapfree
#3、开启这个交换空间
swapon swapfree
#4、通过free命令查看,交换空间在原来交换空间的基础上增加了2G
#5、在/etc/fstab中加入下面两行,设置此交换分区开机启动
[root@ylm-100 oracle]# vim /etc/fstab
/dec/hdb5 swap swap defaults 0 0
/tmp/swapfree swap swap defaults 0 0
6. root切换oracle后bash-4.2$
长期解决方案:Linux中切换用户变成-bash4.1-$的解决方法
- 根据场景一:拷贝文件内容到指定目录
#粘贴如下内容
[oracle@ylm-100 database]$ vim /home/oracle/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
#粘贴如下内容
[oracle@ylm-100 ~]$ vim /home/oracle/.bashrc
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=
# User specific aliases and functions
7、查看oracle位数
#进入$ORACLE_HOME/bin
#/opt/oracle/product/11.2.0/dbhome_1/bin
[oracle@ylm-100 bin]$ pwd
/opt/oracle/product/11.2.0/dbhome_1/bin
[oracle@ylm-100 bin]$ file sqlplus
sqlplus: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.32, BuildID[sha1]=411e1dbc767af890ff0faa772fab7f87465e6c34, not stripped
8、-bash: lsnrctl: 未找到命令
[oracle@ylm-100 ~]$ lsnrctl status
-bash: lsnrctl: 未找到命令
[oracle@ylm-100 ~]$ vim /opt/oracle/.bash_profile
#核心是执行这一句
[oracle@ylm-100 ~]$ source /opt/oracle/.bash_profile
[oracle@ylm-100 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-JUL-2020 14:48:07
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.92.100)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@ylm-100 ~]$ vim /opt/oracle/.bash_profile
[oracle@ylm-100 ~]$ ps -ef|grep orcal
oracle 17407 15888 0 14:48 pts/0 00:00:00 grep --color=auto orcal
[oracle@ylm-100 ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-JUL-2020 14:49:36
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /opt/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/ylm-100/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.100)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.92.100)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-JUL-2020 14:49:36
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/ylm-100/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.100)(PORT=1521)))
The listener supports no services
The command completed successfully
9、ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> startup
ORACLE instance started.
Total System Global Area 947847168 bytes
Fixed Size 2258920 bytes
Variable Size 306186264 bytes
Database Buffers 633339904 bytes
Redo Buffers 6062080 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> SQL> select * from dual;
DUM
---
X
SQL>
10、plsql连接报ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
- 在/opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora中新增内容
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
11、plsql登录username:sys,connect as:SYSDBA
SQL> show parameters remote_login_passwordfile;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
remote_login_passwordfile string
EXCLUSIVE
SQL> select username from dba_users;
USERNAME
--------------------------------------------------------------------------------
SYS
SYSTEM
OUTLN
MGMT_VIEW
FLOWS_FILES
MDSYS
ORDDATA
ORDSYS
ANONYMOUS
EXFSYS
DBSNMP
USERNAME
--------------------------------------------------------------------------------
WMSYS
SYSMAN
XDB
APPQOSSYS
ORDPLUGINS
APEX_030200
SI_INFORMTN_SCHEMA
DIP
APEX_PUBLIC_USER
ORACLE_OCM
XS$NULL
22 rows selected.