Security :: How To Mask Data In Oracle 11g Database Release 1

Oct 16, 2012

how to mask data in oracle 11g database release 1

my environment is
Database: 11g release 1
os: AIX 6 (64 bit)
GC:10g release 1

View 12 Replies


ADVERTISEMENT

Security :: Authentication For Connected User Database Links (release 11.x)

Jun 16, 2013

I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,create public database link using 'orcl';then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.

View 4 Replies View Related

SQL & PL/SQL :: How To Mask Data In Oracle Table

Aug 4, 2011

In my project I am getting production dump for performance testing and I need to mask few columns with sensitive information.

How can I mask the data in Oracle?

View 5 Replies View Related

Security :: Masking Options / Techniques To Mask Few Columns

Nov 26, 2012

I am looking for Masking options/techniques to mask few columns. I am aware of the option Oracle Data Masking Pack. But its costly.

View 6 Replies View Related

Downgrade Oracle Database 10g Release 10.2.0.2.0 To 10.2.0.1.0?

Nov 29, 2011

am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.

i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to

>take full backup of oracle DB
>ORACLE_HOME/bin/emctl stop dbconsole
SQL> STARTUP DOWNGRADE
DROP USER sysman CASCADE;
>SQL> SPOOL downgrade.log

[code]....

View 1 Replies View Related

Installation :: Oracle Database 11g Release 11.2.0.3.0 IBM AIX On POWER Systems (64-bit)

Mar 13, 2013

Is Oracle Database 11g Release 2 (11.2.0.3.0) available for IBM AIX on POWER Systems (64-bit), Or do we need to upgrade 11.2.0.1 to 11.2.0.3.0.

View 4 Replies View Related

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

Dec 27, 2012

how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.

View 1 Replies View Related

Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone

May 11, 2013

which is really a HA zone clustered in VCS(not important for installation of the database).

What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.

View 3 Replies View Related

Security :: Oracle 11G And Advanced Security / FIPS 140-2 Compliant Encrypt Data At Rest

Dec 26, 2012

Any documentation supporting Oracle 11G and Advanced Security stating encryption at rest is FIPS 140-2 compliant?

View 3 Replies View Related

How And When The Database Release A Row Lock

May 30, 2013

We are using the following statement to obtain a row lock in a table in the database(ORACLE 10G), SELECT * FROM {TABLE_NAME} WHERE ID = 1 for update and if we succeed grabbing the row lock we will continue to issue a update statement every 30 seconds to preserve the lock as far as possible. here is the update statement to preserve the lock,

UPDATE {TABLE_NAME} SET time = ? WHERE ID = 1.

As you see more longer we keep holding the row lock , more update statements are submitted in the pending transaction. In normal case our application can grab the exclusive row lock and works for a long time,however sometimes a connection reset exception is thrown and our application will close the connection(I assume the pending transaction will be rolled back by the database) and exit the JVM. Since other applications will keep trying to grab the same row lock to become the master role, we expect one of them can succeed but they are all failed because the database has not released the row lock as expected. how and when the row lock can get released in our use case?

View 14 Replies View Related

Server Utilities :: SQL Loader Date Mask For Data?

Jan 8, 2011

I am trying to load my data from a CSV file to an oracle table using SQL LOADER. What should be the syntax of DATE MASK for the below kind of data.

02MAR1948:00:00:00.000
24SEP1950:00:00:00.000

I am using the following control file

LOAD DATA
INTO TABLE TW_EXTDATA.PATIENT_VISITS_MERGE_39950
REPLACE
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'

[code]...

View 2 Replies View Related

Security :: Disconnect From Oracle Database

Jul 21, 2010

Is there any setting on oracle that allows to disconnect users automatically and display a message to users such: "Try a new connection to the db in 30 minutes"?

View 7 Replies View Related

Security :: Oracle Encryption Data?

Apr 6, 2013

Can i get some documents on oracle RAC database encryption.?what are the pros and cons of encryption?Does this comes with oracle Database or something we need to buy from oracle sales persons?

View 2 Replies View Related

Security :: Use Oracle Database On AIX With Active Directory

Apr 28, 2011

I'm checking the possibility to use Active Directory to log on the our Oracle databases. But only for dba's and developers, not application users. We use Oracle 10.2.0.4 (and soon 11g) As OS on the databaseserver we use AIX5L 5.3

Is it possible to implement Active Directory on databases running on AIX ? If it is possible, what must be done to get it to work, software ... etc ?

View 3 Replies View Related

Security :: How To Configure Log Miner With Oracle Database 11g

Nov 2, 2012

Database 11.1.0.7
Applications 12.1.3
OS RHEL 5.5

how to configure log miner with oracle database 11g as we need to analyze redolog files.how to install,configure,use log miner.

View 2 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

View 1 Replies View Related

Windows :: Unable To Continue Oracle 11g Release 2 Installation

Jul 24, 2013

I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.

The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.

View 2 Replies View Related

Forms :: Find Key Pressed And Release Action On Oracle 10g

Dec 14, 2012

we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.

As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.

Is it possible, as user release the key scrolling will stopped at same time ?

View 3 Replies View Related

Security :: How To Find User And IP Address From Oracle Database

Jun 19, 2013

Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.

How can I find which user or from which IP the change is made.

View 6 Replies View Related

Security :: Lock User Accounts In Oracle Database

Jul 12, 2011

I have a doubt in locking user account in oracle database.I was told to drop some unusable users in database which my clients dont require them.I verified the dependent objects of those users but not sure if these users can be dropped.

Instead can i make those user accounts locked so that they cannot connect to database? Would there be any impact on database performance if i lock those user accounts?

Is locking an account and dropping users is similar in anyway?

View 12 Replies View Related

Security :: How To Replace No Data Found Keyword In Oracle

May 30, 2013

i have a table that contains employee id, employee name , so if i gave the correct employee id in where clause of select statement it will show employee name, in case if i give the employee id that does not exist in the table it will show 'Employee name is not found'..

View 2 Replies View Related

Replication :: To Upgrade All Oracle 10g Master Sites / Databases To 11g Release

May 28, 2009

I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.

View 1 Replies View Related

Reports & Discoverer :: Reporting Against Ap Invoice Hold Release Name In Oracle 11.5.10

May 9, 2012

why we seem to be unable to report against the ap invoice hold release date using Discoverer in Oracle 11.5.10? the person who wrote our current report used a decode statement to look at the last update date of the release lookup code to create a release date, but i am trying to recreate this in a different tool (Qlikview) and just wanted to understand why we seem to be unable to report on the field as is!

View 4 Replies View Related

Security :: CVE-2012-3132 And Express Editions Of Oracle Database

Oct 10, 2012

I was wondering if the Express Edition of Oracle Database inherited the same vulnerabilities as the whole edition? Namely I have a few hosts that have Oracle Database 11g Express Edition installed and I was wondering if they would then be vulnerable to CVE-2012-3132 and specifically the easily exploitable flaw associated with it, detailed below:

Can't use links until I've posted 5 messages, ugh..link obfu with x's and [] URL....

View 2 Replies View Related

Security :: Oracle Audit Vault And Database Firewall Implementation?

Dec 25, 2012

we are planning to implement Oracle Audit Vault and Database Firewall on 2 node 11g RAC/solaris10

View 4 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Security :: Network Data Encryption Between Oracle Client And Server On Unix?

Jun 4, 2010

We have an application that fetches and writes data into oracle database through pro c. oracle datyabase is on another server.

We are storing some secure information into oracle database so we want to encrypt the data sent by our aplication into oracle database.We do not want to use SSL(i.e certificates) and also do not want to make use of Advance Security Option available in oracle and also do not want to make any changes in sqlnet.ora file on server side.

achieve encryption of traffic between our application and Oracle database?

View 13 Replies View Related

Security :: Moving Application Security To Oracle From Sybase

Aug 18, 2010

In Sybase, my application was using system tables to perform application login security. Those tables obviously don't exist in Oracle. I am looking for ways to provide the following functionality in an Oracle world:

1. How to determine 'x' days of inactivity based on "last login date"?

2. How to determine when a new user logs in for the first time and force them to change their password?

3. If we need to reset a users password, how can we require the user to change their password?

4. Is there any other option other than storing a user-id/password in the application code for locking a user's account if their account needs to be locked due to inactivity?

5. In the USER_USERS view there is a status column. What the different status's can be?

View 3 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Convert Oracle Database (schema Data) To Postgresql Database

Oct 11, 2012

i want to convert oracle database(schema data) to postgresql database

which tool would be best and url to download and steps to convert from one database to another ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved