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


ADVERTISEMENT

Security :: How To Configure Oracle EM With Newly Created Oracle Instance On 10g DB

Dec 11, 2012

How to configure Oracle EM with newly created Oracle Instance on Oracle 10g DB,which is Single Instance DB but not RAC ,when I start the Oracle EM it is starting the default DB which created during Oracle Server Installation.

View 0 Replies View Related

Security :: How To Configure End User Open Only One Session

Jun 10, 2011

I want to configure this

my end user open only one session

means one session per one user only

View 8 Replies View Related

RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database

Oct 28, 2010

We have to configure Dataguard for our 24x7 critical banking 2 Node RAC database(10.2.0.4). Before proceeding with the configuration we have to make sure what steps we should follow to have minimum or no downtime.

1) Document covering DG setup in RAC environment.
2) We have to perform switchover as well so need its steps too. Either the normal switchover steps would be used or have to stop/start rac services as well.

View 7 Replies View Related

Networking And Gateways :: Configure HSODBC On HP-UX 11.23 For Oracle Database 10g?

May 23, 2011

We want to configure HSODBC on HP-UX 11.23 for Oracle Database 10g R2 in order to establish a DB link from Oracle to Netezza.We have installed the ODBC Drivers too..Currently we have not done any configurations and we go via an AIX box to establish a link.We want to get rid of the AIX box and instead establish directl link towards netezza from HP-UX Box.

Does Oracle support have some guidelines or steps to setup HSODBC on Oracle database 10g r2 residing on HP-UX 11.23 towards Netezza?

View 1 Replies View Related

Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies View Related

Recovery Manager (RMAN) :: Script / Daily Incremental Backups With Configure Commands For Oracle 11g Database

Aug 29, 2012

the rman backup script for weekly full backup and daily incremental backups with configure commands for oracle 11g database.

View 10 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 :: 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 :: 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

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 :: 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 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 :: 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 :: 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

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

Enterprise Manager :: Can't Configure 11g R2 - Database Instance Not Available

Dec 12, 2010

I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.

EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....

View 3 Replies View Related

Enterprise Manager :: Configure OEM Dbconsole For Two Database?

Jan 20, 2010

I have two database in my system but when i open

[URL].....it always defaults for one database..in the service name also there is dbconsoledba1 written....my other database is dba2...do i need to create another service for dbconsole

View 1 Replies View Related

Data Guard :: Configure Physical Standby Database?

Jul 17, 2012

step by step procedure to configure physical standby database.....

i have to create on windows not in linux...so simple step by step procedure,once configured it should be up and running;

View 3 Replies View Related

Configure Oracle 11g RAC With ASM Setup?

Aug 26, 2013

We wish to configure an Oracle 11g RAC with ASM setup for the internal employee training purpose. The requirement is as follows

1. Operating system Linux, Software Oracle 11g Release 2
2. Need to build total 5 individual clusters.
3. Each cluster with 2 Node
4. Need to configure ASM as a shared storage with real hardware. (No virtualization, Openfiler, NFS)
5. Need to configure RAC database.

provide me the hardware details for configuring Shared storage. Is there any specific Storage which we can use to configure ASM as a storage.

View 2 Replies View Related

RAC/ASM Clusterware Installation :: How To Configure DNS For Using Oracle GNS

Sep 24, 2012

I need some professional article about how to configure DNS for using Oracle GNS with explanation.

I want to understand the role of DNS server for GNS.

I tried to search but what I found is not enough or they are not written with accuracy.

View 2 Replies View Related

Queueing :: How To Configure Oracle AQ For Distributed Environment

Sep 23, 2013

I have a scenario In which I have say 4 AQ in which I will post the message.Also i have say 2 database.I am planning to create an MDB which will poll on these AQ's,  so whenever I post message the MDB will read it and perform a specific action.I believe I can create only one MDB per queue, if it is so then I have to create 8 MDB.

As there 2 datasource and 4 MDB. Is there any other way to handle this I mean without creating 8 MDB as the Data sources can increase to 10 to 20 so the number of MDB will be 20 to 40.I guess this will affect the application performance. Can I make some changes in application so that only few MDB's are required? 

View 0 Replies View Related

RAC & Failsafe :: Oracle Grid Infrastructure Configure Failed

Feb 15, 2011

i am trying to install 2 node RAC on Oracle VMs. Before the installation during the -preinst check there were few issues which were resolved (ex user equivalence). After that during the installation process of the Grid it failed at step "Configure Oracle Grid Infrastructure for a cluster". After it failed at this step, subsequent steps too failed which I asked OUI to ignore and then I ran both the post installation scripts. And then ran post crsinst which failed. Pasting below the output of the root.sh script, post crsinst and other checks.

*************************************
[root@bsfrac01 grid]# sh root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created.Finished running generic part of root.sh script.Now product-specific root actions will be performed.

2011-02-13 00:11:55: Parsing the host name
2011-02-13 00:11:55: Checking for super user privileges
2011-02-13 00:11:55: User has super user privileges

[code]....

View 1 Replies View Related

Server Administration :: Configure Watchdog For Oracle DB 11g On Redhat Linux

Jan 28, 2011

I need to configure a watchdog (or any other) utility which will constantly monitor database health. And if something goes wrong with the database, the utility should restart the DB instance.

View 8 Replies View Related

Networking And Gateways :: How To Configure OracleNames Server Using Oracle 9i On Linux

Jan 26, 2010

I have 9i RDBMS Software and RHEL 4. I want to install a Oracle Names server. I install RDBMS.But Where I run netmgr and want to configure and start Oname server it says.

$ORACLE_HOME/bin/names file not exists.

How Can I configure OracleNames Server using Oracle 9i On Linux.

View 2 Replies View Related

Enterprise Manager :: Configure Data Guard Setup - Oracle 10gR2 And Windows XP

Jan 18, 2011

i want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.

How to use enterprise manager for configuring Data Guard.

View 9 Replies View Related

Security :: Database Hardening?

Mar 13, 2009

regarding Database Hardening, i am new to this concept

View 2 Replies View Related

Security :: Password In New Database

Mar 7, 2012

i have created a database on my pc and i have given a password at the time of installation , after the installation it is accessed successfully by the given password , but i observed that when i gave anything in password then it is also accessed by it and i don't have any other database of this same name.

And when i access it through another system then it is accessed only by its original password not by any other password.

View 7 Replies View Related







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