oracle 数据库xe,OracleXE数据库搭建

1.下载安装OracleXE

2.检查oracleXE和TNS服务是否启动 (若TNS无法启动，则检查环境变量的ORACLE_HOME，修改为oracle安装目录)

image.png

image.png

3.配置好listener.ora，tnsnames.ora

image.png

image.png

4.配置好环境变量TSN_ADMIN，NLS_LANG，ORACLE_HOME等

image.png

5.常见问题

(1) ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

解决：startup

(2)执行startup时又报错：

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

原因：dbs目录下缺少spfileXE.ora

解决：create spfile='D:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora' FROM pfile='D:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora';

参考：http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/12/14/1026.htm

(3)处理完以上两部后，执行SQL> startup 又有报错：ORA-00205: ?????????, ??????, ???????

百度为文件损坏：参考http://blog.itpub.net/29876893/viewspace-1623346/

未解决，目前已经启动示例，问题遗留

image.png