最近安装了oracle XE版学习数据库,sqlplus /nolog登录,
conn / as sysdba时,报Connected to an idle instance (正常);
startup,又报XE edition single instance violation error 错误;
自己百度各种资料(在飞雪流星的博客Linux下Oracle 11G XE 安装笔记找到答案
https://www.cnblogs.com/chenjunjie/p/5590253.html)
发现oracle@ubuntu:~$ 下.profile文件(Ubuntu需要自己新建)里,环境变量ORACLE_HOME以'/'结尾, 同时TNS_ADMIN变量没有设置。
在EX帮助文档里,
You may also want edit your login or profile files so that these environment variables are set properly each time you log in or open a new shell.
For Bourne, Bash, or Korn shell, enter the following line into the .bash_profile
(to log in) or .bashrc
file (to open a new shell):
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.s
Ubuntu 下 oracle账号下我新建 了 .
profile文件,把
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.s内容粘贴过去,加上TNS_ADMIN=$ORACLE_HOME/network/admin,问题解决。