Archive for the ‘Linux OS’ Category

Oracle 12.2 is Now Available on E-delivery

November 13th, 2017, posted in Linux OS, Oracle
Share

Oracle Just Announced the availability of Oracle database 12cR2 Exadata/SuperCluster On their website, In Case you want to upgrade

You can download oracle Enterprise edition 12cR2 from Oracle E delivery
 Here 

Follow the steps :-

Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle 12.2 is Now Available on E-delivery,Oracle 12.2, Now Available on E-delivery,Oracle 12.2 is Now Available,E-delivery,

Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle 12.2 is Now Available on E-delivery,Oracle 12.2, Now Available on E-delivery,Oracle 12.2 is Now Available,E-delivery,

Share

Oracle Database 12c Release 2

November 12th, 2017, posted in Linux OS, Oracle
Share
Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle Database 12c Release 2 is now available for Linux, Oracle Solaris SPARC, Oracle Solaris Intel 
To Download Just access here 
Share

FRM-92102 : A Network Error Has Occured

September 19th, 2017, posted in Oracle, Solaris
Share

FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network 
2-Proxy
3-http
4-Session Time 


But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it’s gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you : 

1-Netowrk Parameters :

You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .

2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):

 

 

3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .

Sqlnet.Inbound_connection_timeout = 0

Note : if your can’t find this parameter in the SQLNET.ORA you cant add it .

5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml

 


Hope this will work 

Share

Transferring The DBC File From The Application Server

June 6th, 2017, posted in Oracle, Solaris
Share

We will now transfer the database connection file (DBC) from the application server of our EBS environment. We will transfer this to our local directory so that we can create database connections for JDeveloper so that we can run our OAF pages locally during development.


How to do it :

To transfer the .dbc file, perform the following tasks:

  1. Open WinSCP or FileZilla etc and connect to the application server.
  2. FTP the .dbc file to your local PC from the $INST_TOP/appl/fnd/12.0.0.0/secure dor you can say its path is something like this /u99/appprod52/inst32/apps/PROD_DB/appl/fnd/12.0.0/secure  directory on the application server to the jdevhome\jdev\dbc_files\secure directory as shown in the following screenshot:


    Transferring The DBC File From The Application Server,Oracle DBA,DBA,Oracle Apps,Oracle DBC
Share

Unix for DBA

May 24th, 2017, posted in Solaris
Share

Below are some of the basic unix commands which will be useful for Oracle DBA.

How to kill all similar processes with single command (in this case opmn)

ps -ef | grep opmn |grep -v grep | awk ‘{print $2}’ |xargs -i kill -9 {}

Locating Files under a particular directory

find . -print |grep -i test.sql

Using AWK in UNIX

To remove a specific column of output from a UNIX command – for example to determine the UNIX process Ids for all Oracle processes on server (second column)

ps -ef |grep -i oracle |awk ‘{ print $2 }’

Changing the standard prompt for Oracle Users

Edit the .profile for the oracle user

PS1=”`hostname`*$ORACLE_SID:$PWD>”

Display top 10 CPU consumers using the ps command

/usr/ucb/ps auxgw | head -11

Show number of active Oracle dedicated connection users for a particular ORACLE_SID

ps -ef | grep $ORACLE_SID|grep -v grep|grep -v ora_|wc -l

Display the number of CPU’s in Solaris

psrinfo -v | grep “Status of processor”|wc -l

Display the number of CPU’s in AIX

lsdev -C | grep Process|wc -l

Display RAM Memory size on Solaris

prtconf |grep -i mem

Display RAM memory size on AIX

First determine name of memory device

lsdev -C |grep mem

then assuming the name of the memory device is ‘mem0’

lsattr -El mem0

Swap space allocation and usage

Solaris : swap -s or swap -l

Aix : lsps -a

Total number of semaphores held by all instances on server

ipcs -as | awk ‘{sum += $9} END {print sum}’

View allocated RAM memory segments

ipcs -pmb

Manually deallocate shared memeory segments

ipcrm -m ‘<ID>’

Show mount points for a disk in AIX

lspv -l hdisk13

Display amount of occupied space (in KB) for a file or collection of files in a directory or sub-directory

du -ks * | sort -n| tail

Display total file space in a directory

du -ks .

Cleanup any unwanted trace files more than seven days old

find . *.trc -mtime +7 -exec rm {} \;

Locate Oracle files that contain certain strings

find . -print | xargs grep rollback

Locate recently created UNIX files (in the past one day)

find . -mtime -1 -print

Finding large files on the server (more than 100MB in size)

find . -size +102400 -print

Crontab :

To submit a task every Tuesday (day 2) at 2:45PM

45 14 2 * * /opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1

To submit a task to run every 15 minutes on weekdays (days 1-5)

15,30,45 * 1-5 * * /opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1

To submit a task to run every hour at 15 minutes past the hour on weekends (days 6 and 0)

15 * 0,6 * * opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1

Share