Wednesday, May 10, 2023

Install OEM Oracle Enterprise Manager

1) install oracle db sid/service_name "emcdb" and pdb "emrep"
2) check /tmp space should be >15gb 
3) use normal listener without sid_listener_list 
4) sqlplus / as sysdba  
5) alter pluggable database emrep open read write; alter pluggable database emrep save state;
6) execute following as sysdba on cdb 
7) 
-- Recommended minimum settings.
alter system set "_allow_insert_with_update_check"=true scope=both;
alter system set session_cached_cursors=200 scope=spfile;
alter system set processes=600 scope=spfile;
alter system set pga_aggregate_target=450M scope=spfile;
alter system set sga_target=800M scope=spfile;
alter system set shared_pool_size=600M scope=spfile;
-- Unset any adaptive optimizer settings that were set for the previous installation. They are not needed now.
alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both sid='*';
alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';
alter system reset "_px_adaptive_dist_method" scope=both sid='*';
alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';
alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';
alter system reset "_optimizer_use_feedback" scope=both sid='*';
alter system reset "_optimizer_gather_feedback" scope=both sid='*';
alter system reset "_optimizer_performance_feedback" scope=both sid='*';
8) Restart the repository database.
9) check connecting remotely using sql developer/toad 
10) connectivity for cdb "emcdb" --> host:kayyum port:1521 sid:emcdb 
11) connectivity for pdb "emrep" --> host:kayyum port:1521 service:emrep 
12) copy all oem files *.zip and .bin to /u02 
13) chmog u+x *.bin 
14) ./em13500_linux64.bin 
15) wait for universal installer screen to popup 
vm installation:-
/ ---> 150gb
/tmp-->30gb
/home-->10gb
/var -->5gb
/biosboot ---> 1gb 
network:- 
bridged network automatic dhcp
NAT network assign 192.168.56.71

No comments:

Post a Comment

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...