Fauzi |
Technical solutions for excellence in business
Blog from a software professional, Passionate to work in latest cutting edge technologies in order to get better results in business.
Tuesday, November 24, 2015
Oracle ORA-00020 : Maximum Number of Processes(XXX) Exceeded.
Friday, November 20, 2015
The remote server returned an error: (407) Proxy Authentication Required.
Hello,
I was writing an asp.net utility(console application) to fetch an image from a URL. During development i faced the following message:
The remote server returned an error: (407) Proxy Authentication Required.
The solution is we need to place a app.config file to the project and add the following nodes
Thursday, March 13, 2014
Startup The Database In Archivelog Mode / NoArchivelog Mode
Startup The Database In Archivelog Mode | |
| SELECT log_mode |
| |
Startup The Database In NoArchivelog Mode | |
| SELECT log_mode |
Source: http://psoug.org/reference/archivelog.html
Thursday, February 6, 2014
allowDefinition='MachineToApplication' beyond application level
When am trying to build a web application through visual studio 2010, I was getting the following error message.
· "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.
This error can be caused by a virtual directory not being configured as an application in IIS. "
The solution is to check whether the is any other sub folder which is having web.config file. After removing it, The build was successful.
Best Regards
Sunday, November 17, 2013
Grants given to objects through Roles for a Schema & without Roles (Direct)
Hi Folks,
The following queries are very much useful to get the list of Grants given to Roles for a particular schema objects & to List the direct grants given to users.
Grants given to objects through Roles for a Schema
**************************************************
SELECT TP.OWNER,TP.GRANTEE,RP.GRANTEE, TP.TABLE_NAME, TP.PRIVILEGE FROM DBA_TAB_PRIVS TP, DBA_ROLE_PRIVS RP WHERE TP.GRANTEE = RP.GRANTED_ROLE AND TP.OWNER='Schema Name'
ORDER BY 1,2,3
Individual Grants given to objects without using Roles:
********************************************************
SELECT TP.OWNER,TP.GRANTEE,TP.TABLE_NAME, TP.PRIVILEGE FROM dba_tab_privs TP
where TP.OWNER='<Schema Name>' AND GRANTEE NOT IN (Select ROLE from DBA_ROLES) ORDER BY 2,3,4
Thanks & Regards
Fauzi
Oracle: History of SQL Statements in Oracle 11g
Hello,
The following sql query is very much help full to get the history of sql queries run on the server.
SQL:
select a.USER_ID, a.SESSION_ID,b.sql_text from DBA_HIST_ACTIVE_SESS_HISTORY a, dba_hist_sqltext b where a.sql_id=b.sql_id
Thanks & Regards
Fauzi
Monday, November 11, 2013
Oralce Query to Get Last Sunday or Frieday of the month
The following query is very much useful:
SELECT next_day(last_day(sysdate)-7,'Friday') from dual
SELECT next_day(last_day(sysdate)-7,'Sunday') from dual
Thanks & Regards
Fauzi