Enable case sensitive password oracle database 11g

Posted on by

Enabling Case-Sensitive Passwords with E-Business Release 12

By Elke Phelps (Oracle Development) on Jan 06, 2012

Password security and complexity is often a concern for security and audit teams.  With the recent release of patch 12964564, Oracle E-Business Suite Release 12.1.1 with a minimum database level of 11gR1 now supports password case sensitivity.  Let’s review this database feature in greater detail.

Password case sensitivity was introduced with Oracle Database 11gR1.  Passwords were not case sensitive in earlier versions.  For Oracle database versions prior to 11gR1, the passwords “Manager”, “MANAGER”, and “manager” were all equivalent.  In an 11gR1 database and higher with password case sensitivity turned on, each of these passwords, “Manager”, “MANAGER” and “manager” are unique passwords with unique hash values.

Password case sensitivity is turned on by default for any newly created 11gR1 or higher database .  The database parameter for this feature is SEC_CASE_SENSITIVE_LOGON:

  • When this parameter is set to TRUE, password case sensitivity is enabled.
  • When set to FALSE, it is disabled.

The DBA_USERS view now has a PASSWORD_VERSIONS column that indicates the database release in which the password was created or last modified.

If you have migrated from a prior database version to 11gR1 and SEC_CASE_SENSITIVE_LOGON is set to true, the default behavior is as follows:

  • Existing users must first initiate a password change for password case sensitivity to be enforced
  • New users created in the 11g database will automatically use password case sensitivity

The following example on a generic database — not an E-Business Suite database — illustrates how the password case sensitivity feature works in 11g.

First, a new user, “newuser1″,  is created in an 11g database.

Next, information from the DBA_USERS view is displayed.

The following shows behavior of a migrated 10g user, “system” and an newly created 11g user, “newuser1″ when password case sensitivity is disabled.

Finally, the following  shows behavior of a migrated 10g user, “system” and an newly created 11g user, “newuser1″ when password case sensitivity is enabled.

For instructions on how to enable password case sensitivity with EBS R12.1.1 running on the 11gR1 Database and higher, please refer to the following MOS documentation:

Today is My Day…

Posted on by

Bismillahirrahmaanirrahiim….

Today is my birthday….

May this year be your best ever.
I hope all your birthday dreams and wishes come true.
Not just a year older, but a year better.
Here’s to another year of experience.
A simple celebration, a gathering of friends; here is wishing you great happiness, a joy that never ends.
A birthday is just the first day of another 365-day journey around the sun. Enjoy the trip.
Happy birthday, may this day always be a special one to remember.
May the best of your past be the worst of your future.
Hope your birthday blossoms into lots of dreams come true!
I hope that for every candle on your cake you get a wonderful surprise.
May today be filled with sunshine and smiles, laughter and love.
Happy Birthday and many happy returns of the day.

Hopefully getting married soon. Amien.

How to check ATG version….

Posted on by

This script is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it. Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.

REM HEADER
REM   $Header: atg_supp_patches.sql v7.0 GGGRANT $
REM
REM MODIFICATION LOG:
REM
REM	GGGRANT
REM
REM	Consolidated script to obtain the list of ATG/WF Major Patches applied from OWF G to R12.0.4
REM	Added the EBS Version and did some minor cleanup.
REM
REM	Added 12.0.6 AU and ATG
REM	Added 12.1.1 Maintenance Pack
REM
REM	Added 11i.ATG_PF.H.RUP7
REM
REM	Added Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)
REM	Added Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)
REM
REM     Added 12.1.3 Delta & Rup: 8919491, 9239090.
REM
REM   atg_supp_patches.sql
REM
REM   	This script was created to collect the required information
REM   	to determine the which important ATG patches have been applied.
REM
REM
REM   How to run it?
REM
REM   	sqlplus apps/<password>
REM
REM   	@atg_supp_patches.sql
REM
REM  Parameter:
REM
REM
REM
REM   Output file
REM
REM	atg_wf_applied_patches.html
REM
REM
REM     Created: Oct 17, 2008
REM     Last Updated: Dec 31st, 2009
REM
REM

set arraysize 1
set heading off
set feedback off
set verify off
SET CONCAT ON
SET CONCAT .

set lines 120
set pages 9999

def outputfile = "atg_wf_applied_patches.html"
spool &&outputfile

alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

prompt </FONT>

prompt <HTML>
prompt <HEAD>
prompt <TITLE>Applied ATG Patches</TITLE>
prompt <STYLE TYPE="text/css">
prompt <!-- TD {font-size: 8pt; font-family: arial; font-style: normal} -->
prompt </STYLE>
prompt </HEAD>
prompt <BODY>

REM
REM ******* Ebusiness Suite Version *******
REM

prompt <TABLE BORDER=1>
prompt <TR><TD COLSPAN=9 BGCOLOR=BLUE><font color=white face=arial>
prompt <B>Ebusiness Suite Version</B></TD></TR>
prompt <TR>
prompt <TD>RELEASE_NAME</TD>
select
'<TR><TD>'||RELEASE_NAME||'</TD></TR>'
from fnd_product_groups;
prompt </TABLE><P><P>

REM
REM ******* Applied ATG Patches *******
REM

prompt <TABLE BORDER=1>
prompt <TR><TD COLSPAN=12 BGCOLOR=BLUE><font color=white face=arial>
prompt <B>Applied ATG/WF Patches</B></TD></TR>
prompt <TR>
prompt <TD>BUG_NUMBER</TD>
prompt <TD>LAST_UPDATE_DATE</TD>
prompt <TD>PATCH</TD>
prompt <TD>ARU_RELEASE_NAME</TD>
select
'<TR><TD>'||BUG_NUMBER||'</TD>'||chr(10)||
'<TD>'||LAST_UPDATE_DATE||'</TD>'||chr(10)||
'<TD>'||decode(bug_number,2728236, 'OWF.G INCLUDED IN 11.5.9',
3031977, 'POST OWF.G ROLLUP 1 - 11.5.9.1',
3061871, 'POST OWF.G ROLLUP 2 - 11.5.9.2',
3124460, 'POST OWF.G ROLLUP 3 - 11.5.9.3',
3126422, '11.5.9 Oracle E-Business Suite Consolidated Update 1',
3171663, '11.5.9 Oracle E-Business Suite Consolidated Update 2',
3316333, 'POST OWF.G ROLLUP 4 - 11.5.9.4.1',
3314376, 'POST OWF.G ROLLUP 5 - 11.5.9.5',
3409889, 'POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5', 3492743, 'POST OWF.G ROLLUP 6 - 11.5.9.6',
3868138, 'POST OWF.G ROLLUP 7 - 11.5.9.7',
3262919, 'FMWK.H',
3262159, 'FND.H INCLUDE OWF.H',
3258819, 'OWF.H INCLUDED IN 11.5.10',
3438354, '11i.ATG_PF.H INCLUDE OWF.H',
3140000, 'ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK',
3240000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1',
3460000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2',
3480000, 'ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK',
4017300 , 'ATG_PF:11.5.10 Consolidated Update (CU1) for ATG Product Family',
4125550 , 'ATG_PF:11.5.10 Consolidated Update (CU2) for ATG Product Family',
5121512, 'AOL USER RESPONSIBILITY SECURITY FIXES VERSION 1',
6008417, 'AOL USER RESPONSIBILITY SECURITY FIXES 2b',
6047864, 'REHOST JOC FIXES (BASED ON JOC 10.1.2.2) FOR APPS 11i',
4334965, '11i.ATG_PF.H RUP3',
4676589, '11i.ATG_PF.H.RUP4',
5473858, '11i.ATG_PF.H.RUP5',
5903765, '11i.ATG_PF.H.RUP6',
6241631, '11i.ATG_PF.H.RUP7',
4440000, 'Oracle Applications Release 12 Maintenance Pack',
5082400, '12.0.1 Release Update Pack (RUP1)',
5484000, '12.0.2 Release Update Pack (RUP2)',
6141000, '12.0.3 Release Update Pack (RUP3)',
6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',
5907545, 'R12.ATG_PF.A.DELTA.1',
5917344, 'R12.ATG_PF.A.DELTA.2',
6077669, 'R12.ATG_PF.A.DELTA.3',
6272680, 'R12.ATG_PF.A.DELTA.4',
7237006, 'R12.ATG_PF.A.DELTA.6',
6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)',
7303030, '12.1.1 Maintenance Pack',
7651091, 'Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)',
7303033, 'Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)',
9239089, 'Oracle Applications DBA 12.1.3 Product Release Update Pack',
8919491, 'Oracle Applications Technology 12.1.3 Product Family Release Update Pack',
9239090, 'ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK',
bug_number)||'</TD>'||chr(10)||
'<TD>'||ARU_RELEASE_NAME||'</TD></TR>'
from AD_BUGS b
where b.BUG_NUMBER in ('2728236', '3031977','3061871','3124460','3126422','3171663','3316333','3314376','3409889', '3492743', '3262159', '3262919', '3868138', '3258819','3438354','3240000', '3460000', '3140000','3480000','4017300', '4125550', '6047864', '6008417','5121512', '4334965', '4676589', '5473858', '5903765', '6241631', '4440000','5082400','5484000','6141000','6435000',
'5907545','5917344','6077669','6272680','7237006','6728000','7303030', '7651091', '7303033', '9239089', '8919491', '9239090')
order by BUG_NUMBER,LAST_UPDATE_DATE,ARU_RELEASE_NAME;
prompt </TABLE><P><P>
spool off
set heading on
set feedback on
set verify on
exit
;


source : Script To Check What ATG/Workflow Related Patches Are Installed In EBusiness Suite [ID 275379.1]

					

		
		
	


				
					
	

		

						
Fasting Arafah…

			
						

				Posted on   by  			

			
					


				

			








Fasting on the Day of ‘Arafah


By Tajuddin B. Shu’aib

Da`awah Enterprises International

Los Angeles, California. USA














The ninth day of Dhul-Hijjah (the 12th and final month of the Islamic calendar) is the day of ‘Arafah. It is the day when pilgrims stand on the plain of ‘Arafah to pray. On this day, Muslims all over the world who do not witness the annual hajj should spend the day in fasting, in preparation for the three days festivity following ‘Eid ul-Adha (the celebration marking the end of the hajj commemorating the Prophet Ibrâhîm’s willingness of sacrifice).


Abû Hafsah, may Allâh be pleased with him, reported that the Prophet, upon whom be peace, said:




“Fasting on the day of ‘Arafah absolves the sins for two years: the previous year and the coming year, and fasting on ‘ashûra, (the tenth day of Muharram) atones for the sins of previous years.” [Reported by all except al-Bukhârî and Tirmidhî]




In another saying the Prophet’s wife Hafsah, may Allâh be pleased with her, said:




“Four things the Messenger of Allâh never neglected: Observing fast on the day of ‘ashûra, ‘Arafat, three days every month, and offering fajr sunnah prayers early in the morning.”[Muslim]




These statements are proof that fasting on the ninth of Dhul-Hijjah, the day before ‘Eid ul-Adha was a lifelong practice of the Prophet, peace be upon him, as his wife reported.


There are some reports that fasting is prohibited on the day of ‘Arafah. However, it must be understood that this refers to a person performing the hajj. If a person is on the hajj, there is no fast for him or her on the day of ‘Arafah. That is undoubtedly a blessing for him because of the hardships of the pilgrimage. In a saying reported by Umm al-Fadl, may Allâh be pleased with her, she said:




“The companions doubted whether the Prophet was fasting on ‘Arafah or not. She decided to prove to them that he was not, so she said, ‘I sent to him milk, which he drank while he was delivering the khutbah (sermon) on ‘Arafah.’ “ [Recorded by al-Bukhârî]




Prohibiting the pilgrims from fasting on these days is a great mercy for them, for fasting will exert undue hardship on the person performing the hajj, while they are primarily concerned with their pilgrimage. Above all, the pilgrim would not be fasting anyway because he is travelling.




source : http://www.sunnahonline.com/library/hajj/0004.htm



					

		
		
	


				
					
	

		

						
RMAN Enhancement on 11gR2…

			
						

				Posted on   by  			

			
					


				

			
SET NEWNAME Options


The SET NEWNAME command is more powerful and easier to use. You can use this command on a specific tablespace or on all datafiles and tempfiles. You can also change the names for multiple files in the database.


The oracle 11g release 2 provides the the following options for set newname.


1. SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE

2. SET NEWNAME FOR TABLESPACE

3. SET NEWNAME FOR DATABASE


The following Substitution Variables are introduced for SET NEWNAME in oracle 11g release 2.


For example :


RMAN > run

{

set newname for datafile ‘/db1/iprddata/ahmx01.dbf’ to ‘/u04/UAT/oradata/ahmx01.dbf’;

set newname for datafile ‘/db1/iprddata/ahlx01.dbf’ to ‘/u04/UAT/oradata/ahlx01.dbf’;

set newname for datafile ‘/db1/iprddata/abmx01.dbf’ to ‘/u04/UAT/oradata/abmx01.dbf’;

set newname for tempfile ‘/db4/iprddata/TEMP01.dbf’ to ‘/u03/UAT/oradata/TEMP01.dbf’;

set newname for tempfile ‘/db4/iprddata/TEMP02.dbf’ to ‘/u03/UAT/oradata/TEMP02.dbf’;

set newname for tempfile ‘/db4/iprddata/TEMP03.dbf’ to ‘/u03/UAT/oradata/TEMP03.dbf’;


restore database;


switch datafile all;


}

					

		
		
	


				
					
	

				
					
	

		

						
DBA Certification path…

			
						

				Posted on   by  			

			
					


				

			








The Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in Oracle’s database management system. The Oracle Database 11g Administrator certification is available at the following levels:


DBA Certification Path










					

		
		
	


				
					
	

		

						
DBA Core and DBA Apps…

			
						

				Posted on   by  			

			
					


				

			
Core DBA manages only the data base and related objects within the DB and are also responsible for applying new DB related patches. Apps DBA will also has similar responsibilities but with little more extensions.In Apps, Apps DBAs are also responsible for creating cutom tables in DB (the process is little different in Apps) and applying Apps patches along with the DB pathces and so on.


ORACLE DBA will handle entire database administration and maintenance.

ORACLE APPS DBA will be able to do the functionalities of DBA and including administration of oracle applications


In general they will also manage Apache server, forms server and reports server also.

					

		
		
	


				
					
	

		

						
Database Administrator…

			
						

				Posted on   by  			

			
					


				

			
Database Administrators


Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.


A database administrator’s responsibilities can include the following tasks:


    

  • Installing and upgrading the Oracle server and application tools
    • 

  • Allocating system storage and planning future storage requirements for the database system
    • 

  • Creating primary database storage structures (tablespaces) after application developers have designed an application
    • 

  • Creating primary objects (tables, views, indexes) once application developers have designed an application
    • 

  • Modifying the database structure, as necessary, from information given by application developers
    • 

  • Enrolling users and maintaining system security
    • 

  • Ensuring compliance with your Oracle license agreement
    • 

  • Controlling and monitoring user access to the database
    • 

  • Monitoring and optimizing the performance of the database
    • 

  • Planning for backup and recovery of database information
    • 

  • Maintaining archived data on tape
    • 

  • Backing up and restoring the database
    • 

  • Contacting Oracle Corporation for technical support
    • 



					

		
		
	


				
					
	

		

						
Appreciate the DBA’s Role…

			
						

				Posted on   by  			

			
					


				

			
DBA


“Database administrator” is often not a very precisely defined job. In many organizations, end users expect the DBA to be an expert on all aspects of the IT environment. If the database crashes, they call the DBA. Fair enough. But they may also call her if the network fails, if the servers crash, or if the application has a bug. Some DBAs believe that end users will call them if the plumbing gets blocked. Perhaps this is because virtually any failure in the IT environment results in end users being unable to use the database, so the DBA is the natural first point of contact.Apart from these excessive expectations, the DBA is often the only person in the IT management structure who has a holistic view of the environment. Oracle Enterprise Manager Grid Control is a tool specifically intended to aid the DBA with this: it presents a complete picture of the performance and availability of all the

databases, application servers, and server machines in the organization. A vital part of the DBA’s job is to identify where in a complex information technology environment a failure or a performance issue has occurred, and work with the appropriate support group to fix it. Duties more specifically related to database administration include :


a. Sizing applications and server hardware


Accurate forecasts of the necessary main memory, disk space, and CPUs that are needed to ensure that applications will run well without demanding unnecessary resources are an important part of maintaining performance without using excessive budget.


b. Oracle software installation and maintenance


This is a non-trivial task in organizations with many servers. Software installations must be kept up-to-date with critical patches (for security, for instance), and maintenance patches should be applied as they are issued, but before any such update is done to live systems, the DBA must ensure that it is adequately tested.


c. Database physical design


There will usually be many ways to configure the physical storage of a database, some of which may have a large impact on the performance of the system and its manageability. The DBA must also be aware of the impact of different storage structures on devices such as disc and tape systems.


d. Monitoring and tuning performance


This is a continuous activity for production systems. A good DBA will be able to anticipate performance issues and fix them before they arise.


e. Assisting developers with application design and tuning SQL


Some DBAs spend eight hours a day tuning SQL. Perhaps this should be the work of the programmers, but at the very least the DBA must identify the problem areas they should be addressing.


f. Liaising with vendors, end users, developers, senior management, and other support groups


As the technician with the most complete picture of the environment, the DBA must take a leading role in coordinating planning and action by all parties involved in the IT environment.


g. Backup, restore, and recovery Perhaps the most important part of the job.


The DBA must establish routines that will ensure that agreed targets for uptime and data loss (perhaps as demanding as 100 percent and zero respectively) can be met in the face of any possible problem. There is no right or wrong here, only conformance (or lack thereof) to the agreed targets.


h. User and security management Another critical part of the job.


As with uptime and data loss, there is no right and wrong in security—only conformance with agreed standards. The DBA must set up procedures that will ensure conformance, and monitor their effectiveness.


Some DBAs believe that they are doing their job perfectly if no one knows they are there. There is a certain amount of truth in this. Database administration is to a large extent support work, and if the work is done well enough with sufficient proactive planning and preventive maintenance, there will never be a reason for users to report a problem. Usually this ideal can’t be reached, and a large amount of time will be spent working reactively with different people in different groups to solve issues.

The wide scope of the DBA role requires continual study and personal development, study of the Oracle database itself and also of related technologies. It also requires the inclination to educate and to spread knowledge. This can be the most rewarding part of the job.


source : oracle database 11 administration examine guide