How to secure oracle database, I am having the oracle database which will be packed as package in a machine and will be delivered to client place , need to ensure that the client will not access the database by any means.
Even he breaks the password (he should not break but despite client has broken the password) and went inside the database, he should not be able to see the databases Procedures ,views,functions and triggers. Can we Encrypt this, if so can client will be able to decrypt the same? Is there a way to secure the database from the client not to access the database.
We would like to used Oracle secure backup using SAS interface on an IBM Autoloader Model TS-2900. Would it be possible to configure oracle secure backup using SAS?
We have OSB 10.44 installed on 64 Bit Red Hat OS. Is working pretty fine with a Virtual Library that is configured in an Storage Box. Now we have acquired a Physical Storage and we want to duplicate the backups already taken by the Virtual Library into the new Physical Library.
We have 20 drives for the VTL and for the physical we are planning to have the same to duplicate all backups from VTL. That is being done in case Emergency Failures, so we can restore from Physical Library in case the VTL fails.
The question is: Is there any documentation on how to do duplicate backups.?
The duplicate backups copy wont be done in real time. They will be done after the backup is finished in the VTL and then will start the copy in the physical library.
I'm doing online business of selling my manufacturing product to my customer through internet. It is so much easy way but with this there are some unwanted threads that might be disturb business working area. I want to keep my customer online data from hacker but have no strong software who minimize or protect them hackers.
We are trying to use the SFTp transport in OSB 11g. Did the setup as mentioned in the documentation.The SFTP server is hosted on linux machine and using the user password mechanism.
We are reading a file using the ftp adapter and routing to the business service that is based on sftp.The file is picked up properly by proxy but while sending the file through SFTP, we are facing the following error.At the source and destination ends, the directories have the full permissions as required.
BEA-381801
Caused By: com.bea.wli.sb.transports.TransportException: No such file at com.bea.wli.sb.transports.sftp.connector.SFTPTransportProvider.sendMessage(SFTPTransportProvider.java:198) at com.bea.wli.sb.transports.sftp.connector.SFTPTransportProvider.sendMessageAsync(SFTPTransportProvider.java:110) at sun.reflect.GeneratedMethodAccessor1005.invoke(Unknown Source)
am trying to use secure call to reports from forms using the frmrwinteg.jar javabean.
when i set the implementation class of the javabean area i still have the error FRM-13008 can't find javabean with name..,but i ignore it as i read at the whitepaper downloaded from OTN. and follow all instructions add to java directory,, add to formsweb,, add parameter to basejini.htm
each time i call the report i have been asked to connect and when i run the form my username and password are written to the consol and i still can see them at the html code when call parameter form, my code is
DECLARE
rep_url varchar2(2000);
BEGIN rep_url:='http://office_server:8889/reports/rwservlet?server=repserver10&report=d:mm-J.JSP &desformat=htmlcss&destype=CACHE¶mform=yes&userid='; set_custom_property('block3.userid_bean',1,'WRITE_LOGOUTPUT','true');
[code]...
and this is what is written to the consol
FrmReportsInteg1: Debugging true FrmReportsInteg1: Adding new userid string "xx/xx@xxxxx" FrmReportsInteg1: ADD_REPORTS_CONNECT: xx/xx@xxxxx FrmReportsInteg1: Setting cookie path to /reports/TEST/
[code]/....
i DON'T KNOW WHERE IS THE ERROR THAT MAKE THIS NOT WORK.
Oracle Back up is showing library Dell PS 6100E as unsupported device and can not retrieve any information from it, can not ping and can not verify both from obtool and web tool. Using Linux. I can ping from outside and see the device config using lsscsi. But obtool and webtool fails. Is it really unsupported ? In the
$ORACLE_Backup_Home/device/device_robots I see some PV122T, PV124T
We having OSB 10.4 on Solaris 10 with SL 24 TL Auto loader ( Tapes doesn't having Bar-code ), while firing file system backup (Sol 10 is the client OS) , it is hanging . and i have logged in to TL console then it shows loading and unloading. while OSB catalog backup is getting fired on the associated media family.
We are exploring Oracle Secure Backup in our environment as legato networker alternative. But RMAN backup in OSB is very slow due to sbt wait event (sbtwrite2). it can backup 5GB/hour. We think this not normal behavior. we have checked network throughput between media server and client server. It can send 50 GB data by 30 min.
I have a lot of uncompressed backup. How can I compress it?
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 304 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432 305 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432 306 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432 308 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432 309 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
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
But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.
I have a requirement to put together a Oracle SQL template to create re-usable DDL/DML Scripts for Oracle databases.Only the Oracle DBA will be running the scripts so permissions is not an issue.
The workflow for any DDL is as follows:-
1) New Table
a. Check if the table exists from the system/admin views.
b. If table exists then give message "Table Exists"
c. If table does not exist then execute DDL code
2) Add Column
a. Check if Column exists for a given table from system/admin views
b. If column exists in the specified table,
b1. backup table.
b2. alter table to make changes to the column
b3. verify data or execute dml script convert from backup to the new change.
c. If Column does not exist
c1. backup table
c2. alter table to add column
c3. execute dml to populate column with default value.
The DML scripts are for populating base tables with data required for business operations.
3) Add new row
a. check if row exists by comparing old values of each column with new values to be added for the new record.
b. If exists, give message row exists
c. If not exists, add new record.
4) Update existing record (We have createtime columns in these tables so changes can be tracked)
a. check if row exists using primary key.
b. If exists,
b1. deactivate the record using the "active" column of the table
b2. Add new record with the changes required.
c. If does not exist, add new record with the changes required.
I'd like to get database redundancy with Oracle Standard Edition One. currently have one physical database server and are considering getting a second physical database server.
What's the best way to achieve that without going to Oracle Standard Edition using RAC?
Actually I am using Oracle 9i in Windows Operating System. Now I want to move to my entire Oracle Database to Oracle 11g in Linux version. What are all the correct steps to do this. I am not a DBA.
In my Production server, Database size increased very high due do to logs generated in a table called "Process Activity". And the table size is 50GB.
We deleted the data from the table "Process Activity". And still the table size and Database size remain same. Space not released by DB. One of my friend, recommended me to sync the oracle DB to release the space. how to synchronize the DB to release space.