foalabs

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 and name them groups 4, 5, and 6, each 10MB in size: SQL> alter database add logfile group 4  '/u01/oracle/db/log4PROD.dbf' size 10M;  SQL> alter database add logfile group 5  '/u01/oracle/db/log5PROD.dbf' size 10M; SQL> alter database add logfile group 6  '/u01/oracle/db/log6PROD.dbf' size 10M; 4. Run query to view the v$log status:   SQL> select group#, status fr...

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             OLAP Catalog                                       VALID CONTEXT         Oracle Text                                        VALID SDO             Spa...

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/oracle@DEV DBNAME=PROD DBNEWID: Release 12.1.0.1.0 - Production on Tue May 17 20:38:51 2016 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Connected to database DEV (DBID=738282423) Connected to server version 12.1.0 Control Files in database: /u02/oradata/PROD/control01.ctl /u02/oradata/PROD/control02.ctl Change database ID and database name DEV to PROD? (Y/[N]) => Y Proceedi...

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> dumpfile=<DUMP_NAME>_1.dmp,<DUMP_NAME>_2.dmp,<DUMP_NAME>_3.dmp,<DUMP_NAME>_4.dmp filesize=3000000000 This means max. 4 dump files with file size 3000000000 bytes (4x2.79 GB). SOLUTION: 1. Use the dynamic format  ( i.e dumpfile=<DUMP_NAME>_%U.dmp ) : The 'wildcard' specification for the dump file can expand up to 99 files. If 99 files have been generated before the export has c...

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 can move the tables, rebuild indeces in other tablespace or drop them as required.   select s.sowner MV_OWNER, s.tname MV_NAME, p.name TABLESPACE   from sys.obj$ o, sys.tab$ t, sys.user$ u, sys.snap$ s , sys.ts$ p   where t.ts#=p.ts# and p.name='<tablespace_name>'   and t.obj#=o.obj# and o.owner#=u.user# and u.name=s.sowner and o.name=s.tname   order by 1,2; select o.owner, ...

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

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 jar with force and  restart the services. 4. Open the forms now, it will work as expected. If you like please follow and comment

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/EBSapps/log/adop/82/20240408_144049/prepare/validate/test-19c-sep22 -promptmsg=hide"     [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on foaapps Reason : Query the below parameter in db context file. grep -i s_patch_service entry $CONTEXT_FILE Value not present. or select * fro m apps.FND_OAM_CONTEXT_FILES; --> this dont shows any database context file entry. Soultion ...

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 responds with its own list of supported key exchange algorithms. Both parties negotiate and agree upon a mutually acceptable algorithm to use for key exchange. Example: The server responds with its list of supported key exchange algorithms: Server: KEXINIT Algorithms: diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1 Key Generation: Both the client and server generate a shared secret ...

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 observations. This shows respect for the other person's boundaries and allows them to prepare themselves for the conversation. You might say something like, "I would like to share an observation, if you don't mind." 2. Describe the Circumstance: Provide context for your feedback by describing the specific circumstance or situation where the behavior occurred. This h...