Pages

Tuesday, June 17, 2025

Toyota Aygo Tyres Specs

Toyota Aygo The Tires Spec
155/65 R14 75 T

155 - The width of your tire in millimeters from sidewall to sidewall.

65 - The tire “profile”. The aspect ratio is a percentage that indicates the tire’s height vs. its width. 65, meaning that this tire’s height is 65% of its width

A lower aspect ratio is often indicative of a sportier, more performance-oriented tire.
A higher aspect ratio tends to indicate the tire was designed for other priorities like comfort or rugged durability.

R - Next you will find a single letter, either a “D”, a “B”, or an “R” which indicates the construction type for the tire. 
“R” indicates that the tire is a Radial tire 
“D” is a Diagonal (also known as “Bias”) ply tire 
“B” means it is a Belted-Bias ply tire.

Today, tires featuring Radial construction are by far the most common type. They are made with layers of fabric cords positioned at a 90’ angle to the center line of the tread. Radials became the dominant type of construction because of their superior fuel economy, traction, ride comfort and especially tread life when compared to earlier types of construction. 

14 - Rim diameter—sometimes also noted as the wheel diameter.  This measurement is in inches.

75 - Load index. The load index symbol indicates how much weight a tire can support.
   There is a table that translates code to weight.
    For example: 75 stands for 853 lbs / 387 kg


T - Speed Rating
   There is a table that translates code to speed.
   This indicates the top speed it’s safe to travel for a sustained amount of time. 
   A tire with a higher speed rating can handle heat better and provide more control at faster speeds. 
   T - Stands for 118 mph (189 kmh)

Wednesday, June 4, 2025

DBMS_SCHEDULER by example

==============================
Examples of using DBMS_SCHEDULER
==============================

Create Job
BEGIN 
 DBMS_SCHEDULER.CREATE_JOB ( 
  job_name => 'REFRESH_GSM_ROAMING_INFO_MV', 
  job_type => 'PLSQL_BLOCK', 
 job_action => 'BEGIN DBMS_MVIEW.REFRESH(''GSM_ROAMING_INFO_MV''); END;', 
 start_date => SYSDATE+1/1440, 
 repeat_interval => 'FREQ=HOURLY;INTERVAL=4', -- Run every 4 hours 
 enabled => TRUE, 
 comments => 'Refresh materialized view GSM_ROAMING_INFO_MV every 4 hours' ); 
END; 
/

Update Property
--Update job_action
BEGIN
    DBMS_SCHEDULER.SET_ATTRIBUTE(
        name      => 'MV_RF$J_0_S_326',
        attribute => 'job_action',
        value     => 'DBMS_REFRESH.REFRESH(''GSM_ROAMING_INFO_MV'');'
    );
END;
/

--Update repeat_interval
BEGIN
    DBMS_SCHEDULER.SET_ATTRIBUTE(
        name      => 'REFRESH_GSM_ROAMING_INFO_MV',
        attribute => 'repeat_interval',
        value     => 'FREQ=MINUTELY;INTERVAL=5'
    );
END;
/


Drop Job
DECLARE 
  CURSOR job_remove_cur IS
  SELECT job_name FROM USER_SCHEDULER_JOBS
   WHERE UPPER(job_action) LIKE '%GSM_ROAMING_INFO_MV%';
BEGIN
  FOR job_remove_rec IN job_remove_cur LOOP
    dbms_scheduler.drop_job(job_name => job_remove_rec.job_name);
    COMMIT;
  END LOOP;
END;
/

Monitor Job
SELECT job_action, 
       last_start_date,
       next_run_date, 
       failure_count, 
       run_count 
  FROM USER_SCHEDULER_JOBS 
 WHERE job_name = 'REFRESH_GSM_ROAMING_INFO_MV';


Sunday, May 25, 2025

See difference in Oracle Profiles

==================
See current status
==================
COL default_profile FOR A10
COL app_prof_profile FOR A10
COL resource_name FOR A30
COL default_limit FOR A20
COL app_prof_limit FOR A40
set LINESIZE 160

SELECT DBA_PROFILES_DEFAULT.profile default_profile, 
       DBA_PROFILES_APP_PROF.profile app_prof_profile, 
       DBA_PROFILES_DEFAULT.resource_name resource_name,
       DBA_PROFILES_DEFAULT.limit default_limit, 
       DBA_PROFILES_APP_PROF.limit app_prof_limit
  FROM DBA_PROFILES DBA_PROFILES_DEFAULT,
       DBA_PROFILES DBA_PROFILES_APP_PROF
 WHERE DBA_PROFILES_DEFAULT.profile='DEFAULT'
   AND DBA_PROFILES_APP_PROF.profile='APP_PROF'
   AND DBA_PROFILES_DEFAULT.resource_name = DBA_PROFILES_APP_PROF.resource_name
   AND DBA_PROFILES_DEFAULT.limit <> DBA_PROFILES_APP_PROF.limit
ORDER BY 3,1,2;

DEFAULT_PR APP_PROF_P RESOURCE_NAME            DEFAULT_LIMI APP_PROF_LIMIT
---------- ---------- ------------------------ ------------ ---------------------------
DEFAULT    APP_PROF   IDLE_TIME                UNLIMITED    480
DEFAULT    APP_PROF   PASSWORD_LOCK_TIME       1            UNLIMITED
DEFAULT    APP_PROF   PASSWORD_ROLLOVER_TIME   0            DEFAULT
DEFAULT    APP_PROF   PASSWORD_VERIFY_FUNCTION NULL         ORA12C_STIG_VERIFY_FUNCTION

==================
Change settings:
==================
ALTER PROFILE APP_PROF LIMIT IDLE_TIME UNLIMITED;
ALTER PROFILE APP_PROF LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Details:
PASSWORD_ROLLOVER_TIME - DEFAULT - Is same as zero
PASSWORD_LOCK_TIME - When user becomes unlocked, after the specified number of consecutive failed login attempts


==================
Theory
==================
Password-Specific Settings in the Default Profile


Parameter: INACTIVE_ACCOUNT_TIME 
Default Setting Description: UNLIMITED
Description: Locks the account of a database user who has not logged in to the database instance in a specified number of days.

Parameter: FAILED_LOGIN_ATTEMPTS
Default Setting Description: 10
Description: Sets the maximum times a user try to log in and to fail before locking the account.

Note: You can set limits on the number of times an unauthorized user (possibly an intruder) attempts to log in to Oracle Call Interface (OCI) applications by using the SEC_MAX_FAILED_LOGIN_ATTEMPTS initialization parameter.

Parameter: PASSWORD_GRACE_TIME
Default Setting Description: 7
Description: Sets the number of days that a user has to change their password before it expires.

Parameter: PASSWORD_LIFE_TIME
Default Setting Description: 180
Description: Sets the number of days the user can use their current password.

Parameter: PASSWORD_LOCK_TIME
Default Setting Description: 1
Description: Sets the number of days an account will be locked after the specified number of consecutive failed login attempts.

After the time passes, then the account becomes unlocked. 
This user's profile parameter is useful to help prevent brute force attacks on user passwords but not to increase the maintenance burden on administrators.
Even after the value set by PASSWORD_LOCK_TIME shows that the password has expired, the DBA_USERS data dictionary view will show that the account is locked. 
However, after the user connects, the information in DBA_USERS is updated with the correct OPEN status.

Parameter: PASSWORD_REUSE_MAX
Default Setting Description: UNLIMITED
Description: Sets the number of password changes required before the current password can be reused.

Parameter: PASSWORD_REUSE_TIME
Default Setting Description: UNLIMITED
Description: Sets the number of days before which a password cannot be reused.

Parameter: PASSWORD_ROLLOVER_TIME
Default Setting Description: 0
Description: Enables the gradual database password rollover time.

Unable to obtain current patch information, Latest xml inventory is not loaded into table, RawInventory gets null OracleHomeInfo

==================
Error
==================
Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
ORA-06512: at "SYS.DBMS_QOPATCH", line 854
ORA-06512: at "SYS.DBMS_QOPATCH", line 937
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_QOPATCH", line 932
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /software/oracle/19c/QOpatch/qopiprep.bat encountered error "LsInventorySession failed: RawInventory gets null OracleHomeInfo
"
ORA-06512: at "SYS.DBMS_QOPATCH", line 919
ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
ORA-06512: at "SYS.DBMS_QOPATCH", line 817
ORA-06512: at "SYS.DBMS_QOPATCH", line 2309


==================
Debug
==================
oracle@hostname:/software/oracle/19c/OPatch>%./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /software/oracle/19c
Central Inventory : /software/oracle/oraInventory
   from           : /software/oracle/19c/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /software/oracle/19c/cfgtoollogs/opatch/opatch2025-05-25_08-12-01AM_1.log

List of Homes on this system:

  Home name= OraDB19Home1, Location= "/software/oracle/1910"
LsInventorySession failed: RawInventory gets null OracleHomeInfo

OPatch failed with error code 73
oracle@hostname:/software/oracle/19c/OPatch>%

==================
Fix
==================
Edit OraDB19Home1 to correct value /software/oracle/19c

vi /software/oracle/oraInventory/ContentsXML/inventory.xml
<HOME_LIST>
<HOME NAME="OraDB19Home1" LOC="/software/oracle/1910" TYPE="O" IDX="1"/>
</HOME_LIST>

<HOME_LIST>
<HOME NAME="OraDB19Home1" LOC="/software/oracle/19c" TYPE="O" IDX="1"/>
</HOME_LIST>