ubuntu环境搭建

1：

Ubuntu系统下运行Eclipse出现找不到jre的问题的解决方法

https://blog.youkuaiyun.com/huangyabin001/article/details/31433331

2:安装oracle 11g xe:

2.1 with lee install oracle, then owner is root

2.2 with lee execute oracle-xe

2.3 8000 1521 sys/system:oracle

Starting Oracle Net Listener...touch: cannot touch '/var/lock/subsys/listener': No such file or directory
/bin/chmod: cannot access '/u01/app/oracle/oradata': No such file or directory
/bin/chmod: cannot access '/u01/app/oracle/diag': No such file or directory
Starting Oracle Database 11g Express Edition instance...touch: cannot touch '/var/lock/subsys/oracle-xe': No such file or directory

Existing database will be erased, hit ctrl-c within 10 secs to cancel
rm: cannot remove ‘/u01/app/oracle/product/11.2.0/xe/dbs’: Permission denied
mkdir: cannot create directory ‘/u01/app/oracle/product/11.2.0/xe/log’: Permission denied
mkdir: cannot create directory ‘/u01/app/oracle/product/11.2.0/xe/dbs’: File exists
mkdir: cannot create directory ‘/u01/app/oracle/product/11.2.0/xe/flash_recovery_area’: Permission denied

SQL*Plus: Release 11.2.0.2.0 Production on Mon May 28 23:22:41 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> SP2-0606: Cannot create SPOOL file "xe_createdb.log"
SQL>

A:./sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

ubuntu 下 sudo apt-get install libaio1

原因，ubuntu64系统内默认装的libaio是32位的。

B：初始化ORACLE

/etc/init.d/oracle-xe configure

B1：

/bin/chown: invalid user: 'oracle:dba'
/bin/chown: invalid user: 'oracle:dba'
/bin/chown: invalid user: 'oracle:dba'
/bin/chown: invalid user: 'oracle:dba'
Starting Oracle Net Listener...touch: cannot touch '/var/lock/subsys/listener': No such file or directory
Done
Configuring database...Done
/bin/chmod: cannot access '/u01/app/oracle/oradata': No such file or directory
/bin/chmod: cannot access '/u01/app/oracle/diag': No such file or directory
/bin/chown: invalid user: 'oracle:dba'
Starting Oracle Database 11g Express Edition instance...touch: cannot touch '/var/lock/subsys/oracle-xe': 
No such file or directory
Done
Installation completed successfully.

解决：
   1：useradd oracle
   2：passwd oracle
   3：groupadd dba
   4：sudo gpasswd -a oracle dba
   5：sudo ./oracle-xe restart
   6：sudo ./oracle-xe status

B2:   

lee@lee:/etc/init.d$ sudo ./oracle-xe restart
[sudo] password for lee:
Shutting down Oracle Database 11g Express Edition instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
touch: cannot touch '/var/lock/subsys/listener': No such file or directory
Starting Oracle Database 11g Express Edition instance.

touch: cannot touch '/var/lock/subsys/oracle-xe': No such file or directory

解决：自己新建subsys目录

B3:查看服务状态

lsnrctl status

B4：lee@lee:/etc/init.d$ sudo ./oracle-xe status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-MAY-2018 23:05:40

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lee)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

重启一下监听：lsnrctl stop、lsnrctl start

https://community.oracle.com/thread/3932295?start=0&tstart=0

B5:ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

less initXE.ora

mkdir flash_recovery_area

B6:ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/u01/app/oracle/product/11.2.0/xe/log]
mkdir log
B7:ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'
无initXE.ora

C：正常步骤：

su - oracle

$ chown oracle:dba log

$ lsnrctl start

$export ORACLE_SID=XE

$ sqlplus / as sysdba
SQL> startup

D:SQL> ed
SP2-0110: Cannot create save file "afiedt.buf"
SQL> 

E:

listener.ora中PLSExtPro 和ExtProc的作用（转）

https://www.cnblogs.com/softidea/p/4885529.html

F:常用命令

https://zhidao.baidu.com/question/494117462436360932.html