oracle apex 升级安装及卸载.docVIP

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;