Как удалить apex oracle
Oracle's recommendation is to share the core of APEX between pluggable databases, by installing it in the CDB. This is done by default in 12cR1 multitenant installations. Despite the initial enthusiasm, this approach is impractical and in my opinion APEX should be removed from CDB from the outset. This decision is very important because the current documentation states the following.
"Oracle does not support uninstalling Application Express from the root container, or reinstalling Application Express into the root container, once any PDBs have been configured. This may invalidate or completely remove the meta data associated with the existing Application Express installation."
This article describes the process of uninstalling APEX from the CDB, leaving you free to install different versions of APEX into each PDB if required in future.
If you are providing a large APEX real estate, you may find the shared APEX method useful, but I think for most users it will probably cause more problems than it fixes.
12cR2 Update
From Oracle Database 12c Release 2 (12.2) onward APEX is not installed by default, so you no longer need to worry about uninstalling APEX before creating PDBs. The software is still shipped with the database ($ORACLE_HOME/apex), but not installed. In Oracle 12.2 you should always do the following.
- Download the latest version of APEX (here), rather than using the version shipped with the database.
- Install APEX locally in a PDB, rather than in the root container. You should not install APEX in the root container in Oracle 12.2.
Uninstall APEX from the Container Database (CDB)
Remember, you should only perform this on a CDB with no PDBs, so either drop existing PDBs, or unplug the PDBs and move them to another container before starting.
Navigate to the "$ORACLE_HOME/apex" directory and connect to the root container.
If you are using the default APEX shipped with the database run the "apxremov_con.sql" script to remove APEX from the CDB. If you are using a later version of APEX you should use the "apxremov.sql" script.
Install APEX into a Pluggable Database (PDB)
With APEX removed from the CDB, we are free to perform full APEX installations in each PDB. The installation process is almost the same as for previous database versions, but you must remember to connect to the PDB to perform the installation. The example below is a summary based on a more detailed APEX installation article here. This example does not cover all APEX installation options!
Connect to the root container, create a new pluggable database and add a tablespace for the APEX components.
Change directory to the directory holding the unzipped APEX software.
All actions from this point are performed within the PDB. I've added a new connection for each command as a reminder, but this is not necessary. All the following actions can be performed in the same session.
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL. Remember, you must connect to the specific PDB, not the CDB.
Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
Make sure the APEX_PUBLIC_USER account is unlocked.
If you are planning to use the Embedded PL/SQL Gateway (EPG), you will have to set it up, as described here.
The installation section should be followed for new installations and upgrades. Since the release of APEX 18.x, each release requires a full installation, so there is no concept of patching anymore. This simplifies the approach greatly.
In previous versions an upgrade was required when a release affected the first two numbers of the version (4.2 to 5.0 or 5.1 to 18.1), but if the first two numbers of the version were not affected (5.1.3 to 5.1.4) you had to download and apply a patch, rather than do the full installation. This is no longer the case.
If you are using the multitenant architecture in Oracle 12cR1, you should read this article before you continue.
Setup
Download the APEX software.
Unzip the software either on your client PC if you intend to install it from there using the SQL*Plus client on your PC, or on the database server if you intend to install it from there. The latter will be more efficient as you will reduce the network traffic between the SQL*Plus client and the database server.
Create a new tablespace to act as the default tablespace for APEX.
Installation
Change directory to the directory holding the unzipped APEX software.
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.
If you are upgrading, you've finished the DB upgrade at this point. You only need to run subsequent steps for new installations. You will need to redeploy the image files to your app server. If you are using ORDS, it's a good idea to run an ORDS validate to make sure the APEX hasn't affected your ORDS installation.
Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.
If you want to add the user silently, you could run the following code, specifying the required password and email.
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
If you want to add these users silently, you can specify the passwords as parameters to the script.
Now you need to decide which gateway to use to access APEX. The Oracle recommendation is ORDS.
Oracle REST Data Services (ORDS) Configuration
If you want to use Oracle REST Data Services (ORDS) to front APEX, you can follow the instructions here.
Embedded PL/SQL Gateway (EPG) Configuration
If you want to use the Embedded PL/SQL Gateway (EPG) to front APEX, you can follow the instructions here. This is used for both the first installation and upgrades.
Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a parameter.
Unlock the ANONYMOUS account.
Check the port setting for XML DB Protocol Server.
If it is set to "0", you will need to set it to a non-zero value to enable it.
APEX should now be available from a URL like "http://machine:port/apex".
Change the password and unlock the APEX_PUBLIC_USER account. This will be used for any Database Access Descriptors (DADs).
If you don't want the password to expire you will need to create a new profile with password expiration disabled and assign it to the user.
Create a DAD in the OHS:
- Log into EM (http://server:port/em)
- From the tree select "Farm_DomainName > Web Tier > ohs1"
- On the resulting page select "Oracle HTTP Server > Administration > Advanced Configuration"
- From the dropdown list slect "dads.conf" and click the "Go" button.
- Edit the "dads.conf" file, adding an entry like that shown below, then click the "Apply" button.
- Select the "Oracle HTTP Server > Control > Restart" option.
- Click the resulting "Restart" button.
- Once restarted, click the "Close" button.
Make them available from the "/i/" alias by adding the following alias to the virtual host defined in the "ssl.conf" or "httpd.conf" file in the "$FR_INST/config/OHS/ohs1" directory.
APEX should now be available from a URL like "http://machine:port/apex".
Network ACLs
If your APEX installation needs to contact other servers on the network, you will need to create the appropriate ACLs to allow account to the network services. This is discussed here.
Oracle APEX (Application Express) clean up in Oracle Database 11.2-12.2 is fairly simple and straight forward. With the upgrade to Oracle Database 12.2.0.1 Oracle APEX does not get upgraded automatically anymore. If necessary you should upgrade Oracle APEX upfront of afterwards. But please do keep an eye on the APEX certification with Oracle Database 12.2.0.1 to avoid any issues:
Oracle APEX (Application Express) Clean Up in Oracle Database 11.2-12.2
Before you start removing anything from your database please make sure you read my introductory blog post about how to Remove and Clean Up Components from Oracle 11.2 – 12.2 . You’ll find links to monitor proper component removal there as well as in the SQL Scripts Repository on this blog.
This blog post does not recommend to remove APEX from an Oracle Database. I by myself use Oracle APEX quite often, there’s a huge developer community out there – and APEX is one of the coolest things Oracle ever did in addition to the database.
APEX removal is non-invasive
But there may be situations when you have to remove APEX. Maybe it could have been accidentally installed into the CDB$ROOT of a Multitenant database: Why you should remove APEX from CDB$ROOT.
Removing APEX does remove all APEX applications as well. Export existing APEX applications upfront.
Oracle Database 11.2.0.4
In Oracle Database 11.2.0.4 APEX gets installed by default as version 3.2.1.00.12. The removal procedure is documented in MOS Note:558340.1 – How to Uninstall Oracle HTML DB / Application Express from a 10G/11G Database.
That’s very simply and straight forward. And it works. The leftover package HTMLDB_SYSTEM is an artifact from older versions of APEX and should be removed (see MOS Note:1231863.1).
Oracle Database 12.1.0.2
In Oracle Database 12.1.0.2 the APEX removal instructions are in the Application Express Installation Guide. The script for an APEX removal remains the same, regardless of executed in a non-CDB or CDB. APEX gets installed by default in version 4.2.5.00.08.
Finally there may be two leftover synonyms APEX_SPATIAL and APEX_PKG_APP_INSTALL_LOGIN requiring clean up.
Oracle Database 12.2.0.1
The default APEX version in Oracle Database 12.2.0.1 is APEX 5.0.4.00.12. Again, the removal scripts is the same for non-CDBs and CDBs. The documentation describes the process only for CDBs but fortunately there are no leftovers for non-CDBs.
Non-CDB
In this case the script will utilized catcon.pl . Therefore I’m adding perl to the PATH variable.
Unfortunately there are leftovers after this process: the public synonym APEX_SPATIAL in all containers except CDB$ROOT and PDB$SEED will exist if Oracle Spatial is present. The removal must be done with catcon.pl .
- Create a /home/oracle/clean_apex.sql script containing:
- Execute /home/oracle/clean_apex.sql script with catcon.pl :
If you use the graphical dbca utility to create a new Oracle 11gR2 database, you will have noticed that this includes Application Express by default, and there is no way to deselect that option (to my knowledge) during the installation process. Here I will explain how you can remove APEX from the 11g database after the installation.
First, you need to figure out what version of APEX is installed. You can do this by looking at the name of the APEX_xxxxxx schema, or by executing the following query (with user SYS as SYSDBA):
SQL> select version from dba_registry where comp_id=’APEX’;
VERSION
——————————————————————————–
3.2.1.00.12
Now you need to download the installation files for this version of APEX, copy the zip file to your server and unzip it to a temp folder (for example: /tmp). Make sure the user which runs your Oracle software (by default this is user “oracle”) has access to the software. Note: you need about 750MB of free disk space for the zip file and the unzipped content…
Next, change to the directory “apex” and run the apexremov.sql script with user SYS as SYSDBA:
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 6 14:07:26 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> @apxremov.sql
When the script executed without errors, you should see the following message at the end:
PL/SQL procedure successfully completed.
…Application Express Removed
SQL>
You can now query dba_registry again, and you will notice that APEX has been uninstalled!
APEX version 3.2.1 is no longer available from the Oracle download archives, but the steps outlined here are the same for later versions of APEX. See for example here for APEX 19.2.
Надоесть может абсолютно любая игра, в том числе Apex. Между тем жесткий диск – не резиновый. Чтобы поставить новую игрушку, придется деинсталлировать старую. Рассказываем, как полностью удалить Apex Legends с компьютера.
Три способа удаления
Есть три способа удалить Apex Legends с компьютера:
- Стандартный – с помощью инструментов системы;
- Через Steam ;
- Через Origin (если игра установлена оттуда);
Разберем каждый из них.
Стандартный способ
Сейчас в Windows 10 есть два раздела с настройками – новый, появившийся только в « десятке », и классическая Панель управления. Игру удалить можно и оттуда, и оттуда.
Чтобы деинсталлировать Apex из новых настроек, делаем следующее:
После этого запустится деинсталляция. Нам нужно всего лишь дождаться окончания процедуры.
Панель управления по умолчанию в « десятке » скрыта. Чтобы найти ее, вызываем меню поиска и вводим ключевое слово. То есть название приложения – Панель управления. В списке результатов кликаем на иконку панели.
В ней находим значок раздела « Программы и компоненты ».
Переходим в раздел, находим там Apex Legends и кликаем по ней.
После этого система запросит подтверждение на удаление. Даем его и ждем окончания процедуры.
Steam
Любую игру, скачанную или купленную в Steam, можно удалить через клиент магазина. Правда, не все знают об этом, потому что удаление не так очевидно.
Apex Legends в этом плане не исключение. Чтобы деинсталлировать игру через Steam, делаем следующее:
В отличие от деинсталляции через настройки или Панель управление, в этом случае удалятся не только файлы игры, но и абсолютно вся информация с аккаунта. Восстановить ее в дальнейшем уже будет нельзя. Так что если решили использовать именно этот способ удаления, хорошенько подумайте. Особенно если до этого хорошо прокачали профиль или задонатили в него денег.
Origin
Этот способ подойдет тем, кто скачал игру через официальный магазин Electronic Arts. В целом алгоритм удаления очень напоминает стимовский. Потребуется сделать следующее:
- Запустить Origin;
- Перейти в раздел « Библиотека »;
- Выбрать Apex Legends;
- Кликнуть по игре правой кнопкой мыши;
- В открывшемся меню выбрать пункт « Удалить ».
После этого на экране появится диалоговое окно с запросом на подтверждение удаления. Нужно дать его. Начнется процедура деинсталляции.
Сторонние программы
Удаление возможно и с помощью стороннего программного обеспечения. Например популярной утилиты для очистки системы CCleaner. Деинсталляция производится из подраздела « Удаление программ » на вкладке « Сервис ».
Плюс использования CCleaner в том, что в ходе процедуры он подчищает « мусор », оставшийся после игры. Например, ненужные строчки в реестре или скрытые файлы в пользовательской папке. При использовании других описанных выше способов этого не происходит.
Итоги
Удалить Apex Legends с компьютера можно несколькими способами: стандартными средствами Windows, через Steam или Origin, с помощью стороннего программного обеспечения. Разница между ними минимальна, поэтому можно выбрать тот, который вам показался проще. Единственное, о чем нужно помнить – при удалении через Steam исчезают все игровые достижения.
Читайте также: