I want to secure files that I saved in xml db with TDE, but tablespace encryption(tde) is not supported on the sysaux tablespace.
Is there any way to move the tables where XML DB saves data to another tablespace where TDE is enabled?
i have this stored procedures:
create or replace
PROCEDURE INSERTXML2(
p_xml_in XMLType,
p_table IN VARCHAR2 ) AS
v_context DBMS_XMLStore.ctxType;
v_rows NUMBER;
BEGIN
[code]....
that works well in little XML files but in XML files that are bigger the stored procedures to not work because string maximum length in Oracle is 4000.
im working with Oracle SQL Developer and Sap Mii, the XML file is generated in Sap Mii and then i have to pass it in one step to database..
I need to write a PL/Sql stored procedure to move files from one location to another. I need to move files that are older than 30 days. Is there any Oracle package I can use to move the files on the basis of its creation date.
View 3 Replies View RelatedORA-00439: feature not enabled: Partitioning...
how to enable partitioning in database....
my version is......
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production.
Two questions.
1. Both Oracle Secure Backup and Oracle Secure Backup Express for x86 Solaris download the same file.
Is there no difference on Solaris?
2. Have installed and configured sgen driver and tapes can be labelled OK and the first backup works
BUT appending the next backup to the tape I get the following.
Space to EOD.
BSR
Device says it is offline
Transcript below
8231: 2012/12/21.10:16:28 (pvfw) previous state is invalid
8232: 2012/12/21.10:16:28 (alv) backup image label is valid, file 1, section 1
8233: 2012/12/21.10:16:28 (pvfw) invalidating tape position in mount db
8234: 2012/12/21.10:16:28 (ial) invalidate backup image label (was valid)
8235: 2012/12/21.10:16:28 ***0 wst__exec: op=16 (eod), buf=0x0, count=1 (0x1), parm=0x0
[code]........
My scenario:
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.
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.
how can i secure my database from hacking by any one of these:
1-sql injections
2- DON(Danial Of service)
3- buffer overflow
4- listner hack
I am using Oracle 10g XE (express edition). If I try to create a bitmap index, I get an error
ORA-00439 feature not enabled: Bit mapped Indexes
How do I solve this problem and create a bitmap index?
Since tablespaces can be enabled/disbaled for flashback is there a query that can tell me the flashback status of each tablespace in my DB.
View 2 Replies View Related how to check that audit is enabled for any particular schema.
The below is my audit parameter from database level:-
SQL>SHOW PARAMETER AUDIT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /db17/dbdump/xxxx/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB_EXTENDED
Is it possible to get a list of tables in a schema on which Audits are enabled.
View 2 Replies View RelatedIs it possible to audit when a constraint is disabled, enabled or dropped? Sometimes I wonder why some constraints are missing. To make sure someone is dropping I would like to audit that action. Further, I would need to compare schemas to realize if some constraints are missing. As it names are generated automatically by oracle, how could I easily run a select to compare the constraints that does not match between schemas?
View 10 Replies View Relatedwhat is the difference b/w rman and oracle secure backup.
View 1 Replies View RelatedI'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.
View 1 Replies View RelatedWe 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)
[code]...
resolve this error.
I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:
Quote:unable to open include file
#include <stdio.h>
and other C library headers.
I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:
proc program.pc
No problems, and I do get program.c.
However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.
We have a non-production Oracle 10g Cluster running on Linux, with DataGuard (logical standby). From time to time, we need to refresh the schema on primary, but to do so as always caused problems with the logical standby. Our DBAs can never get it to complete successfully. They have tried a bunch of different methods (even provided from Oracle), but it does not work. e have a bunch of skip statements on the
Everytime, we need to refresh the schema, we have to build the entire database (primary and logical standby) from production RMAN backup. As you can imagine this is a very time consuming ordeal. There has got to be a way this process can be completed in a timely manner.
I was thinking of the following....
1) shut down dataguard, log shipping
2) lock user, kill sessions, drop user from primary
3) lock user, kill sessions, drop user from logical standby
4) run impdb on production export file on primary
5) run impdb on production export file on logical standby
6) re-enable dataguard, log shipping
7) confirm logs being applied, databases in sync
We are only replicating the one schema to the logical standby. I am not clear on how redo logs would be applied to the logical standby. There are hundreds of them @ 100 mb each, so I would think if we do this independently, I could somehow sync primary and logical standby after the imports complete.
I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).
My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.
I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.
View 4 Replies View RelatedMy requirement is to export Oracle table's data into an already existing excel file with Macros (.xlsm) using a procedure. I am able to write/append the data into the simple .xls file. But I am searching whether any way of appending into .xlsm file. "how can we append the data into a Macro-enabled excel file?".
View 3 Replies View RelatedEnvironment:
Oracle RDBMS 10g R2.
DB OS: HP Itanium
We use Oracle EBS R12.1.2 in our company and one of the analyst reported performance with saving the configuration in Pricing module. The common fix is to gather stats on BOM_EXPLOSIONS table. Recently, when the issue occurred I collected statistics on the table. The performance didnt improve. I went ahead and decided to trace the Oracle form session using the profile 'Initialization SQL Statement - Custom" at user level.
I also monitored the session in OEM 10g grid. The analyst performed the same set of steps and the performance was normal and acceptable. Analyst tried again and performance was matching with the expectation. I cleared the trace profile and analyst tried again. This time analyst had worse performance as the original issue. The issue got fixed later part of the day on its own. This has made me curious and thought to discuss it here.
I have had similar experience with 10g and 11g, when I enable the trace on the issue cannot be reproduced and when trace is off the issue pops back up.
I created a mv for one of the partitioned tables but on viewing the mv capabilities it still shows PCT is set to 'N'.
create materialized view MV_summary_SEC
refresh fast
start with sysdate
nEXT SYSDATE + 1/24
enable query rewrite as
[code]....
If i remove the sub query and create the mview like this,then PCT is enabled.
create materialized view MV_summary_SEC
refresh fast
start with sysdate
nEXT SYSDATE + 1/24
enable query rewrite as
select PERIOD , SUM(SUM_WEB_HITS)
from summary ,date_table
where PERIOD >= DATE_TABLE.CUR_DATE
group by PERIOD
Is it simply because oracle doesn't support PCT if the definition contains subqueries ?
Is oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.
View 1 Replies View Relatedoracle version oracle 10gr2
os: windows 64
from [URL] How to I use secure external password in asp.dot net or c# dot net with reference to [URL]
I've created the wallet, but then how apply it in dot net context?
string connectionString = "Data Source=ARK2;User ID=scott; Password=tiger";
suppose I created a secure db connect string, what should be user id and password?
Is it user id="" password=""
or user_id ="/" password=""
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.
I have no authentication required for my application, but want to secure a few pages.
On the page I wish to secure I have specified that user should not be a public user.
When I click a link to the page I do get a login box, but I seem to be able to enter any old rubbish and still proceed to the page.
How do I secure an individual page without a general authentication scheme at application level, so an Apex user account is needed.
I am having Oracle 9i relaese 2 on my db server. I am getting the following error every time I try to create a bitmap index:-
ORA-00439: feature not enabled: Bit-mapped indexes
I have queried the v$option table .Here the value of parameter Bit-mapped indexes is FALSE.
The result of v$version is :-
Oracle9i Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
Actually when we created the database our installation was halted . so we manually created the database using Create database command.
How can we enable the BITMAP Index Feature now.
I am new to Oracle Workspace Manager. I have a trigger that fills my IDs every time i insert a record. I created the trigger before I enable the version of my table. After version was enabled in my table, I can no longer find my trigger but have these triggers instead:
OVM_DELETE_7 OVM_INSERT_7 OVM_UPDATE_7
What I wanted to do is Query the triggers that I created on my tables. Is there a way to do that without disabling the version on my table? I have too many version-enabled tables and that would be a hassle disabling the version in every table just for that query.
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