Posts Tagged ‘Oracle SQL’

Oracle Queries for checking Profile Option Values

April 19th, 2020, posted in Oracle Queries
Share
SELECTatabase, dba imam, dba immam, Imam Dba, ORA-28014: Cannot Drop Administrative Users, Oracle, Oracle DBA, oracle quries
substr(pro1.user_profile_option_name,1,35) Profile,
decode(pov.level_id,
10001,'Site',
10002,'Application',
10003,'Resp',
10004,'User') Option_Level,

decode(pov.level_id,

10001,'Site',
10002,appl.application_short_name,
10003,resp.responsibility_name,
10004,u.user_name) Level_Value,

nvl(pov.profile_option_value,'Is Null') Profile_option_Value

FROM

fnd_profile_option_values pov,
fnd_responsibility_tl resp,
fnd_application appl,
fnd_user u,
fnd_profile_options pro,
fnd_profile_options_tl pro1

WHERE

pro1.user_profile_option_name like ('%Ledger%')
and pro.profile_option_name = pro1.profile_option_name
and pro.profile_option_id = pov.profile_option_id
and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */
and pov.level_value = resp.responsibility_id (+)
and pov.level_value = appl.application_id (+)
and pov.level_value = u.user_id (+)

order by 1,2;
Share

Oracle SQL To Check Instance Clone Date

March 1st, 2020, posted in Oracle Queries
Share

Oracle Database,DBA immam,DBA imam,oracle issues,oracle database,oracle clone issues,oracle clone,oracle autoconfig,oracle autoconfig issues

 

 

 

SELECT resetlogs_time FROM v$database ;

 

 

Share

For Multiple Server Connections – Single Putty Window – Multiple Tabs

January 28th, 2018, posted in Oracle, Solaris, Windows
Share

Is it possible to have a tabbed putty like firefox or internet explorer ?? Single Putty Window,Multiple Tabs,For Multiple Server Connections,Putty Window,Multiple Tab,Multiple Server Connections,Putty,Multiple Server,DBA,Oracle DBA,Oracle Database,Oracle,Oracle SQL,
Yes you can, check out below URL !!

http://www.thegeekstuff.com/2008/08/turbocharge-putty-with-12-powerful-add-ons-software-for-geeks-3/

Look for Putty connection Manager.

Share

Connect Oracle SQL by Dos And Run Query

June 27th, 2015, posted in Oracle Queries, Windows
Share

 

1 – Make a bat file and connect it with Oracle Sql, let be file name connect.bat :

 

@echo off
sqlplus username/password@connect_identifier @C:UsersrizDesktopmYmy.sql

 

2 – Now make a sql file and write query in it !!

 

spool C:UsersmeDesktopmYmy_log.txt
set linesize 50
set pagesize 50
prompt Purpose:
prompt To run Daily
SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL;
select * from v$instance;
SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL;
exit
spool off;

 

And you are all done.
The first select will give you time so that you may know when it started, the second seelct will give you the instance details and the third select will give you time again so that you can check when it ended.

Share