Create Database (DB) Link

Creating a Database Link is more simple than any thing, but mean time it is tricky too...

For an example..

You can create DB Link using the following script

create database link DB_TEST1 connect to apps
identified by "apps"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.5.212)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = tabs6101.its.ws)
)
)';

In-Case if we givethe TNS Name entry in using parameter, it will create DB Link sucssfully... But some times won't work..

So my suggestion is to go with full TNS Name description as show above..

Thanks

Tinku. 

Killing locked users

Normally we face performance issue in DB, to overcome this as a first step we need to know what are all the users kiiling the DB resource. To have sunh a user list, execute the below query..

Regards,

Tinku.

SELECT c.owner
,c.object_name
,c.object_type
,fu.user_name locking_fnd_user_name
,fl.start_time locking_fnd_user_login_time
,vs.module
,vs.machine
,vs.osuser
,vlocked.oracle_username
,vs.sid
,vp.pid
,vp.spid AS os_process
,vs.serial#
,vs.status
,vs.saddr
,vs.audsid
,vs.process
FROM fnd_logins fl
,fnd_user fu
,v$locked_object vlocked
,v$process vp
,v$session vs
,dba_objects c
WHERE vs.sid = vlocked.session_id
AND vlocked.object_id = c.object_id
AND vs.paddr = vp.addr
AND vp.spid = fl.process_spid(+)
AND vp.pid = fl.pid(+)
AND fl.user_id = fu.user_id(+)
AND c.object_name LIKE '%' || upper('&tab_name_leaveblank4all') || '%'
AND nvl(vs.status
,'XX') != 'KILLED';

Enabling Attachment Option Global Supplier Configuration

To enable the attachment functionality in iSupplier supplier registration page need to enable the profile option name called "Supplier Profile Management"