Techgoeasy @techgoeasy - Tumblr Blog

Top Oracle Data guard queries

Here are some of the Top Oracle data guard queries How to check the archive log sequence on Primary Side SELECT THREAD# "Thread",SEQUENCE# "Last Sequence Generated" FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1; How to check the archive log sequence apply status on Standby Side SELECT ARCH.THREAD# "Thread",…

View On WordPress

FND_FILE in oracle apps

FND_FILE is the standard API provided by Oracle Apps. Package FND_FILE contains routines that allow as concurrent programs to write to the request log and output files, stored under /log and /out.The FND_FILE.PUT_LINE() calls use the UTL_FILE package to write the line to a temporary file in the $APPLPTMP directory.Text written by the stored procedures is first kept in temporary files on the…

View On WordPress

How to check RMAN backup details in the sql

We can check RMAN backup details in the sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in…

View On WordPress

How to change apps password in R12.2

We need to follow few steps while changing the apps password in R12.2. They are given as below (1) Shutdown the apps cd $ADMIN_SCRIPTS_HOME./adstpall.sh apps/<apps pass> -mode=allnode (2)Kill any remaining process (3) Change the apps Password FNDCPASS apps/<old pass> 0 y system/ SYSTEM APPLSYS <new pass> (4) Started weblogic server before running autoconfig to change the…

View On WordPress

How To Determine Which File System is the Run or Patch File System in R12.2

Oracle Apps R12.2 has two filesytem to enable online patching. We can determine Which File System is the Run or Patch File System by either looking at the file_edition_type in the Context file or by doing the backend query using sql Using context file on the filesystem or Sourcing the env if you know the location of context file,Look for the file_edition_type in the CONTEXT_FILE grep…

View On WordPress

How to drop the oracle database

This post, we will discuss how to drop the oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdbastartup mount (If database not started)create pfile='/tmp/pfile.ora' from spfile; Now follow the below procedure to drop the database Source the environment $.…

View On WordPress

How To Restore TDE Wallet Files From Backup in Oracle Database

Sometimes, we may have done some mistake and we are facing issues with TDE. If you have good backup of the wallet then we can go back to the backup file.There are two files pertaining to TDEewallet.p12 – This is the actual wallet filecwallet.sso – This is the autologin wallet To restore the wallet from one of the backup files do the following: 1.rename the current wallet file to have it for…

View On WordPress

How to run Autoconfig on Patch system in R12.2

We sometimes need to run Autoconfig on Patch system in R12.2 in the current edition only. But if you to try connect Database from patch filesystem, you will get below error $ sqlplus apps/apps SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jan 2 14:17:46 2019 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-20099: E-Business…

View On WordPress

DBCLI commands for DBCS and Bare Metals in OCI

What is DBCLI It is a command line interface available on bare metal and virtual machine DB systems.The database CLI commands must be run as the root userdbcli is in the /opt/oracle/dcs/bin/ directory.Oracle Database maintains logs of the dbcli command output in the dcscli.log and dcs-agent.log files in the /opt/oracle/dcs/log/ directory. How Check CLI and update it [root@host opc]# rpm -qa…

View On WordPress

What is PLSQL Variables

Oracle PLSQL Variable 1) Variables and constants must be declared for use in procedural and SQL code, although the datatypes available in SQL are only a subset of those available in PL/SQL. 2) All variables and constants must be declared before they are referenced. 3) Remember that each variable must be declared on a separate line and multiple variables cannot be defined in the same…

View On WordPress

How to resolve Network Error: Software Caused Connection Abort

We often get “Network Error: Software Caused Connection Abort” when the connection is idle for some time to the server. This happens because some network firewall terminate the connection if no data is send through the network through either direction after some time This issue can be very irritating as you have to login to server again and again. In this post we will learn how we can avoid this…

View On WordPress

How to convert private key to ppk

Many times , you get the private key from the cloud provider to connect to the Virtual machine. If you directly try to use that key with Putty to connect to VM machine , you will get failure. we need to convert the private key into ppk format which is supported by Putty Tool. Here in this article we will see how to convert into ppk format using puttygen tool Step 1 First save the private key on…

View On WordPress

how to import schema in oracle using impdp

we often have a situation where we need to move the schema from Prod to DEV or from test to another. We will discuss how to import schemas in Oracle database using impdp in these situation How to import schema in Oracle 1. First of all we should take the dump of the schema or full database of the source database depending on the requirement. Lets HR is the schema. then below command can be…

View On WordPress

EBS PDB service name disappear from listener in 19c

Upgrade to 19c Oracle database with EBS created a new service EBS_<PDB>. And all the connection from apps goes through that service. It is seen that this service disappear on server reboot and database reboot. $ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-APR-2020 16:32:48 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to…

View On WordPress

how to download oracle e-business suite 12.2 software

In this post, we will be checking how to download oracle e-business suite 12.2 from Oracle site. You will be able to download R12.2.0 Base version and further patch sets like R12.2.2 to R12.2.10 with the help of this. 1.Go to edelivery site Access: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery 2. Login with My Oracle Support credentials. 3. Read and accept the download policy. 4.…

View On WordPress

How to create table as select in oracle

oracle create table as select A table can be created from an existing table in the database using a sub query option.The table is created with specified column names and rows retrieved by the select statement are inserted into the tableif the table column specification is not given, table is created with the same column as given in sub queryThe below Oracle create table as select script creates…

View On WordPress

How to find weblogic version in Unix & Windows

There are various ways to find the weblogic version. Here I will be giving the steps for all versions of Weblogic in Unix & windows with command line ADMIN CONSOLE The lower left-hand corner of the WebLogic admin console will print out the version This will work for all weblogic verions WebLogic admin server standard out log file You can check the WebLogic admin server standard out log file…

View On WordPress

Trending Blogs

Recently Viewed Blogs

Techgoeasy