oracle apex 升级安装及卸载

ORACLE APEX的升级安装及卸载

一、安装

1.原有APEX目录重命名 cd $ORACLE_HOME mv apex apex.bak

2.下载apex_5.0.zip 到/stage 目录 cd /stage

unzip apex_5.0.zip

cp -r apex $ORACLE_HOME

3.安装APEX

cd $ORACLE_HOME/apex sqlplus / as sysdba

@apexins.sql SYSAUX SYSAUX TEMP /i/

4.设置port并查看。 SQL> begin

2 dbms_xdb.setHTTPPort(8080); 3 commit; 4 end; 5 /

SQL> select dbms_xdb.getHTTPPort from dual; 8080

5.创建用户ADMIN并设置密码： SQL> @apxchpwd.sql

6.启用匿名帐号。

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

7.修改访问权限： SQL> begin

2 DBMS_XDB.SETLISTENERLOCALACCESS (FALSE); 3 end; 4 /

8.登录

http://localhost:8080/apex/apex_admin

二、卸载

sqlplus / as sysdba

1.删除用户

drop user FLOWS_FILES cascade; drop user APEX_PUBLIC_USER; drop user HTMLDB_PUBLIC_USER; 2.删除APEX用户及数据

drop user FLOWS_010500 cascade; drop user FLOWS_010600 cascade; drop user FLOWS_020000 cascade; drop user FLOWS_020100 cascade; drop user FLOWS_020200 cascade; drop user FLOWS_030000 cascade; drop user FLOWS_030100 cascade; drop user APEX_030200 cascade; drop user APEX_040000 cascade; drop user APEX_040100 cascade; drop user APEX_040200 cascade; drop user APEX_050000 cascade; 3.执行以下语句所生成的结果集

select 'drop public synonym ' || synonym_name || CHR(10) || ';' from sys.dba_synonyms where table_owner in ('FLOWS_010500','FLOWS_010600','FLOWS_020000','FLOWS_020100','FLOWS_020200','FLOWS_030000','FLOWS_030100','APEX_030200','APEX_040000','APEX_040100','APEX_040200','APEX_050000','FLOWS_FILES');

4.验证

select synonym_name from sys.dba_synonyms where owner = 'FLOWS_FILES';