-
Nazim wrote a new post, 12c db RAC installation on Linux 5.9 x86-64 6 years, 10 months ago
Oracle Database 12c Release 1 (12.1) RAC On RedHat Linux 5
Pre-requisites :Before you install the Grid,Clusterware and the Database, you must complete several pre-installation tasks.
1) 2 Public IP’s – […]
-
Nazim wrote a new post, Error: Session expired. Run emcli login to establish a session. 6 years, 11 months ago
Release : Oracle EM 12c Release 4 (12.1.0.4)
Problem :
Running emcli setup command gives session expired error message.
for e.g :!–more–
[oraemagent@progcsrv01 ~]$ emcli setup […] -
Nazim wrote a new post, How to change web-logic password if it is lost or forgotten in EBS 12.2.x 7 years, 1 month ago
We have tried changing weblogic password from command line considering the password is lost or forgotten Oracle EBS R12(12.2.x)!–more–
Actions to be taken :
Shut down all running services (adstpall.sh), […]
-
-
Nazim wrote a new post, Installation & Configuration of Oracle OID,OIM,OAM. 7 years, 6 months ago
-
My apologies for the late reply. I have other document where I have integrated OID/OAM with EBS.
http://www.onlinedbasupport.com/2014/12/24/integrating-11g-oracle-identity-access-management-with-oracle-ebs-12-1-1/ -
Thanks!!!
-
-
Shakeeb Petkar wrote a new post, Checking tablespace size 7 years, 8 months ago
The following query helps us to check the total size and free space of individual tablespaces in a tabular format
set linesize 1200
set pagesize 1200
column tablespace_name format a20 heading […] -
Rishi Sarode wrote a new post, Create database link 7 years, 8 months ago
Database Link
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another.
The following link types are supported:
Private database link- belongs to a specific schema of a database. Only the owner of a private database link can use it.
Public database link- all users in the database can use it.
Global database link- defined in an OID or Oracle Names Server. Anyone on the network can use it.What is a database link?
A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. A database link connection allows local users to access data on a remote database.
Prerequisites:
To create a database link, you must have the CREATE DATABASE LINK system privilege. Also, you must have the CREATE SESSION system privilege on the remote Oracle database.
In the following example:
There are two databases: DEV and PORTAL
We are creating a db link on DEV so that we can acces the tables of portal user from DEV database.Make TNS Entries on both databases
dev =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.1.106)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dev)
)
)Portal_New =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.1.115)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = portal)
)
)Check TNS on both databases
From portal database
C:Documents and SettingsAdministrator>tnsping devTNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 – Production on 16-SEP-2
014 23:20:52Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:oracle11gproduct11.1.0db_1networkadminsqlnet.oraUsed TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.254.
0.206) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dev))
)
OK (10 msec)From dev database
oratst#tnsping portal_newTNS Ping Utility for HPUX: Version 10.2.0.3.0 – Production on 17-SEP-2014 12:45:30
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
/Clone/db03/oracle/10R2/network/admin/DEV_oratst/sqlnet_ifile.oraUsed TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.115) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = portal)))
OK (110 msec)connect to dev database from apps user:
sqlplus apps/appsCreating a Private Database Link:
create database link db link name connect to username identified by “password” using ‘tns name’;
In the following statement, user portal on the remote database defines a fixed-user database link named Portal_New to the portal schema on the local database:
create database link DEVTOPORTAL.192.168.1.106 connect to portal identified by "portal123" using 'Portal_New';
Once this database link is created, you can query tables in the schema PORTAL on the remote database in this manner:
SELECT * FROM portal.emp@DEVTOPORTAL.192.168.1.106;
How to check DB link:
select * from dba_db_links;OWNER DB_LINK USERNAME HOST CREATED
APPS devtoportal.192.168.1.106 PORTAL portal_new 29-APR-14TESTING:
SQL> select * from dual@”devtoportal.192.168.1.106";D
-
X
For dropping a database link.
drop database link;
drop database link DEVTOPORTAL.192.168.1.106;
-
Shakeeb Petkar wrote a new post, Solving blocking sessions 7 years, 8 months ago
Cause:
Blocking sessions occur when one session holds an exclusive lock on an object and doesn’t release it before another session wants to update the same data. This will block the second until the first one has done its work.
From the view of the user it will look like the application completely hangs while waiting for the first session to release its lock. You will often have to identify these sessions in order to improve your application performance to avoid as many blocking sessions as possible.
Solution:
The following query shows all the blocking sessions which can help you to identify the problem.
col WAIT_CLASS for a12;
select blocking_session,sid,serial#,wait_class,seconds_in_wait,status from v$session where blocking_session is not NULL order by blocking_session;BLOCKING_SESSION SID SERIAL# WAIT_CLASS SECONDS_IN_WAIT STATUS
—————- ———- ———- ———— ————— ——–
5290 5527 590 Application 2146 ACTIVE
5438 5024 5728 Application 118 ACTIVE
5438 5369 4674 Application 2025 ACTIVE
5438 5251 2139 Application 2072 ACTIVE
5499 5438 2805 Application 2073 ACTIVE
5508 5901 4208 Application 6468 ACTIVE
5898 5290 4533 Application 2149 ACTIVE
5901 5019 11812 Application 5163 ACTIVE
5901 5135 1236 Application 6045 ACTIVE
5901 4934 1797 Application 792 ACTIVE
5901 5947 583 Application 1985 ACTIVE
5901 5204 4373 Application 241 ACTIVE
5901 5751 2989 Application 2171 ACTIVE
5901 5752 3331 Application 3641 ACTIVE
5993 5646 544 Commit 0 ACTIVE
5993 5486 3187 Commit 0 ACTIVE16 rows selected.
In this case, we find that session 5901 is blocking 7 other sessions.
select sid,serial#,event,module,action,status,program,blocking_session,last_call_et from v$session where sid=&sid;
Enter value for sid: 5901SID SERIAL# EVENT MODULE ACTION STATUS PROGRAM BLOCKING SESSION LAST_CALL_ET
———————————————————————————–
5901 4208 enq: TX – row lock contention WSHINTERFACE Concurrent Request ACTIVE 5508 6493From the above query we find that session 5901 is being blocked by session 5508.
select sid,serial#,event,module,action,status,program,blocking_session,last_call_et from v$session where sid=&sid;
Enter value for sid: 5508SID SERIAL#
———- ———-
EVENT
—————————————————————-
MODULE
————————————————
ACTION STATUS
——————————– ——–
PROGRAM BLOCKING_SESSION LAST_CALL_ET
———————————————— —————- ————
5508 7300
SQL*Net message from client
OEXOETEL
FRM:CLIMAM:Receiptionist Parts – INACTIVE
7554From the above query we find that session 5508 has become inactive.
In this case, we find that session 5901 is blocking 7 other sessions which in turn has been blocked by session 5508 and has been for 7554 seconds.
So, we kill this inactive session.
To kill the session from within Oracle, the sid and serial# values of the relevant session can then be substituted into the following statement:SQL> alter system kill session ‘sid,serial#’;
alter system kill session'5508,7300';System altered.
This command tells the specified session to rollback any un-committed changes and release any acquired resources before terminating cleanly. In some situations, this cleanup processing may take a considerable amount of time, in which case the session status is set to “marked for kill” until the process is complete and not killed immediately, the alter system kill session command can be forced by adding the immediate keyword:
SQL> alter system kill session ‘sid,serial#’ immediate;
-
Shakeeb Petkar wrote a new post, How to find Blocking sessions. 7 years, 8 months ago
Cause
Blocking sessions occur when one sessions holds an exclusive lock on an object and doesn’t release it before another sessions wants to update the same data. This will block the second until the first one has done its work.Please execute the below query to find the blocking sessions and kill if necessary.
Solution
col WAIT_CLASS for a12;
select blocking_session,
sid,
serial#,
wait_class,
seconds_in_wait,status
from
v$session
where
blocking_session is not NULL
order by
blocking_session;
-
Nazim wrote a new post, Unable to start managed servers in OAM Error : IAMSuiteAgent Not Specified 7 years, 9 months ago
We have installed OID & OAM with same version 11.1.1.7. Starting managed service in OAM domain was giving error, when we checked the logs it was giving below information
Caused By: […] -
Nazim wrote a new post, Patching and Management in Oracle EBS 12.2 8 years, 1 month ago
The most important new feature in Oracle E-Business Suite Release 12.2 is the ability to patch a running system, instead of having to take the system down for a significant period of time while the patches are […]
-
Nazim wrote a new post, Log Files & Environment Settings in Oracle EBS 12.2 8 years, 1 month ago
Oracle E-Business Suite Release 12.2 has seen significant changes to the locations under which log files are stored. In large part, this is because of the introduction of online patching and the additional file […]
-
Nazim wrote a new post, Oracle EBS 12.2.0 Architecture & Components 8 years, 1 month ago
-
Patch is always applied on a patch file system.
Steps to apply the patch
1) Source the run file system environment
2) adop phase=prepare
3) adop phase=apply patches=patch_num
4) adop phase=finalize
5) adop phase=cutover
6) adop phase=cleanupUntil step 4 all the changes will be done to the patch file system, when cutover happens it will make patch file system as run file system and vice-versa.
I hope I have explained your questions.
-
-
Nazim wrote a new post, Installing 12.2.0 on Linux x86-64 (5.8) 8 years, 2 months ago
-
Nazim wrote a new post, EM12c Agent deployment fails on Windows x64 2008 8 years, 3 months ago
We have Oracle EBS running on a Windows 2008R2 64 bit machine and Oracle EM12c running on a Linux (RHEL 6.3) machine.
We are trying to deploy an agent on our Windows box however it fails with the below error […] -
Nazim wrote a new post, Using Oracle EBS 12.1.1 with 11gr2 Database 8 years, 5 months ago
Upgrading Oracle Application database to 11.2.0.3 with EBS R12(12.1.1)
Application version : 12.1.1
Database Current Version : 11.1.0.7
Database Name : TEST
Operating System : Red Hat Enterprise Linux 5 (64 […]
-
Archives
- June 2015
- April 2015
- December 2014
- November 2014
- September 2014
- August 2014
- April 2014
- March 2014
- February 2014
- November 2013
- September 2013
- August 2013
- June 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- August 2012
- July 2012
- May 2012
- January 2012
- December 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- February 2011
- January 2011
- December 2010
- August 2010
- June 2010
-
Calendar
May 2022 M T W T F S S « Jun 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 -
Meta