How to change APPLSYSPUB password in EBS R 12.2

 

After implementing PASSWORD_LIFE_TIME TO 30 DAYS for default profile, applsyspub user’s password was expired after 30 days.

Following error is observed after logging in to application,

 





Solution:-

We altered the profile of APPLSYSPUB user from default to EBS_APPS and rested the password of APPLSYSPUB user.

SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE FROM DBA_USERS WHERE USERNAME='APPLSYSPUB';

USERNAME             ACCOUNT_STATUS       EXPIRY_DATE     PROFILE

-------------------- -------------------- --------------- -------------------------

APPLSYSPUB           EXPIRED              27-MAR-21       DEFAULT

 

SQL>  ALTER USER APPlSYSPUB PROFILE EBS_APPS;

 

User altered.

 

 

·       Shutdown application service.

 

[appltest@vm1test scripts]$ cd $ADMIN_SCRIPTS_HOME

[appltest@vm1test scripts]$ adstpal.sh

 

 

·       Reset APPLSYSPUB password using FNDCPASS OR AFPASSWD .

Note:- APPLSYSPUB password must be in UPPER CASE due to internal code dependencies.

[appltest@vm1test scripts]$ AFPASSWD -c APPS -o applsyspub

Enter the ORACLE password of Application Object Library 'APPSUSER':

Connected successfully to APPS.

Enter the password for your 'SYSTEM' ORACLE schema:

Enter the password for your 'SYSTEM' ORACLE schema:

Connected successfully to SYSTEM.

Log file: AFPWD_TEST_042697.log

Enter new password for user [applsyspub]:

Verify new password for user [applsyspub]:

 

 

 

·       Make following changes in application context file.

Take a backup of application context file.

 

[appltest@vm1test scripts]$ cp $CONTEXT_FILE  TEST_vm1test.xml_bkp

[appltest@vm1test scripts]$ vi $CONTEXT_FILE

Look for following parameter s_gwyuid and s_gwyuid_pass

 

Make changes like this

From

<GWYUID oa_var="s_gwyuid">APPLSYSPUB/PUB</GWYUID>

 

To

<GWYUID oa_var="s_gwyuid">APPLSYSPUB/NEWAPPLSYSPUBPASSWD</GWYUID>

 

From

 

<password oa_var="s_gwyuid_pass">PUB</password>

 

To

<password oa_var="s_gwyuid_pass"> NEWAPPLSYSPUBPASSWD </password>

 

·       Run autoconfig on application tier

[appltest@vm1test scripts]$ sh adautocfg.sh

 

 

·       Start application  and now error should be resolved.





Various OCI CLI command for OCI Object Storage administration



·       Command to create bucket

Syntax:

oci os bucket create --compartment-id <compartment id> --name <bucket name>

 

Example:

oci os bucket create --compartment-id ocid1.compartment.oc1..aaaaaaaacgen54z6eyimw7pnp4a553425kifsq --name TESTBUCKET

 

 

 

·       Command to delete bucket

Syntax :

oci os bucket delete --name <Bucket name>

 

Example :

oci os bucket delete --name TESTBUCKET

 

 

·       Command to list out all the objects inside a bucket

Syntax:

oci os object list --bucket-name < Bucket name >             

 

Example:

oci os object list --bucket-name TESTBUCKET     

 

·       Command to upload files inside a bucket.

Syntax:

oci os object put –bn <Bucket_Name> --name <uploaded file_name > --file<source file_name>

 

Example:

oci os object put -bn TESTBUCKET --name x.sql --file x.sql

 

·       Command to upload files inside a directory created under a bucket.

Syntax:

oci os object put –bn <Bucket Name> --name <Direcotry name/uploaded file name> --file <source file name>

 

Example:

oci os object put -bn TESTBUCKET --name Backup/x.sql --file x.sql

 

·       Command to Download a file residing inside a bucket.

Syntax:

oci os object bulk-download –bn <Bucket Name> --download-dir <Path where file would be downloaded> --prefix <File which would be downloaded>

 

 

Example:

oci os object bulk-download -bn TESTBUCKET --download-dir /home/oracle --prefix x.sql

 

·       Command to Download files from a directory which is created under a bucket.

Syntax:

oci os object bulk-download –ns <Bucket namespace> -bn <Bucket Name> --download-dir

<Path where file would be downloaded> --prefix <Directory path/file name which would be downloaded>

 

Example:

oci os object bulk-download -ns bm1uufa0a -bn TESTBUCKET --download-dir /home/oracle --prefix Backup/x.sql

  

 Command to Download all files from a bucket

Syntax:

oci os object bulk-download –ns <Bucket namespace> -bn <Bucket Name> --download-dir <Path where file would be downloaded>

 

oci os object bulk-download -ns bm642gedufa0a -bn TESTBUCKET --download-dir /home/oracle

·     

  Command to delete file from bucket

Syntax:

oci os object delete -bn <Bucket Name> --object-name <Name of object to delete>

 

Example:

oci os object delete -bn TESTBUCKET --object-name t1.sql

 

·       Command to delete file from a folder residing inside bucket

Syntax:

oci os object delete -bn <Bucket Name> --object-name <Location from where file to be delete>

 

Example:

oci os object delete -bn TESTBUCKET --object-name Backup/x.sql

 

Command to find out all of the in-progress multipart uploads

Syntax:-

oci os multipart list --namespace-name <Bucket_Namespace> –bn <Bucket_Name>


 Example:

oci os multipart list --namespace-name lsaf54dfae -bn TESTBUCKET

 

Command to abort or remove in-progress multipart uploads

Syntax:-

oci os multipart abort -bn <Bucket_name> --object-name <object_name> --upload-id <upload_ID>

 Example:-

oci os multipart abort -bn TESTBUCKET --object-name PROD_backup_12042021/rman_bkp_9.tar.gz --upload-id 941a510d-37ec-2ddb-8b63-112634475f52