Wednesday, May 18, 2011

Security Check List or Security issue of Oracle Database

Security Check List or Security issue of Oracle Database
==========================================

1 : Change the password for SYS and SYSTEM.
2 : Lock, remove or change passwords for default unused accounts.
3 : Check privileges and limit SYS privilege.
4 : Set REMOTE_OS_AUTHENT init.ora parameter to FALSE
for avoiding remote users OS authentication.
5 : Protect the dictionary from unauthorized users.
such as Set O7_DICTIONARY_ACCESSIBILITY to FALSE.
6 : Revoke privileges from PUBLIC where not necessary
Such as for example for the UTL_FILE package.
7 : Verify database file security
8 : Limit the number of OS users on the database host
9 : Remove unnecessary services from the database host (e.g. FTP).
10: On a regular basis, check Metalink for Security alerts and patches.
or here http://www.oracle.com/technetwork/topics/security/alerts-086861.html

11. How well compartmentalized is your system ?
12. Do people have administrative passwords who really do not need them ?
13. Change passwords often, then monitor and audit. It is worth the extra time and
overhead.
14. Physical security is vital, as always. Your server is safely locked away, but
how about your backup tapes ?
15. If you needed to restore your system tomorrow, do you have everything you need
offsite ?
16. you can use Database Scanner 3.0 from Internet Security Systems (ISS: www.iss.net/products)
another one is here Secure.Data from Protegrity (www.protegrity.com)

Monday, May 16, 2011

How to Delete a File from the O/S from oracle developer Forms ?

How to Delete a File from the O/S from oracle developer Forms ?
---------------------------------------------------------------
1)

The first way to delete a file on the O/S is to use the HOST command. The HOST
built-in allows to execute an indicated operating system command.

Syntax (see forms on-line help)

PROCEDURE HOST(system_command_string VARCHAR2);
PROCEDURE HOST(system_command_string VARCHAR2,screen_action NUMBER);


On a Windows platform your code would look like :

HOST ( 'del C:\temp\temp1.lis', NO_SCREEN );

On a Unix platform you code would look like :

HOST ( 'rm /tmp/temp1.lis', NO_SCREEN );


As this solution is based on the HOST command it applies to all platforms.


2).

Another way to delete a file form the O/S is to use for Client/Server
D2kWutil: WIN_API_UTILITY.DELETE_FILE
or for Webforms
webUtil: webutil_file.delete_file.

How to Enable SQL_TRACE in oracle Forms developer ?

How to Enable SQL_TRACE in oracle Forms developer ? 
--------------------------------------------------  
In order to enable a Forms session level SQL_TRACE do the following:   
Place the following line of code in a When-New-Form-Instance Trigger in  
the first form that is run in your application:       
FORMS_DDL('ALTER SESSION SET SQL_TRACE=TRUE');  
A trace file will be generated on the database server in the directory  specified 
by the database parameter user_dump_dest.

DBA jobs in Bangladesh

DBA jobs/future in Bangladesh specially Oracle DBA
=====================================

also trying to write on this topics.

just for test

DBA jobs in Dubai
oracle dba jobs in dubai
dba jobs in saudi arab
dba jobs in usa
dba jobs in uk

Oracle in Bangladesh (Growing future day by day)

Oracle in Bangladesh (Growing future day by day)
=================================================

I will write a details article on this subject. Now i am collecting data or information about this topics. you can help me.


Main Contact Person
====================

Contact with Aon Ali for Oracle University Corporate Training Queries in Bangladesh
He is in charge now for the Bangladeshies . His contact info is

E-mail: aon.ali.siddiqui@oracle.com
Cellular: +92 300 2003399
Address : Suite # 306 & 307, The Forum
Khayaban-e-Jami, Block No 9,
Clifton, Karachi.

More info see here:-
http://www.oracle.com/as/corporate/contact/bangladesh-316183-en-as.html


Oracle University- Authorized Training Partners in Bangladesh

1) Workforce Development Program Members (WDP) - For Individual Training

I . IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com


II . IT Bangla Limited
32, Topkhana Road, Chattagram Bhaban (3rd Flr), Dhaka-1000, Bangladesh.
Phone: 9558519, 9557053
Fax: 9553937
Email:education@itbangla.netTechno-Ed

2) Oracle University – Oracle Approved Education Center (OAEC)


IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com

3) Oracle University- Education Resellers
IBCS-PRIMAX Software (Bangladesh) Ltd


Oracle jobs in Bangladesh: visit...

http://www.careerjet.com.bd/oracle-jobs.html




Oracle partners in Bangladesh
==============================


IBCS Primax Software (Bangladesh) Ltd
House No. 44 Road 13/A Dhanmondi
Dhaka
Bangladesh1209
Bangladesh

Phone: 88 02 8110699 209
Web: ibcs-primax.com

Partner Level: Platinum
Partner Type: SI

Platinum
Partner Profile
Expand
IBCS-PRIMAX Software (Bangladesh) Ltd, a Bangladesh-British joint venture company established under the laws of Bangladesh in 1989 by a group of IT professionals, with the ambition of creating a... (more)

Solutions Offered
Computer Integrated Insurance System (CIIS)
CIIS is a fully integrated general insurance application. (more)
Datapark (BD) Limited
2nd floor, Rangs Nilu Square,
Dhaka
1209
Bangladesh

Phone: +88029102209
Web: dataparkbd.com

Partner Level: Platinum
Partner Type: Management Consultancy

Platinum
Datapark (BD) Limited
Partner Profile
Expand
DATAPARK, an Information and Communication Technology services and development specialist, combines data center, business consultancy, ICT education with its recognized expertise in strategic gl... (more)
Spectrum Engineering Consortium Ltd
ICT Incubator, BDBL Bhaban, 7th & 8th Floor
Dhaka
1215
Bangladesh

Phone: +88 (02) 9142058
Web: spectrum-bd.com

Partner Level: Gold
Partner Type: ISV

Gold
Partner Profile
Expand
Spectrum Engineering Consortium Limited, CMMI Level 3 Certified, Microsoft Gold and Oracle Gold Partner, designs and delivers IT-enable business solutions to global clients. Spectrum provides ser... (more)
Thakral Information Systems Pvt. Ltd.
11th Floor-East, BSRS Bhaban, 12 Kawran Bazar
Dhaka
1215
Bangladesh

Phone: 88-02-9146051-5
Web: thakral-bd.com

Partner Level: Gold
Partner Type: SI

Gold
Thakral Information Systems Pvt. Ltd.
Partner Profile
Strategic Alliance Partner of IBM, Value Added Distributor of Oracle, Value Added Distributor of Lenovo, Premier Corporate Partner of HP IPG, Certified Premier Partner of CISCO, etc. (more)
Leads Corporation Limited



Select Country


Web: leads-bd.com

Partner Level: Gold
Partner Type: SI

Gold
Partner Profile
A leading software development company having web-enabled application software for Core Banking, Insurance and Manufacturing Industries. (more)
Information Solutions Limited
113, Kazi Nazrul Islam Avenue
Dhaka
1000
Bangladesh

Phone: +880-2-933-5268
Web: isl-bd.com/

Partner Level: Gold
Partner Type: SI

Gold
Partner Profile
Expand
Information Solutions Limited (ISL) represents some of the World Best Infrastructure and Solution provider, in Bangladesh with a group of well experienced and internationally trained experts avai... (more)
Southtech Limited
Dhaka Square (4th & 5th Floor)
Dhaka
1230
India

Phone: (+88-02) 891-6331
Web: southtechlimited.com

Partner Level: Gold
Partner Type: ISV

Gold
Partner Profile
Expand
Southtech Limited was established in the year 1996 and is a top ICT solution and consultancy service provider in Bangladesh. It provides comprehensive solution for Core Banking, Microfinance, Hum... (more)
ATI Limited
ATI Center, House # 1, Road # 9/A
Dhaka
1230
Bangladesh

Phone: 88-02-8912863
Web: atilimited.net

Partner Level: Gold
Partner Type: ISV

Gold
Partner Profile
Expand
ATI (Advanced Technology Innovation) Limited established in 1998, provides the best customized and localized solutions worldwide in the areas of Software and IT Consultancy. Standardized developm... (more)
Data Edge limited
139 Motijheel C/A
Dhaka
1000
Bangladesh

Phone: +88027162568
Web: data-edge.com

Partner Level: Gold
Partner Type: SI

Gold
Map Data - Terms of Use
Map
Partner Profile
data edge limited (dataedge) has been Bangladesh's leading technology consulting firm (more)

Solutions Offered
Core Banking Solution
Core Banking Solution (more)
Oditio Technologies Ltd
23/12, Khiljee Road, Ground Floor
Dhaka
1207
Bangladesh

Phone: +880-2-9121391
Web: oditio.com

Partner Level: Silver
Partner Type: Education Provider

Silver
Partner Profile
Expand
Oditio Technologies Ltd is a software and IT enabled services provider delivering technology driven solutions that meet the strategic objective of enterprises. Oditio has a "Center of Excellence"... (more)