APPSDBA Data Lake

  The following example illustrates the process of moving a SQL Profile from 10.2 onwards. 1. Create SQL Profile in SCOTT schema The SQL Profile is created based on the tuning task created and the recommendations given by the tuning task: DECLARE  my_task_name VARCHAR2(30); my_sqltext CLOB;  my_sqlprofile_name VARCHAR2(30);  BEGIN    my_sqltext := 'select /*+ no_index(emp pk_emp) */ * from emp where empno=7839';    my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_text => my_sqltext,          user_name => 'SCOTT',          scope => 'COMPREHENSIVE',          time_limit => 60,          task_name => 'my_sql_tuning_task',          description => 'Demo Task to tune a query');     DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'my_sql_tuning_task');  my_sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (task_name =>'my_sql_tuning_task',          name => 'my_sql_profile');  END;  / PL/SQL procedure s

 [ortansid@shsebs121db01 orastage]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 23 02:30:39 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. connected to target database: TANSID (DBID=3902989410) RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name TANSID are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYP

  1. stop the database service. srvctl stop database -d TANSID 2. start the database in mount state. srvctl start database -d TANSID -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the database service srvctl stop database -d TANSID srvctl start database -d TANSID 5. Set the archive log destination to ASM DISK SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*'; System altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +ARCH Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 2 SQL> alter system switch logfile; System altered. Checked the space of ARCH asm diskgroup before setting it for the archive destination. SQL> select NAME,TOTAL_MB/1024 from v$asm_diskgroup; NAME TOTAL_MB/1024 ------------------------------ ------------- ARCH 33.77

  Identify Objects in SYSAUX Tablespace set linesize 120 set pagesize 100   COLUMN "Item" FORMAT A25 COLUMN "Space Used (GB)" FORMAT 999.99 COLUMN "Schema" FORMAT A25 COLUMN "Move Procedure" FORMAT A40   SELECT occupant_name "Item", space_usage_kbytes/1048576 "Space Used (GB)", schema_name "Schema", move_procedure "Move Procedure" FROM v$sysaux_occupants ORDER BY 1;   Item                      Space Used (GB) Schema                    Move Procedure ------------------------- --------------- ------------------------- ---------------------------------------- AO                                    .00 SYS                       DBMS_AW.MOVE_AWMETA EM                                    .08 SYSMAN                    emd_maintenance.move_em_tblspc EM_MONITORING_USER                    .00 DBSNMP EXPRESSION_FILTER                     .00 EXFSYS JOB_SCHEDULER                         .00 SYS LOGMNR                    

  Overview OPMN will log the following errors when attempting to start the patched opmn process with a default MD5withRSA signed certificate: [opmn] [ERROR:1] [] [ons-secure] Connection server SSL set credentials failed (43084) [opmn] [ERROR:1] [222] [ons-secure] SSL initialization failed Generating and Deploying a New Wallet for TLS Enabled Release 12.2 Environments Log in as the user that owns the application tier installation (this is usually applmgr or oracle). Source the run file system environment and the $FMW_HOME/SetWebtier.env file. $ source <EBS base install directory>/EBSapps.env run $ source $FMW_HOME/SetWebtier.env For a new Oracle E-Business Suite Release 12.2 installation, all steps must be performed on the run edition file system, which is sourced by running the following command: $ source <EBS base install directory>/fs1/EBSapps/appl/APPS<CONTEXT_NAME>.env Set an alias for the correct orapki. $ alias orapki=$FMW_HOME/oracle_common/bin/orapki Create a

 During connection from SQL Developer to EBS database got below error message: Status : Failure - Test failed: IO Error: Got minus one from a read call Following solution can be done : 1. Go to directory $ORACLE_HOME / network / admin 2. Modify sqlnet.ora file with following parameter : tcp.validnode_checking = no 3. If you don 't want to disable this, you can put the machine names as follows: tcp.invited_nodes=(machine1, machine2) 3. Bounce the listener. Due to security enhancements it is not good to put tcp.validnode_checking = no or comment out will through error when we start listener like below: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shsebs7idb1.appsolworld.com)(PORT=1522))) TNS-00584: Valid node checking configuration error TNS-12560: TNS:protocol adapter error Better plan is to add localhost or IP address of client (Local Computer) in the sqlnet.ora file That will solve the problem NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPI