Cannot read value from field PARAMETER.CONFIG Error: Cannot read value from field PARAMETER.CONFIG" This error appeared when adstrtal.sh was done on an instance.  Reason: SQL> select end_date from fnd_user where user_name='GUEST'; END_DATE --------------- 17-APR-96 SQL> Guest user was end-dated. Solution: 1) Connect as apps user and run below update. Sqlplus apps/apps update fnd_user set end_date=null where user_name='GUEST'; 2) Commit; 3) Retry, issue should be solved. If you like please follow and comment ..read more

EBS Form JWS Launch Error - JAR Resources In JNLP File Are Not Signed By Same Certificate Error: In Oracle apps R12.2 version When attempting to open any Forms the following error occurs ExitException: JAR resources in JNLP file are not signed by same certificate Reason: Using non-shared JAVA_TOP and using self-signed certificate. Jar files are not signed with same certificate on both the nodes Solution: 1. Please stop the services on second web node. 2. Backup $APPL_TOP_NE/ad/admin/adkeystore.dat and adsign.txt  and copy these files  from primary node. 3. Generate the ..read more

The value of s_patch_service_name is not set correctly in atleast one of the context files Error: While running Adop prepare phase, we are encountering below error. [ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.     [UNEXPECTED]Error occurred running "perl /u02/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u02/apps/fs1/inst/apps/DEV_foaapps/appl/admin/DEV_foaapps.xml -patchctxfile=/u02/apps/fs2/inst/apps/DEV_foaapps/appl/admin/DEV_foaapps.xml -phase=prepare -logloc=/u02/apps/fs_ne/EBSa ..read more

Key Exchange (KEX) and Host Key Algorithms in SSH Key Exchange (KEX): Key Exchange is the process by which an SSH client and server establish cryptographic keys to secure the communication channel between them. The key exchange process typically involves the following steps: Initiation: The SSH client initiates the connection by sending a Key Exchange Initiation (KEXINIT) message to the server, indicating its supported algorithms and preferences. Example: The SSH client sends a Key Exchange Initiation (KEXINIT) message to the server: Client: KEXINIT Algorithm Negotiation: The server respon ..read more

Giving Feedback: A Guide to Constructive Communication Giving feedback is an essential skill in both personal and professional relationships. Whether you're providing feedback to a colleague, friend, or family member, it's important to approach the conversation with care and consideration. In this article, we'll explore the steps to giving feedback effectively using the framework of asking permission, describing the circumstance, behavior, and impact, and offering a suggestion for improvement. 1. Ask Permission: Before diving into feedback, it's crucial to ask for permission to share your obse ..read more

Testing Open Ports in Linux Testing open ports is a fundamental task in network troubleshooting and security assessment. While Telnet has been a traditional tool for this purpose, there are several alternatives available in Linux that offer similar functionality with added features and capabilities. I will share few ways and how they can be used to test open ports effectively. 1. Netcat (nc): Netcat is a versatile networking utility that can be used for reading from and writing to network connections using TCP or UDP. Its -z option allows you to scan for open ports without sending any data ..read more

joxcsys: release mismatch 12.1.0.2.0 1.6 in database (classes.bin) vs 12.1.0.2.191015 1.6 in executable  Error: In database alert log we can see continous below error. joxcsys: release mismatch 12.1.0.2.0 1.6 in database (classes.bin) vs 12.1.0.2.191015 1.6 in executable Solution: 1) Connect to database as sysdba 2) Replicate the issue SQL> select dbms_java.get_jdk_version() from dual; select dbms_java.get_jdk_version() from dual                                         * ERROR a ..read more

RMAN Backup Format Specifier Format specifiers in RMAN are placeholders that dynamically generate filenames and directory paths based on predefined patterns and parameters. They allow DBAs to define flexible naming conventions and storage locations for backup files, making it easier to organize and manage backup sets. Format specifiers are denoted by percent (%) signs followed by one or more characters representing specific attributes or values. For example, %t inserts a timestamp, %s inserts the backup set sequence number, and %d inserts the database name. The following substitiion variabl ..read more

SQL Query to find Session In Oracle Database Not Active from 30 mins Query SELECT s.sid,        s.serial#,        s.username,        s.machine,        s.program,        s.status,        s.osuser,        s.logon_time,        s.last_call_et AS "Elapsed Time (sec)",        t.sql_text FROM   v$session s JOIN   v$sqltext t ON s.sql_address = t.address WHERE  s.type != 'BACKGROUND' AND  &nbs ..read more

Moving RMAN backup from the OCI Standard Bucket to Archive Storage - Oracle Cloud Storing large volumes of database backups in Object Storage? Is the data seldom accessed or primarily intended for archival purposes? Now, with the introduction of Archive Storage, we have an opportunity to leverage a cost-effective, long-term, and secure storage solution. The key distinction between data backup and data archiving lies in the duration of data retention and the frequency of access. Archiving offers prolonged storage with infrequent access. Oracle offers Archive Storage as part of its Oracle Clou ..read more