How To Resize the Online Redo Logfiles in Oracle Database Steps: 1. Check size of the current logs: sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 1048576 INACTIVE 2 1048576 CURRENT 3 1048576 INACTIVE Logs are 1MB from above, let’s size them to 10MB. 2. Find all the log member names for the groups: SQL> select group#, member from v$logfile; GROUP# MEMBER ————— —————————————- 1 /u01/oracle/db/log1PROD.dbf 2 /u01/oracle/db/log2PROD.dbf 3 /u01/oracle/db/log3PROD.dbf 3. Let’s create 3 new log groups a ..read more

Query to find the Installed Components of an Oracle Database Connect to database as SYSDBA Query: set line 200; set pagesize 9999; col COMP_ID format a15; col COMP_NAME format a50; select COMP_ID,COMP_NAME,STATUS from dba_registry; Output as Below: COMP_ID         COMP_NAME                                          STATUS --------------- -------------------------------------------------- -------------------- AMD             O ..read more

Steps To Change The Oracle Database Name Using Nid Utility We will change the database name from DEV to PROD. 1. Mount the database SQL> STARTUP MOUNT ORACLE instance started. Total System Global Area 8754618368 bytes Fixed Size 4646288 bytes Variable Size 3556776560 bytes Database Buffers 5033164800 bytes Redo Buffers 160030720 bytes Database mounted. SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- DEV MOUNTED 2. Run the NID utility SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME   [oracle@funoracledb]$ nid target=sys ..read more

DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted ERROR: ORA - 39095 : " dump file space has been exhausted. Unable to allocate 4096 bytes" job system.sys_export_full_02 stops due to fatal error. While performing DataPump export:     when exporting a large number of tables then it completely stops     the jobs may remain in the DataPump export tables     no trace generated at the time of the failure. REASON: Limited the number of files in DUMPFILE parameter with limited FILESIZE , i.e.: full=Y directory=<DIRECTORY_NAME> dump ..read more

ORA-23515: materialized views and/or their indices exist in the tablespace Error: Drop tablespace failed with below error :  SQL> DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-23515: materialized views and/or their indices exist in the tablespace Solution: We may use the following queries to find out which materialized views and/or which indexes of materialized view container tables are on the tablespace you intend to drop. Once these objects are found you ca ..read more

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