阿里云轻量应用服务器安装oracle遇到的问题

大体步骤参考这两篇文章

https://zhuanlan.zhihu.com/p/22600543
https://yq.aliyun.com/articles/667322

最后最后成功登录时环境变量如下

cat .bash_profile 

PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

不加export 可能会导致这个问题

Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found

---

若是 使用 sqlplus / as sysdba 登录
提示 Enter user-name: 应该是环境变量里的SID没配好

---

listener.ora 和 tnsnames.ora 路径是在/u01/app/oracle/product/11.2.0/network/admin

listener.ora 内容如下

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0)
      (SID_NAME = orcl)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = iZ2ze7sz57humnvio1vwbjZ)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

tnsnames.ora 没有做更改 内容如下

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iZ2ze7sz57humnvio1vwbjZ)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

---

使用 startup 启动oracle 时可能会报错

SQL> startup       
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbs/initorcl.ora'

此时需要将/u01/app/oracle/admin/orcl/pfile 下的init.ora 复制到/u01/app/oracle/product/11.2.0/dbs/下 并改名为initorcl.ora

cp init.ora /u01/app/oracle/product/11.2.0/dbs/initorcl.ora

---

默认主机名也会导致执行 此语句异常

netca -silent -responseFile /tmp/database/response/netca.rsp （该语句用于生成listener.ora 和 tnsnames.ora）

相关错误如下

#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x00007fe6b5594c2d, pid=14041, tid=140629913499456
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_17-b03 mixed mode)
# Problematic frame:
# C  [libclntsh.so.11.1+0x628c2d]  snlinGetAddrInfo+0x1b1
#
# An error report file with more information is saved as hs_err_pid14041.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp

需要更改 的文件是

1. /etc/hostname （设置主机名）
2. /etc/hosts