Thursday, July 19, 2018

Could not locate shrept.lst make: *** [client_sharedlib] Error 1

 Installing the quarterly database patch i got unpleasant message :

"
Patching component oracle.sdo, 12.2.0.1.0...
Make failed to invoke "/usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1"....'genclntsh: genclntsh: Could not locate  /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/shrept.lst
make: *** [client_sharedlib] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1"....'genclntsh: genclntsh: Could not locate  /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/shrept.lst
make: *** [client_sharedlib] Error 1
'
Make failed to invoke "/usr/bin/make -f ins_ldap.mk ldapsearch ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1"....'genclntsh: genclntsh: Could not locate  /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/shrept.lst
make: *** [/u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so] Error 1
'

The following make actions have failed :

Re-link fails on target "client_sharedlib".
Re-link fails on target "client_sharedlib".
Re-link fails on target "ldapsearch".


Do you want to proceed? [y|n] y
User Responded with: Y
Patch 28163133 successfully applied.
Sub-set patch [27674384] has become inactive due to the application of a super-set patch [28163133].
Please refer to Doc ID 2161861.1 for any possible further required actions.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-07-19_10-40-25AM_1.log

OPatch completed with warnings.
"


The reason of this error is obvious: i removed shrept.lst file from $OH/network/admin some time ago.

MOS note make advice to copy this file from similar $OH, but i have no similar $OH near me.

The solution was found to extract the shrept.lst  file from Database Installation Media file, in my case it is linuxx64_12201_database.zip .

1. Unzip linuxx64_12201_database.zip and go to directory
database/stage/Components/oracle.rdbms.rsf/12.2.0.1.0/1/DataFiles/

Here are 3 files :


 
2. The jar - is a zip-archive, so we can unzip it and search the shrept.lst in it
[oracle@oel6 DataFiles]$ unzip filegroup1.jar filegroup2.jar filegroup3.jar
[oracle@oel6 DataFiles]$ find . -name shrept*
./plsql/admin/shrept.lst
./shrept.lst
./rdbms/admin/shrept.lst

[oracle@oel6 DataFiles]$ ls -l ./plsql/admin/shrept.lst ./shrept.lst ./rdbms/admin/shrept.lst
-rw-r--r-- 1 oracle oinstall    72 Apr 15  1998 ./plsql/admin/shrept.lst
-rw-r--r-- 1 oracle oinstall 50099 May  5  2016 ./rdbms/admin/shrept.lst
-rwxr-x--- 1 oracle oinstall 50099 Jul 19 11:22 ./shrept.lst

The plsql is not our case.
It seems both last 2 files are the same. So make the copy and relink:
$ cp ./shrept.lst $OH/network/admin
$ cd $OH/bin
$ ./relink all

And now relink work well !
:)

Oracle Universal Installer... Checking swap space: 493 MB available, 500 MB required. Failed

After installing the patch i decided to relink all binaries. The relinking procedure is very simple:

$ cd $OH/bin
$ ./relink all 

But in my environment i got a unpleasant message:

" Starting Oracle Universal Installer...

Checking swap space: 493 MB available, 500 MB required.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,

Exiting Oracle Universal Installer ...  "


Because I'm on the Linux, then the fastest solution is to make additional swap file.
It can be done online:

# free
# df -h
# dd if=/dev/zero of=/swapfile bs=1M count=100
# chmod 0600 /swapfile
# mkswap /swapfile
# swapon /swapfile
# df -h
# free


And relink  say:

"Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 593 MB    Passed
Preparing to launch Oracle Universal Installer ..."



To revert changes (online): 
#  swapoff /swapfile
#  rm /swapfile






Thursday, July 5, 2018

12.2+ SQL*Net fetures applicable for ExaStack

In 12.2 Oracle added ExaDirect SQL*Net Adapter:



 And in 18.1 Oracle deprecated SDP protoco (deprecated is supported, but not recommended):





https://docs.oracle.com/en/database/oracle/oracle-database/18/netag/changes-in-this-release.html#GUID-606D7C27-FBE9-47E7-B5A7-308CB576955E 
It is difficult to understand that Oracle:


https://docs.oracle.com/en/database/oracle/oracle-database/18/netag/understanding-communication-layers.html#GUID-E90842A7-D1ED-4356-91C7-E376E2889920

How to setup ExaDirect :
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/netag/optimizing-performance.html#GUID-5499D049-CEB6-4AD1-99B6-0211D391908E

Wednesday, June 13, 2018

ZDLRA configuration parameters

https://docs.oracle.com/cd/E88198_01/AMAGD/amagd_views.htm#AMAGD1437
The documentation says that rasys.RA_SERVER is the place of setting for RA.
Look:



But the actual settings treasury is rasys.CONFIG !

SQL> select * from config ;

NAME                   VALUE
------------------------------------------------------------------------------------------------
_aggressive_delete           YES
_alg_over_alloc            125
_alloc_increment           4294967296
_api_lock_wait_seconds           30
_baseline_cap               14
_biot_bytes_to_sample           1073741824
_biot_coalesce_threshold       40
_biot_shrinking_threshold      10
_biot_slaves               16
_build                   21-05-2018 10:10:32 ZDLRA_12.2.1.1.1.201803_LINUX.X64_RELEASE
_busy_interrupt_max           50000
_busywork_inhibit_time           .003472222222222222222222222222222222222222
_c2t_optimization           ON
_check_files_parallelism       8
_check_sbtsched_days           .0208333333333333333333333333333333333334
_chunk_cache               512
_chunkno_alloc               1024
_compress               YES
_crosscheck_throttle           5
_db_stats_refresh_days           .006944444444444444444444444444444444444445
_dbfs_time_out_days           .003472222222222222222222222222222222222222
_dead_schedulers_days           .000694444444444444444444444444444444444445
_debug_error               4026629350
_debug_when               0
_def_contfilesize           2t
_def_min_alloc               4194304
_default_poll_frequency_days   .0416666666666666666666666666666666666667
_defer_delete               NO
_disable_virtual_sections      0
_ds_reconcile_dbgflgs           0
_dumper_dfile_ext           .txt
_dumper_dp_ext               .dmp
_dumper_dplog_ext           .log
_dumper_inhibit_days           1
_dumper_last_dump_timestamp    01-06-17 17:46:00
_dumper_params               NODATAPUMP,NOBLOCKS,NOCHUNKS
_enable_populate_rsr_key       1
_expire_files_days           1
_expire_msec_files_days_max    1
_fragmentation               10
_histogram_cycle_slots           2920
_histogram_goal_percentile     .95
_histogram_slot_days           .1250000000000000000000000000000000000001
_histogram_window_slots        240
_history_long_retain_days      547.5
_history_partition_days        1
_history_prune_days           .1250000000000000000000000000000000000001
_history_retention           30
_history_short_retain_days     30
_incident_alert_threshold      10
_incident_dump_threshold       20
_incident_merge_limit_days     30
_initial_freespace_ratio       .05
_instance_check_delay           .006944444444444444444444444444444444444445
_interrupt_max               300
_interrupt_wait            20
_last_check_files           08-JUN-2018 18:39:30
_last_incarnation           1
_lock_refused_wait           5
_max_sbt_failures           15
_max_sched_cleanup_days        .0104166666666666666666666666666666666667
_max_sort_blocks           1048576
_max_task_restarts           10
_min_freespace_ratio           .01
_min_sessions_for_busywork     4
_no_purge_session_count        2
_nzdl_is_alive_days           .006944444444444444444444444444444444444445
_obsolete_sbt_days           1
_optimize_space_limit           .1
_ordering_wait_timeout_days    2
_orphan_file_delete_days       -7
_orphan_file_wait_days           .003472222222222222222222222222222222222225
_piece_affinity            YES
_plans_maintained           5
_polling_del_files_check_days  1
_polling_timeout_days           .0625000000000000000000000000000000000001
_preallocation_retention_days  .0416666666666666666666666666666666666667
_purge_autoshrink           .1
_purge_df_delmove_boost        .5
_purge_df_low_priority           .75
_purge_opt_free            4
_purge_opt_pct               .5
_purge_threshold           .9
_purge_wait               15
_purging_reserve           419430400
_quiesce_session_wait_days     .003472222222222222222222222222222222222222
_quiesce_wait               15
_ra_pool_freespace_threshold   .01
_ra_pool_full_free_count       10
_read_bufs               1024
_rebuild_index_tmo_days        .0416666666666666666666666666666666666667
_rebuild_limit               1
_reconcile_check_days           .003472222222222222222222222222222222222225
_reconcile_disable_obj_send
_reconcile_err_retry_cnt       5
_reconcile_force_fixed           NO
_reconcile_force_update        0
_reconcile_fxml_read           0
_reconcile_fxml_write           0
_reconcile_http_retry_cnt      0
_reconcile_long_delay_days     1
_reconcile_short_delay_days    .0416666666666666666666666666666666666667
_reconcile_upsert_insert       1
_reconcile_upsert_only           0
_reconcile_upsert_update       1
_reconcile_validate_data       1
_reconcile_wait_timeout_days   1
_reconstruct_header           0
_recovery_appliance_state      ON
_replication_max_streams       64
_replication_min_streams       4
_replication_stall_list
_replication_streams_per_node  4
_resilver_flags            0
_resource_wait_relax_rate      1.5
_resource_wait_task_limit      99999
_resource_wait_timeout_days    .0104166666666666666666666666666666666667
_restricted_session_count      5
_resumable_timeout           0
_rm_incomplete_files_days      .006944444444444444444444444444444444444445
_rroptimize_max_logranges      3
_run_purge_df_short_wait       30
_run_purge_df_wait           600
_sbt_library_home           ?/lib
_sched_icd_wait            300
_sched_lifetime_days           1
_sched_max_locktime           300
_sched_run_wait            5
_sched_sleep_wait           5
_scheduling_wait           5
_servlet_debug_flags           0
_servlet_read_timeout_secs     120
_servlet_wait_seconds           512
_servlet_write_timeout_secs    120
_session_count               24
_spare_asm_disks           2
_stall_when               OFF
_stats_retention_days           7
_storage_maintenance_days      .0416666666666666666666666666666666666667
_task_execution_limit_days     1
_task_execution_warning_days   .3333333333333333333333333333333333333333
_task_maintenance_days           .003472222222222222222222222222222222222225
_task_retry_wait_seconds       60
_throttle_max_channels           1000
_throttle_max_single_chan_req  128
_throttle_sbt_active_hours     12
_throttle_threshold_channels   872
_throttle_wait_aft_apprvl_secs 300
_throttle_wait_for_crash_secs  1800
_throttle_wait_repeat_req_secs 300
_timer_loop_sleep_seconds      15
_timer_wait_loop           60
_tmp_pre_comp_sbt           0
_trace_file_days           .125
_trim_factor               2
_v1pool_key               0
_waitfordbfs               /raacfs/raadmin/DONOTDELETE/rep_dbfs_present.txt
check_files_days           7
compatible               080004
crosscheck_db_days           1
network_chunksize           134217728
optimize_chunks_days           7
percent_late_for_warning       100
validate_db_days           7

164 rows selected.




Could not locate shrept.lst make: *** [client_sharedlib] Error 1

 Installing the quarterly database patch i got unpleasant message : " Patching component oracle.sdo, 12.2.0.1.0... Make failed to ...