How to uninstall / completely remove Oracle 11g

Uninstall all Oracle components using the Oracle Universal Installer (OUI).

Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products.

Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty obvious which ones relate to Oracle.

Reboot your machine.

Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.

Delete the "C:\Program Files\Oracle" directory.

Empty the contents of your "C:\temp" directory.

Empty your recycle bin.

Calling additional attention to some great comments that were left here:

Be careful when following anything listed here (above or below), as doing so may remove or damage any other Oracle-installed products.

For 64-bit Windows (x64), you need also to delete the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE key from the registry.

Clean-up by removing any related shortcuts that were installed to the Start Menu.

Clean-up environment variables:

Consider removing %ORACLE_HOME%.

Remove any paths no longer needed from %PATH%.

This set of instructions happens to match an almost identical process that I had reverse-engineered myself over the years after a few messed-up Oracle installs, and has almost always met the need.

Note that even if the OUI is no longer available or doesn't work, simply following the remaining steps should still be sufficient.

https://stackoverflow.com/questions/8450726/how-to-uninstall-completely-remove-oracle-11g-client

How to exclude tables during import using impdp

 

How to exclude tables during import using impdp 

grant dba to labserp identified by labserp;

CREATE TABLESPACE LABSERP_TS
   DATAFILE 'LABSERP_TS.dbf'
    SIZE 100M
    REUSE
    AUTOEXTEND ON NEXT 10M ;

CREATE OR REPLACE DIRECTORY test_dir1 AS 'E:\personal\';

GRANT READ, WRITE ON DIRECTORY test_dir1 TO labserp;

impdp labserp/labserp  exclude=TABLE:\"IN (\'DO_AUDIT_DETAIL\', \'PR_DAY_WISE_ATTENDENCE_040720\', \'PR_DAY_WISE_ATTENDENCE_070720\', \'PR_DAY_WISE_ATTENDENCE_090720\', \'PR_DAY_WISE_ATTENDENCE_07073PM\', \'AC_DATA_LOG_BK\')\" directory=TEST_DIR1 dumpfile=expdp_28-07-Tue_23.00_PM.dmp logfile=impdpEMP_DEPT.log

Oracle EBS Vision Instance Installation on VirtualBox

A. 

Download and install VirtualBox There are possibilities of different versions based on your Operating System. Here we worked with VirtualBox-6.1.14-140239-Win

B. Download EBS Software

On the  Oracle Software Delivery Cloud page: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

1. Login with your credentials

2. Search by Oracle VM Virtual Appliance for Oracle E-Business Suite

3. Select Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6

4. Continue in the Download Queue

5. Accept Licence & Download

6. A software for download will be downloaded name eg.Oracle_SSN_DLM_12130645.exe

7. Unzip All the files by any utility like winzip or 7zip etc.

8. Merge the unzip files with command prompt in the following way 

type Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.01 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.02 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.03 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.04 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.05 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.06 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.07 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.08 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.09 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.10 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.11 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.12 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.13 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.14 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.15 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.16 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.17 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

It takes at least 1 to 2 hours or even more based on your Processor/Memory to get the merged file.

9. Import Appliance

At this stage, you should have at least 400 gigabytes or the process aborts. You may need to delete the zip files to make room for the import.

10. 

Adjust RAM memory keep 30% for Main CPU. Also adjust Graphics controller to VMSVGA 

For Networking, you can attach Adapter as:

Bridged Adapter (the default setting)

NAT or Host-Only Adapter.

11. Start the VM

      Set the IP when it is prompted 

12. Login & Password reset

     

13. EBS demo Application install

At a certain point during the post-install process you will be prompted to:

select whether to add start or stop of the database and application tier processes to the OS boot script.

Enter VISION to configure the Vision Demo instance.

14. Step – 5 Access to E-Business suite VISION.

To access the EBS Application from your website you will have to make minor changes in the

Windows host file by:

Getting the IP address of the VM using ifconfig -a on the terminal.

Edit the file on your Windows, add a line in c:\windows\system32\drivers\etc\hosts

(You may have to temporarily change permissions if you do have Administrator privileges)

<IP address> apps.example.com apps

Use an SSH client, like Putty to ssh to the file system and explore the operating system installation.

To Start the application

/u01/install/APPS/fs1/inst/apps/EBSDB_apps/admin/scripts

./adstrtal.sh apps/apps

Use http://apps.example.com:8000 to access EBS Application

The default passwords are:

SYSADMIN/sysadmin

demo/demo

apps/apps

sys/manager

system/manager

WebLogic/welcome1

All these passwords could be changed but you can keep them as they are until you get used to the Apps.

But if you feel the need to change, connect to the VM through SSH as oracle:

Change directory to:  /u01/install/APPS/scripts

You will find a script to change the password for Sysadmin and for the Demo users.

[oracle@apps scripts]$ ./enableSYSADMIN.sh

[oracle@apps scripts]$ ./enableDEMOusers.sh

 

If you want to access the db 

export ORACLE_BASE=/u01/install/APPS

export ORACLE_HOME=/u01/install/APPS/12.1.0

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=EBSDB

use sys as sysdba and enter the EBSDB schema. 

  

Change page content based on changing select list

https://stackoverflow.com/questions/32708157/oracle-apex-change-page-content-based-on-changing-select-list

Oracle Application Server on Windows

Installation Steps:

1. First create a folder named app_server in any directory
2. go to the software to install and double click install.exe
3. give proper path at the fields
   app_server
   g:\app_server (Path)
4. follow the step by step wizard

administrator username : ias_admin
instance name : ias_admin
password assad123


5. You have to 'Retry' at any stage like OC4J instance configuration assistant
6.installation complete

Configuration

1.C:\app_server\forms\java\oracle\forms\registry\Registry.dat
app.ui.lovButtons=true
app.ui.requiredFieldVA=true


2. you can copy required files from
https://drive.google.com/folderview?id=0B9MhlLcy4ecVTkJCbWxlcmtoQkE&usp=sharing
C:\app_server\forms
C:\app_server\forms\server
C:\app_server\forms\java


3. C:\app_server\forms\server\formsweb.cfg

[HRD]
form=D:\HRD\FORMS\hrm_project.fmx
userId=hrd/hrd@orcl
workingDirectory=D:\HRD
pageTitle=Lumineux ERP.
baseHTMLjinitiator=webutiljpi.htm
imageBase=Codebase
archive=frmall.jar,fjutilities.jar,rolloverbutton.jar,images.jar,getclientinfo.jar,frm

webutil.jar,jacob.jar,banner.jar,DualPDFPrint.jar
#archive_jini=frmall_jinit.jar,fjutilities.jar,rolloverbutton.jar,images.jar,getclient

info.jar,frmwebutil.jar,jacob.jar
colorScheme=blue
otherparams=useSDI=yes
separateFrame=true
logo=none
background=none
splashScreen=none
#width="style="width: expression(document.body.clientWidth/2+'px');""
#height="style="height: expression(document.body.clientHeight+'px');""
# Parameters related to webutil
WebUtilArchive=frmwebutil.jar,jacob.jar,banner.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
# Parameters related to show progress of jar files loader
java_showprogress=true
pageTitle=Lumineux ERP.
java_preloadjars=frmall_jinit.jar,frmwebutil.jar,jacob.jar,fjutilities.jar,rolloverbut

ton.jar,images.jar,getclientinfo.jar
em_mode=1

4. C:\app_server\reports\conf\rwservlet.properties
copy SERVER=rep_Programmer_app_server

5. C:\app_server\reports\conf\cgicmd.dat

paste it at the end of server ...
TEST: userid=hr/hr@erp SERVER=rep_Programmer_app_server%*

Oracle Application Express (APEX) 5.0 Installation

SETUP:

Create a new tablespace to act as the default tablespace for APEX.

CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/ldb/apex02.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M;

Installation

Change directory to the directory holding the unzipped APEX software.

$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1/apex
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX APEX TEMP /i/

Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apxchpwd.sql
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_rest_config.sql

OHS Configuration

Change the password and unlock the APEX_PUBLIC_USER account. This will be used for any Database Access

Descriptors (DADs).

SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY 123 ACCOUNT UNLOCK;

Embedded PL/SQL Gateway (EPG) Configuration

Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a

parameter.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_epg_config.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Unlock the ANONYMOUS account.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
If this is an upgrade to an existing APEX installation, you will also have to run the following script, to

update the images.

SQL> @apxldimg.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Check the port setting for XML DB Protocol Server.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
          0

1 row selected.

SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.

SQL> EXEC DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL>


For future reference, to get to the Apex Administration Services:

http://127.0.0.1:8080/apex/apex_admin

n.b.:https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation

Collections in Oracle PL/SQL

n.b.:https://oracle-base.com/articles/8i/collections-8i#index-by-tables

Oracle uses collections in PL/SQL the same way others languages use arrays. Oracle provices three basic collections,
each with an assortment of methods,

1.Index-by Tables
2.Nested Table
3.Varry

1.Index-by Tables:
i. No upper bounds
ii. the collection is indexed using BINARY_INTEGER

SET SERVEROUTPUT ON ;
Declare
Type arr_number is table of number index by BINARY_INTEGER;
v_empno arr_number;
v_index number;
v_count number:=0;
begin
for i in 1..5 loop
v_empno(i):= i;
v_count := i;
end loop;
for j in 1..v_count  loop
dbms_output.put_line (v_empno(j));
end loop;
end;


2.Nested Table
...

3.Varry
...