Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

How to Setup Local NTP server in Linux 7

No comments

 How to Setup Local NTP server in Linux 7


Network Time Protocol (NTP) – This is a protocol which runs over port 123 UDP at

Transport Layer and allows computers to synchronize time over networks for an

accurate time.  This is majorly used when working with the cluster system, Oracle RAC,

Master-Slave setups.



We will see in this post how to set up the NTP Server and Client


Part 1- NTP server Preparation


1) Install ntp package: We need to install the ntp if not already available.


yum install ntp


2) Edit the NTP configuration


vi /etc/ntp.conf


3) Comment pool for server sync (Used in case of internet)


and Add local server 127.127.1.0


# Use public servers from the pool.ntp.org project.
# Please consider joining the pool (http://www.pool.ntp.org/join.html).
#server 0.rhel.pool.ntp.org iburst
#server 1.rhel.pool.ntp.org iburst
#server 2.rhel.pool.ntp.org iburst
#server 3.rhel.pool.ntp.org iburst
server 127.127.1.0

4) Restrict to a range of IP to which access is required.


Add below line in etc/ntp.conf


restrict 192.168.56.0 mask 255.255 255.0 notrap

logfile /var/log/ntpservice.log


5) Enable NTP service over the firewall


firewall-cmd --add-service=ntp --permanent

firewall-cmd --reload


6) Start NTPD service and enable it to start in case of a reboot.


systemctl start ntpd

systemctl enable ntpd

systemctl status ntpd


7) Verify the NTP is using which server ( In my case it is local)

[root@oel7 ~]# ntpq -p

remote refid st t when poll reach delay offset jitter

==============================================================================

*LOCAL(0) .LOCL. 5 l 8 64 7 0.000 0.000 0.000





Part 2- NTP Client Preparation


We can have the client as Linux, Windows, or Mac OS.


Setup client on Linux


We need to make sure NTP is installed or else we need to install it.


1) yum install ntp


2) Edit the ntp configuration file and setup to enable sync via NTP server configured earlier.

 We have to add an entry of our NTP server IP/hosts from where the client would sync.

 Comment the other pool entries.


vi /etc/ntp.conf



# Use public servers from the pool.ntp.org project.
# Please consider joining the pool (http://www.pool.ntp.org/join.html).
#server 0.centos.pool.ntp.org iburst
#server 1.centos.pool.ntp.org iburst
#server 2.centos.pool.ntp.org iburst
#server 3.centos.pool.ntp.org iburst
server 192.168.56.110
4) Sync the time before starting NTP service. It is done via hostname/IP of you NTP server
ntpdate -q 192.168.56.110

5) start ntp service
systemctl ntpd start
Now client is in sync with NTP server.

Setup client on Windows

Starting with Windows, Go to the Control Panel "Date and Time" option contains

an Internet Time tab which allows choosing an NTP server and turning time

synchronization on or off.

Update the entry with host/Ip or NTP server.










No comments :

Post a Comment

Oracle Reports - Program exited with status 255 for EBS in Windows

No comments

Oracle Reports - Program exited with status 255 for EBS in Windows


Issue:

When running Active Users or other reports getting below error on Windows-based EBS instance.

"Program exited with status 255

Cause: The program terminated, returning status code 255.

Action: Check your installation manual for the meaning of this code on this operating system.
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request Request ID."

Cause:

This happens when before cloning proper cleanup is not done.
Duplicate value is repeated multiple times in "REPORTS_CLASSPATH" and "REPORTS_PATH" because of multiple re-installations of "Oracle Developer Suite" in the same "ORACLE_HOME" without proper cleanup before the subsequent clone.

Solution:

1) Open regedit in Windows

2) Navigate HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_<instancename>__TOOLS

and remove duplicate values for "REPORTS_CLASSPATH" and "REPORTS_PATH".

3) Retest the report.



No comments :

Post a Comment

Query to Find High Water Mark for a Given Table/All Table in Oracle

No comments

Query to Find High Water Mark for a Given Table/All Table in Oracle


Script:

Please note 
  • The first parameter you need to pass as a single Table name or ALL for all tables in the schema 
  • The second Parameter would be passed as Owner.

SET SERVEROUTPUT ON
SET VERIFY OFF

DECLARE
  CURSOR cu_tables IS
    SELECT a.owner,
           a.table_name
    FROM   dba_tables a
    WHERE  a.table_name = Decode(Upper('&&Table_Name'),'ALL',a.table_name,Upper('&&Table_Name'))
    AND    a.owner      = Upper('&&Table_Owner') 
    AND    a.partitioned='NO'
    AND    a.logging='YES'
order by table_name;


  op1  NUMBER;
  op2  NUMBER;
  op3  NUMBER;
  op4  NUMBER;
  op5  NUMBER;
  op6  NUMBER;
  op7  NUMBER;
BEGIN

  Dbms_Output.Disable;
  Dbms_Output.Enable(1000000);
  Dbms_Output.Put_Line('TABLE                             UNUSED BLOCKS     TOTAL BLOCKS  HIGH WATER MARK');
  Dbms_Output.Put_Line('------------------------------  ---------------  ---------------  ---------------');
  FOR cur_rec IN cu_tables LOOP
    Dbms_Space.Unused_Space(cur_rec.owner,cur_rec.table_name,'TABLE',op1,op2,op3,op4,op5,op6,op7);
    Dbms_Output.Put_Line(RPad(cur_rec.table_name,30,' ') ||
                         LPad(op3,15,' ')                ||
                         LPad(op1,15,' ')                ||
                         LPad(Trunc(op1-op3-1),15,' ')); 
  END LOOP;

END;
/

SET VERIFY ON

No comments :

Post a Comment

Query to shrink Datafiles and Reclaim unused Space in Oracle

No comments

 Query to shrink Datafiles and Reclaim unused Space in Oracle


Steps to Shrink the datafiles

set verify off
set pages 1000
column file_name format a50 word_wrapped
column smallest format 999,990 heading "Smallest|Size|Poss."
column currsize format 999,990 heading "Current|Size"
column savings  format 999,990 heading "Poss.|Savings"
break on report

Step1: To Check Database block size

column value new_val blksize
select value from v$parameter where name = 'db_block_size';


Step2: Check how much space can be reclaimed 

select file_name,
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest,
       ceil( blocks*&&blksize/1024/1024) currsize,
       ceil( blocks*&&blksize/1024/1024) -
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings
from dba_data_files a,
     ( select file_id, max(block_id+blocks-1) hwm
         from dba_extents
        group by file_id ) b
where a.file_id = b.file_id(+);

You can also add condition if needs to be checked for a specific tablespace

Step3: Script to reclaim unused space from the datafiles 

set pages 0
set lines 300
column cmd format a300 word_wrapped

select 'alter database datafile '''||file_name||''' resize ' ||
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 )  || 'm;' cmd
from dba_data_files a, 
     ( select file_id, max(block_id+blocks-1) hwm
         from dba_extents
        group by file_id ) b
where a.file_id = b.file_id(+) 
  and ceil( blocks*&&blksize/1024/1024) -
      ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0;

No comments :

Post a Comment

Query to find Oracle Process consuming most of Memory and CPU

No comments

Query to find Oracle Process consuming most of the Memory and CPU


Session consuming the most memory

SELECT a.username, a.osuser, a.program, b.spid,b.pga_used_mem, a.sid, a.serial# ,a.module,a.logon_time,a.terminal FROM v$session a, v$process b WHERE a.paddr = b.addr
order by
b.pga_used_mem desc


Session Consuming Most Memory

select 
   ss.username,
   se.SID,
   VALUE/100 cpu_usage_seconds
from
   v$session ss, 
   v$sesstat se, 
   v$statname sn
where
   se.STATISTIC# = sn.STATISTIC#
and
   NAME like '%CPU used by this session%'
and
   se.SID = ss.SID
and 
   ss.status='ACTIVE'
and 
   ss.username is not null

No comments :

Post a Comment

How to identify a filesystem type in Linux System

No comments

 How to identify a filesystem type in Linux System



There are multiple ways to determine the file system type in a Linux Based Environment

1) df -Th

for this to work the filesystem should be mounted

2) fsck -N /dev/device

Example: 
fsck -N /dev/sdb2

3) lsblk -f

Displays the block device with filesystem type details

4) mount |grep -i "device"

Example:
mount| grep -i "sdb2"

5) blkid /dev/device

Example:
blkid /dev/sdb2

6) cat /etc/fstab

This would only work if the filesystem is updated in fstab.

No comments :

Post a Comment

How to perform Oracle 11g Data Guard Switchover and Switchback

No comments

 How to perform Oracle 11g Data Guard Switchover and Switchback 


Switchover:


Before performing switchover, please  verify the state of the data guard on both the instances by following SQL queries:


 SQL> ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

 SQL> SELECT sequence#, first_time, next_time, applied

 FROM v$archived_log

 ORDER BY sequence#;


 

 SQL> select dest_name,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2';

 DEST_NAME

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

 STATUS ERROR

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

 LOG_ARCHIVE_DEST_2

 VALID


 SQL> select message from v$dataguard_status;


Note: This command will give you an appropriate message about the data guard current status.


Kick-Off switchover activity by issuing the following  commands:


On Primary database:


Step-1

Connect to Primary database and convert primary database to standby.


 [oracle@funoracle ~]$ sqlplus / as sysdba

 SQL> alter database commit to switchover to standby;

 Database altered.


Step-2

Shutdown primary database:


SQL> shutdown immediate;


Step-3


Startup nomount old primary database as new standby database:


 SQL> startup nomount

 ORACLE instance started.

 

 

 SQL> alter database mount standby database;

 Database altered.

 SQL> alter database recover managed standby database disconnect from session;

 Database altered.


Verify database role on old primary database:


 SQL> select name,open_mode,database_role from v$database;

 NAME OPEN_MODE DATABASE_ROLE

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

 PROD MOUNTED PHYSICAL STANDBY

 


On Standby database:


Step-4

On the original standby database, Convert the old standby database to the primary database:

 SQL> alter database commit to switchover to primary;

 Database altered.


Step-5


Convert old standby database as primary and shutdown database:


[oracle@funoracledr ~]$ sqlplus / as sysdba


 SQL> shutdown immediate;

 ORA-01109: database not open

 Database dismounted.

 ORACLE instance shut down.


Step-6


Startup old standby database as the primary database:


 SQL> startup

 ORACLE instance started.

 

Verify database role on old standby database:


 SQL> select name,open_mode,database_role from v$database;

 NAME OPEN_MODE DATABASE_ROLE

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

 PROD READ WRITE PRIMARY


Switch overactivity have completed successfully, our old primary database has become standby and old standby database has become the primary database.


Note

We can test the above switchover activity, by generating multiple archive logs on the primary database and verify those archive logs being transferred on the standby database.


Switchback:

To switchback, we  have to follow the same above-mentioned steps

No comments :

Post a Comment

Cron to Schedule a Script on Last Day of Month

No comments

 Cron to Schedule a Script on Last Day of Month


00 01 28-31 * * [ "$(date +%d -d tomorrow)" = "01" ] && /script.sh


At 01:00 on every day-of-month from 28 through 31


00--> Minutes when you want to run
01--> Hour when the job needs to be executed
28-31--> 28,28,29 and 31’st of each month
*--> All month of year
*-->All day of week
/script.sh--> Script name which needs to be executed
[ "$(date +%d -d tomorrow)" = "01" ]--> Logic which will test if next date is 01


No comments :

Post a Comment

Query to find Plan Hash Values for a SQLID in Oracle

No comments

 Query to find Plan Hash Values for a SQLID in Oracle


SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat dhs,
    (
    SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap
    FROM dba_hist_snapshot ss
    WHERE ss.begin_interval_time BETWEEN (SYSDATE - &No_Days) AND SYSDATE
    ) s
WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap
  AND dhs.sql_id IN ( '&SQLID')

No comments :

Post a Comment

How to get Oracle SQL output in HTML format and send as a Mail Body

No comments

 How to get Oracle SQL output in HTML format and send as a Mail Body 


SQL Script to get the output as HTML

SET MARKUP HTML ON SPOOL ON
set termout off
set pages 999
set pagesize 999
set feedback off
SET MARKUP HTML ON TABLE "class=sysaud cellspacing=2 border='2' width='95%' align='center' " ENTMAP OFF

spool fnd_debug_report.html

set pagesize 1000
set pause off
set linesize 150

prompt
prompt FND Debug Profile Enabled Report 
prompt
prompt

/* Below can be any query based on your requirement*/

SELECT upper(sys_context('USERENV','DB_NAME')) "DB_NAME",fpot.user_profile_option_name NAME,
         DECODE (fpov.level_id,
                 10001, 'Site',
                 10002, 'Application',
                 10003, 'Responsibility',
                 10004, 'User',
                 10005, 'Server',
                 'UnDef')
            LEVEL_SET,
         DECODE (TO_CHAR (fpov.level_id),
                 '10001', '',
                 '10002', fap.application_short_name,
                 '10003', frsp.responsibility_key,
                 '10005', fnod.node_name,
                 '10006', hou.name,
                 '10004', fu.user_name,
                 'UnDef')
            "CONTEXT_NAME",
         fpov.profile_option_value VALUE
    FROM apps.fnd_profile_options fpo,
         apps.fnd_profile_option_values fpov,
         apps.fnd_profile_options_tl fpot,
         apps.fnd_user fu,
         apps.fnd_application fap,
         apps.fnd_responsibility frsp,
         apps.fnd_nodes fnod,
         apps.hr_operating_units hou
   WHERE     fpo.profile_option_id = fpov.profile_option_id(+)
         AND fpo.profile_option_name = fpot.profile_option_name
         AND fu.user_id(+) = fpov.level_value
         AND frsp.application_id(+) = fpov.level_value_application_id
         AND frsp.responsibility_id(+) = fpov.level_value
         AND fap.application_id(+) = fpov.level_value
         AND fnod.node_id(+) = fpov.level_value
         AND hou.organization_id(+) = fpov.level_value
                and fpot.language='US'
          and fpot.user_profile_option_name like 'FND: Debug Log Enabled%'
          and fpov.profile_option_value='Y';



spool off
exit

Example:




Sample script to send this as a mail body

. ~/.bash_profile
Inst_name=`echo $TWO_TASK|tr [a-z] [A-Z]`
Mail_id=himanshu@dummy.com
output_report=$HOME/scripts/fnd_debug_report.html
export content=${output_report}
export subject="FND Debug Profile is enabled in ${Inst_name}"
rm -f ${output_report}
cd $HOME/scripts
sqlplus $APPSLOGIN @fnd_debug.sql


if grep --quiet 'Log' $HOME/scripts/fnd_debug_report.html;
then
echo "Sending email"

(
echo "Subject: $subject"
echo "To: $Mail_id"
echo "MIME-version: 1.0"
echo "content-Type: text/html"
echo "content-Disposition: inline"
cat $content
) | sendmail -t
fi

No comments :

Post a Comment

sendmail errors: Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF (HP UX)

No comments

 sendmail errors: Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF (HP UX)


Error:

While checking the mailq below messages are being seen.

                /var/spool/mqueue (25 requests)
-----Q-ID----- --Size-- -----Q-Time----- ------------Sender/Recipient-----------
084Fe2V7000352*     229 Fri Sep  4 23:40 root
                                         root
084FZ0EN019660      229 Fri Sep  4 23:35 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084FU0lB009058      229 Fri Sep  4 23:30 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084FP5de028755      229 Fri Sep  4 23:25 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084FKhx8023818      229 Fri Sep  4 23:20 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084Et10R002008*     229 Fri Sep  4 22:55 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084Ej2ib011301      229 Fri Sep  4 22:45 root
                 (Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF)
                                         root
084FF1pO014533      229 Fri Sep  4 23:15 root


Solution:

/var/mail didn't exist 
/var/mail needs to be created and bin:mail ownership and 775 permissions

Also, check that no lock file present.

Check for /var/mail/*.lock and if present please remove.

Start and stop Sendmail services.

/sbin/init.d/sendmail stop
/sbin/init.d/sendmail start

No comments :

Post a Comment

FNDCPASS error in R12 - Error in password verification for APPS

No comments

FNDCPASS error in R12 - Error in password verification for APPS


Issue:


While changing password using FNDCPASS getting below error.


+----------------------------------------------------------------------------+

Working...

Error in password verification for APPS


+---------------------------------------------------------------------------+

Concurrent request completed


Solution:


SQL> show parameter case


NAME                                 TYPE        VALUE

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

sec_case_sensitive_logon             boolean     TRUE


SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.


Re-try FNDCPASS now

No comments :

Post a Comment

RMAN-12012: multiple records for DISK parallelism found in catalog

No comments

 RMAN-12012: multiple records for DISK parallelism found in catalog

Error:

While running RMAN backup getting below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12010: automatic channel allocation initialization failed
RMAN-12012: multiple records for DISK parallelism found in catalog


Solution:

Connect to sqlplus as sysdba and run below

 exec dbms_backup_restore.resetconfig;

Re-run Rman backup

No comments :

Post a Comment

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

No comments

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory


While starting apache in Oracle Apps R12, below error is encountered.

Error:


--------

20/08/29 06:35:31 Start process

--------

/bispapps/apps122/Apps/inst/apps/VIS_ebsvis/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

/bispapps/apps122/Apps/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory


Cause: 

The library was missing.


Solution:


1. Shut down all Oracle Application Services.

2. As the LINUX root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Startup all Oracle Application Services.


No comments :

Post a Comment

How to Install Mac OS on Virtual Box

No comments

 How to Install Mac OS on Virtual Box





Download MAC Catalina OS ISO by clicking below image


Before starting the VM, open the VM settings and make the following changes:


System > Processor > Processor(s) is 2 or more.

System > Acceleration > uncheck Enable Nested Paging.

Display > Screen > Video Memory is 128MB.

USB > USB 3.0 Controller.



Command before starting the Virtual Machine



Open terminal and run below

cd /usr/bin/ (For Windows user go to "C:\Program Files\Oracle\VirtualBox\" from command prompt)

VBoxManage modifyvm "MacOS" --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemProduct" "iMacOS11,3"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemVersion" "1.0"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiBoardProduct" "Iloveapple"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/DeviceKey" "ourhardworkbythesewordsguardedpleasedontsteal(c)AppleComputerInc"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/GetKeyFromRealSMC" 1

VBoxManage setextradata "MacOS" VBoxInternal2/EfiGraphicsResolution 1920x1020


Start the Virtual Machine and follow the GUI.

No comments :

Post a Comment

How to Create macOS Catalina ISO File

3 comments

 How to Create macOS Catalina ISO File



Please note these steps need to be performed on a Apple Mac System to generate an iso.

Steps:

1) Download macOS Catalina From App Store or Apple download

2) Please note once you download it will be in dmg format.

3) Open Terminal in MAC. from the top-right corner open up Spotlight. Type in Terminal and hit Enter.

4) Mount it to your macOS

hdiutil attach /tmp/Catalina.dmg -noverify -mountpoint /Volumes/Catalina

5) Create macOS Catalina Installer

sudo /Applications/Install\ macOS\ Catalina.app/Contents/Resources/createinstallmedia --volume /Volumes/Catalina --nointeraction

6) Unmount Catalina Disk

hdiutil detach /volumes/Install\ macOS\ Catalina

7) Convert the DMG file to an ISO file

hdiutil convert /tmp/Catalina.dmg -format UDTO -o ~/Desktop/Catalina.cdr

8) Rename and Move to Desktop

mv ~/Desktop/Catalina.cdr ~/Desktop/Catalina.iso


Now we can use this iso on any system and install on virtual machines.





3 comments :

Post a Comment

Query to find the profile assigned to a Responsibility in Oracle Apps

No comments

 Query to find the profile assigned to a Responsibility in Oracle Apps


Query:

select distinct * from (SELECT  b.user_profile_option_name "Long Name" ,
  a.profile_option_name "Short Name" ,
  NVL(g.responsibility_name,c.level_value)  "Level Value" ,
  c.PROFILE_OPTION_VALUE "Profile Value"
FROM apps.fnd_profile_options a ,
  apps.FND_PROFILE_OPTIONS_tL b ,
  apps.FND_PROFILE_OPTION_VALUES c ,
  apps.FND_USER d ,
  apps.FND_USER e ,
  apps.FND_RESPONSIBILITY_tL g ,
  apps.FND_APPLICATION h
WHERE 1                   =1
AND a.profile_option_name = b.profile_option_name
AND a.profile_option_id   = c.profile_option_id
AND a.application_id      = c.application_id
AND c.last_updated_by     = d.user_id (+)
AND c.level_value         = e.user_id (+)
AND c.level_value         = g.responsibility_id (+)
AND c.level_value         = h.application_id (+)
  --
AND c.level_id            = 10003
and b.language='US'
AND g.responsibility_name = '%&Responsibility Name%'
ORDER BY b.user_profile_option_name,  c.level_id
);

No comments :

Post a Comment

Download Oracle EBS Software|R12.2.0|Oracle E-Business Suite

No comments

Download Oracle EBS Software|R12.2.0|Oracle E-Business Suite

No comments :

Post a Comment

CentOS Installation on Virtual Box|CentOS 7|Oracle Virtual Box

No comments

No comments :

Post a Comment

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

No comments

 APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM


Error:


APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.


Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)

Routine AFPEOT cannot construct the name of an executable file for your concurrent request 122917706.


Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager


Cause:

Custom Top is registered and not set in the ENV while starting the concurrent services.


Query to Check whether the Env is set for the Particular Concurrent Request :


select variable_name,value from fnd_env_context e ,fnd_concurrent_processes p ,fnd_concurrent_requests r where p.concurrent_process_id =
e.concurrent_process_id and p.concurrent_process_id = r.controlling_manager and e.variable_name like '%CUSTOM_TOP%' and r.request_id = &request_id;

Solution :


Add the respective Top in env file

$APPL_TOP/admin/adovars.env

or 

Setup custom  environment file.

Restart concurrent managers.

No comments :

Post a Comment

Oracle Virtual Box Installation on Windows

No comments

 

No comments :

Post a Comment

ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:

No comments

 ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments


Error :

After DB upgrade , as part of R12 dbtier post-installation procedure, required to run adstats.sql and getting the following error

declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 25335
ORA-06512: at "SYS.DBMS_STATS", line 25877
ORA-06512: at line 3
ORA-06512: at line 33

Cause:

ORA_NLS10 variable not set.

Solution :

1. Make sure that $ORACLE_HOME/nls/data/old/cr9idata.pl executed to create $ORACLE_HOME/nls/data/9idata as per Database upgrading notes.

2. Make sure that the ORA_NLS10 environment variable is set to the full path of the nls/data/9idata directory:

echo $ORA_NLS10
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

3- If the instance was not started with ORA_NLS10 set correctly restart it.

4- Retest the issue by running adstats.sql again as it should run successfully now.

No comments :

Post a Comment

How to setup UDEV instead of ASM libraries for ASM on Linux

No comments

How to setup UDEV instead of ASM libraries for ASM on Linux


In this post I am going to share how to use UDEV on Linux server for ASM disk in place for ASMlib.
It will help to directly allot the raw disk to your asm disk group.It can be used in Red Hat, Oracle, Centos Linux variants using UDEV.

Udev is the mechanism used to create and name /dev device nodes corresponding to the devices that are present in the system. Udev uses matching information provided by sysfs with rules provided by the user to dynamically add the required device nodes.

Steps to use udev for ASM

1. Attach a raw disk to the server.

2. Use lsblk or fdiks -l command to find the new added disk names.

example:

/dev/sdg
/dev/sde
/dev/sdf
/dev/sdc
/dev/sdd

3. Find the ID_Serial for each associated disk, if we directly use the disk name it might get chnaged after the server reboot.

udevadm info --query=property /dev/sdg
udevadm info --query=property /dev/sde
udevadm info --query=property /dev/sdf
udevadm info --query=property /dev/sdc
udevadm info --query=property /dev/sdd

4. Go to cd /etc/udev/rules.d directory and add the new disk details in file 99-oracle-asmdevices.rules as below. Make sure to update ID_SERIAL with your correct value and disk owner and group should be correct based on the env. Also I will give a virtual name/symbolink for eash disk as oraasm01/02/03 etc.


ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c297a90d6a9681b1d2a5a1b88568"", GROUP=""dba"", SYMLINK+=""oraasm01"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c29906aa418e9822a0947ce9ad22"", GROUP=""dba"", SYMLINK+=""oraasm02"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c291823fef46b990dbc1fe7bebdf"", GROUP=""dba"", SYMLINK+=""oraasm03"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c2944397980b1b7f91a3d0c99e56"", GROUP=""dba"", SYMLINK+=""oraasm04"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c2954d200a2927a1e815945e603d"", GROUP=""dba"", SYMLINK+=""oraasm05"" OWNER=""oraasm"", MODE=""0660"""


5. Reload the udev rules to identify the new disks.

udevadm control --reload-rules
udevadm trigger --type=devices --action=change


Note:
# #OL5
# /sbin/udevcontrol reload_rules

# #OL6 and OL7
# udevadm control --reload-rules

# #OL5 and OL6 : Not needed for OL7
# /sbin/start_udev

6. Verify the disk permissions and permissions

ls -l /dev/oraasm05
ls -l /dev/oraasm03
ls -l /dev/oraasm04
ls -l /dev/oraasm01
ls -l /dev/oraasm02

7. Make sure the ASM disk string should be set as  asm_diskstring='/dev/ora*' to identify the disks.

8. Attach the new disks to the diskgroup in asm now.



Example:

SQL> set pages 40000 lines 120
col PATH for a30
select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;
SQL> 
DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH
----------- ------- ------------ ------- -------- ------------------------------
          4 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm05
          2 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm03
          3 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm04
          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm01
          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm02

No comments :

Post a Comment