|
 |
| Recent blog posts: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Friday, 4 August 2006
|
| Oracle database for Windows Uir Dimant 13:03:43 |
| | Hello
I'd like to download Oracle to my windows xp sp pro
I got ---Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows
and downloaded this file
Download the Complete Files
10201_database_win32.zip (655,025,354 bytes)
The question is , is it ok that I have MS SQL Server on my computer or
should I remove it?
Does the file I downloaded contain a clint tools as well (Enterprise
Manager.....)?
Any other tips while setup is running...
Thanks
|
| |  7 answers | Add comment |
|
| PL/SQL nested loop problem B. Williams 03:52:24 |
| | I have some code that uses for loops and I chaged the outer loop into a
simple loop and inner loop into a while loop, but the out put is coming out
different. The outer loop is supposed to run 3 times while the inner loops
is supposed to run 6 times. Wouls someone look at my code and tell me what I
have done wrong. Thanks in advance.
Original code
set serveroutput on
declare
v_test NUMBER := 0;
begin
<<outer_loop>>
for i IN 1..3 loop
dbms_output.put_line('Outer Loop');
dbms_output.put_line('i = ' || i);
dbms_output.put_line('v_test = ' || v_test);
v_test := v_test + 1;
<<inner_loop>>
for j IN 1..2 loop
dbms_output.put_line('Inner Loop');
dbms_output.put_line('j = ' || j);
dbms_output.put_line('i = ' || i);
dbms_output.put_line('v_test = ' || v_test);
end loop Inner_Loop;
end loop outer_loop;
end;
/
Modified code
set serveroutput on
declare
i PLS_INTEGER := 0;
j PLS_INTEGER := 1;
v_test NUMBER := 0;
begin
loop
i := i + 1;
dbms_output.put_line('Outer Loop');
dbms_output.put_line('i = ' || i);
dbms_output.put_line('v_test = ' || v_test);
v_test := v_test + 1;
exit when i = 3;
while j <= 2 loop
dbms_output.put_line('Inner Loop');
dbms_output.put_line('j = ' || j);
dbms_output.put_line('i = ' || i);
dbms_output.put_line('v_test = ' || v_test);
j := j + 1;
end loop;
end loop;
end;
/
|
| | 1 answer | Add comment |
|
| Proc Exceptional Behaviour......... Spsingh Sunil 01:42:12 |
| | My project has some part of its code written in Pro C. The problem i am
facing is that some times the job which internally uses oracle gives
exception but when the same job is resubmitted the same things work.
Secondly this too happens like onve in blue mooon. Can any body suggest
some good ideas to solve this problem.
|
| | 6 answers | Add comment |
|
| Oracle 64 bit ODBC dirver MParenteau 01:37:43 |
| | I have migrated an application from a windows 32bit platform to Oracle 10Gr2
on a 64bit platform (Windows 2003 server) and am having problems with values
returned from the ODBC interface. All numeric values are returned as 0.
Any ideas what the problem might be?
The platform is a 64bit EMT Windows 2003 server with SP1.
The odbc driver is SQORA32.DLL version 10.02.00.01 dated 9/30/2005.
The program accessing Oracle via the ODBC handler runs directly on the
Windows 2003 server. Stepping through the code gets me to a SQLFetch
statement and the data returned has a length of 1 and it is always "0".
I might add the using the native OCI interface returns the correct values. I
need both interfaces to work to support various customers.
Additionally, this is a common handler for ODBC and when I use the SQL
Server Native ODBC driver to a SQL Database, I get back correct values.
Mike
Unisys
|
| | 3 answer | Add comment |
|
| Locking mode in 10g seems to have changed Guest 01:23:41 |
| | All,
I have an issue with an application that my company created. Locking
code that has been working splendidly for the last 8 years is all of a
sudden breaking as clients upgrade their Oracle servers to 10g.
The locks in question are used for determining the next available
unique id and for locking a record while the user works on its data
(which can take several minutes sometimes). I know some of you are
cringing right now. It is far too late to convert to sequences. It
would be a maintenance nightmare at this point.
Here is the scenario. If a user has a record locked for update and
another user needs to create a new record in the same table (and
therefore needs to lock to get next id) then my app receives an
ORA-00054.
Here is the "lock for editing" script (let's call it script 1):
select <fields> from <table> where <condition> for update nowait
Here is the "lock to retrieve next id" script (let's call it script 2):
lock table <table> in share row exclusive mode nowait
In versions prior to 10g the common scenario is a user will run script
1 and any number of users can run script 2 or script 1 (provided it
isn't for the same record). With 10g any number of users can run
script 1 (on different records, of course) but not a single user can
run script 2 if even one lock still exists from script 1.
If I run the script "select lock_type, mode_held from dba_lock" while a
lock is being held then the following two records are returned for the
process in question on the 10g server:
LOCK_TYPE = DML
MODE_HELD = Row-X (SX)
LOCK_TYPE = Transaction
MODE_HELD = Exclusive
If I run the same script on a 9i server the following are returned for
the locking process:
LOCK_TYPE = Transaction
MODE_HELD = Exclusive
LOCK_TYPE = DML
MODE_HELD = Row-S (SS)
Note the locking mode difference. The same difference can be noted by
looking in v$lock. The 10g process has a lock mode of "3" and the 9i
process has a lock mode of "2".
I get these same results if I manually run the locking scripts from
SQLPlus on the server rather than through our application.
Was this an Oracle oversight? Is there a configuration setting to
control this behavior? Any other thoughts on this?
Thank you for your insight,
- Clayton
|
| | 11 answers | Add comment |
|
| puzzling trigger activity/question... Tg 01:15:13 |
| | database: 9.2.0.6 on msserver 2003
application: 3rd party, populates some tables from external sources
(AS400)using event processor/api
A trigger was created, owned by A, on a table owned by B, to insert
changed records into an audit table owned by A when user C updated,
deleted or inserted records into the table owned by B. The trigger is a
row level after insert,update,delete on the table, no columns are specified.
When inserting/updating/deleting manually as user C all works fine,
trigger fires as expected and audit table is updated. And in a dev
environment letting the external process do the work and changing the
data in the external AS400 database the trigger works fine, changes in
data are committed and audit table is updated.
However in prod database, when the external process does the work the
changed do not get committed when the trigger is enabled. The trigger
does work when changing records as user C manually. No errors are
generated on either the oracle or application side. All users involved
have identical rights etc. on both databases. When the trigger is
disabled the changes made go through fine and are committed. Somehow the
transaction is getting rolled back and I'm not sure where to start looking.
I was thinking maybe using dataminer looking through the redo logs to
see if there was any rollbacks, but have never used it before and have
no idea yet if it will be of any help.
I was thinking of looking into how to debug triggers, but as I said the
trigger fires just fine when records are changed manually.
Suggestions?
tia
|
| | 2 answer | Add comment |
|
| CURSOR_SHARING=SIMILAR Sethu 01:06:06 |
| | Hi,
I am using Oracle 9i (9.2.0.6) on HPUX. I have the CURSOR_SHARING
parameter set to SIMILAR and on testing I believe I may have some
issues.
alter session set cursor_sharing = 'EXACT';
Session altered.
select 'AAA' from dual;
'AA
---
AAA
alter session set cursor_sharing = 'SIMILAR';
Session altered.
select 'AAA' from dual; --- <== found from cache
'AA
---
AAA
select 'BBB' from dual; -- <== brand new one, notice the size of the returned value
'BBB'
--------------------------------
BBB
I read an article in asktom site about this which explains the reason
as Oracle binds the literal string to a variable length constant. My
question is can it create a problem, if my application looking for Y/N
values coming back and the sql returned 'Y ' ?
|
| | 2 answer | Add comment |
|
| How to migrate my oracle database to another server, pls Plactoon 00:17:54 |
| | Hi everyone,
I need to migrate an oracle database to another server, but keeping all
equal, like a mirror, i have my original db in Solaris server, need to
change it to windows 2000 server but, like i said, keeping all, table
spaces, data....
how can i do this?, or where can i find information about it?,
I appreciate ur help,
thx
Plactoon
|
| | 9 answers | Add comment |
Thursday, 3 August 2006
|
| Urgent req Oracle Financial Functional Consultant at Sunnyvale, CA Deepak Kumar 22:13:18 |
| | Hi,
We have urgent requirement for Oracle Financial Functional Consultant
at Sunnyvale, CA.
If you have any consultant or you are qualified and interested then
kindly forward the updated resume to deepak@codesoft.net.
Please find the requirement details below
Role: Oracle Financial Functional Consultant
Location: Sunnyvale, CA
Start Date: ASAP
Duration: 6+ months
Job Type: Contract
Rate: Open
Required Skills:
- Oracle 11i Financials implementation
- Expanding design for introduction of IP entities for tax savings
- Excellent communication skills
Note: You can reach me at 678-528-9691 to discuss more about the
requirement.
Regards,
Deepak
Tel: 678-528-9691
770-913-0101 Ext: 224
deepak@codesoft.net
www.codesoft.net
|
| | 2 answer | Add comment |
|
| Oracle RAC Stored Procedure scalability Guest 21:31:11 |
| | Hi all,
Just wonder how the oracle rac facilitate the stored procedure
scalability issue? Any experience that we can share. Does the oracle
run the stored procedure on a single member of cluster? Is there any
way that make the stored procedure horizontally scale?
I guess one of the possible way is to partition data and issue stored
procedure call on different members of cluster. Does it induce the
network overhead in order to synchronized the table content across the
members of the cluster.
Thanks in advance.
Ivan Lo
|
| | 8 answers | Add comment |
|
| Trouble executing data found on TABLE: exe_sel_dttime_xml (COLUMN: QUERY) Nicolas246@Gmail.Com 20:50:33 |
| | Hello,
I want to execute using EXECUTE IMMEDIATE the data found on a table
exe_sel_dttime_xml
The following code inside a PLSQL procedure constantly gives me coding
problems(therefore not working as it should!!):
BEGIN
FOR r
IN (SELECT QUERY INTO v_toexecute FROM exe_sel_dttime_xml)
LOOP
EXECUTE IMMEDIATE v_toexecute;
END LOOP;
END;
------------------------------------------------------------------------------
Basically what this code is supposed to do is execute each of the data
found inside the COLUMN: [QUERY] found on the TABLE:
[exe_sel_dttime_xml]
ie,
r 1 select * from exe_sel_dttime_xml
2*
QUERY
--------------------------------------------------------------------------------
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_01;
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_02;
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_03;
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_04;
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_05;
SELECT COL_TNAME, DEVICE_DTTIME
INTO table_dttime(COL_TNAME, COL_DTTIME)
FROM t_xml_06;
Remember,
I need this to work using the following:
+ EXECUTE IMMEDIATE
+ Querying the data from table: exe_sel_dttime_xml
(ie, SELECT QUERY INTO v_toexecute FROM exe_sel_dttime_xml)
All (and any) help is appreciated
-ng
|
| | 4 answer | Add comment |
|
| Bulk Collect vs. Insert Into Brandon Raines 20:50:31 |
| | Hi,
I am trying to determine which is a better choice for moving large sets
of data (performance-wise)- a standard SQL statement INSERT INTO ...
SELECT .... or to take the same statement and create a PL/SQL
Procedure that uses BULK COLLECT. If you could also illuminate why one
works better than the other, I would appreciate it.
Thanks!
JR
|
| | 4 answer | Add comment |
|
| BMC SQL Backtrack for Oracle on AIX 5.1 Chan 18:57:44 |
| | I am using sql backtrack from BMC to do a hot/cold backup on our Dev to
test servers.My question is how to copy the sql-backtrack catalog to
the remote host. (During export/import)
|
| | 1 answer | Add comment |
|
| SA_SESSION.SET_ACCESS_PROFILE does not work for PROXY connections, any idea why? Bernard 18:05:34 |
| | I have a situation where I need to set the OLS access profile (and
LABEL) for a user after database login and only after I verified the
user's security level from an LDAP server. The implementation work
fine for normal connections, but users that connect via a PROXY account
does not seem to inherit the rights of the proxy account even though
privileged to change the ACCESS_PROFILE.
What am I missing and what should be changed? Help is very much
appreciated.
I need to use Proxy users and their credentials are locked up in a LDAP
server so I need to check if they can select data only after they have
been verified. So I can not define their access rights beforehand.
See below my test script that demonstrates the problem:
-------------------------
--Usage: (a) Need to have OLS installed
-- (b) Do not run on your production database, this script drops
users
-------------------------
connect sys/oracle as sysdba
drop user midtiersrv cascade;
drop user secman cascade;
drop user midtieruser cascade;
--My AppServer User Also proxy user
create user midtiersrv identified by midtiersrv quota unlimited on
users;
--My Security Manager schema
create user secman identified by secman;
--My Middel Tier User
create user midtieruser identified externally;
--Setup MidTier User as user who can only connect through midtiersrv
proxy user
alter user midtieruser grant connect through midtiersrv;
grant connect to midtieruser;
grant connect to midtiersrv ;
grant connect to secman ;
grant dba to secman ; --To save time
grant unlimited tablespace to secman ;
alter user lbacsys identified by lbacsys account unlock;
connect lbacsys/lbacsys
EXEC sa_sysdba.drop_policy(policy_name => 'TEST1POL');
--Create my Policy
BEGIN
sa_sysdba.create_policy(policy_name => 'TEST1POL',
column_name => 'TEST1POL_LABEL',
default_options => 'READ_CONTROL');
END;
/
grant test1pol_dba to secman;
grant execute on sa_components to secman;
grant execute on sa_label_admin to secman;
grant execute on sa_user_admin to secman;
grant execute on char_to_label to secman;
connect secman/secman
--Create levels
begin
sa_components.create_level(policy_name => 'TEST1POL',
long_name => 'SECRET',
short_name => 'SEC',
level_num => 10);
sa_components.create_level(policy_name => 'TEST1POL',
long_name => 'NOTSECRET',
short_name => 'NOT',
level_num => 5);
end;
/
--Create Labels
begin
sa_label_admin.create_label(policy_name => 'TEST1POL',
label_tag => 1,
label_value => 'SEC');
sa_label_admin.create_label(policy_name => 'TEST1POL',
label_tag => 2,
label_value => 'NOT');
end;
/
--Authorize Users, this is where the problem comes in.S
begin
sa_user_admin.set_user_labels
(policy_name => 'TEST1POL',
user_name => 'CLEARED_USER',
max_read_label => 'SEC');
sa_user_admin.set_user_labels
(policy_name => 'TEST1POL',
user_name => 'NOTCLEARED_USER',
max_read_label => 'NOT');
-- I can not set label for MIDTIERUSER since this users
-- rights are mantained in an LDAP server and based on their
--definition on LDAP we set their ACCESS_PROFILE
end;
/
create table midtiersrv.test as select rownum aid from all_objects
where rownum < 100;
grant select on midtiersrv.test to midtieruser;
-- Apply the policy before we update the data
BEGIN
sa_policy_admin.apply_table_policy
(policy_name => 'TEST1POL',
schema_name => 'MIDTIERSRV',
table_name => 'TEST',
table_options => 'NO_CONTROL'
);
END;
/
-- Set all records to higest
UPDATE midtiersrv.test
SET TEST1POL_LABEL = char_to_label ('TEST1POL', 'SEC');
commit;
UPDATE midtiersrv.test
SET TEST1POL_LABEL = char_to_label ('TEST1POL', 'NOT')
where aid <= 10;
commit;
--Apply pplicy for good
BEGIN
sa_policy_admin.remove_table_policy
(policy_name => 'TEST1POL',
schema_name => 'MIDTIERSRV',
table_name => 'TEST');
sa_policy_admin.apply_table_policy
(policy_name => 'TEST1POL',
schema_name => 'MIDTIERSRV',
table_name => 'TEST',
table_options => 'READ_CONTROL');
END;
/
-- Give SECMAN the rights to change ACCESS POLICIES
begin
sa_user_admin.set_user_privs
(policy_name => 'TEST1POL',
user_name => 'SECMAN',
PRIVILEGES => 'PROFILE_ACCESS');
sa_user_admin.set_user_privs
(policy_name => 'TEST1POL',
user_name => 'MIDTIERSRV',
PRIVILEGES => 'PROFILE_ACCESS');
sa_user_admin.set_user_privs
(policy_name => 'TEST1POL',
user_name => 'MIDTIERUSR',
PRIVILEGES => NULL);
end;
/
-- Just to prove it works, see results from following selects when
-- changing the ACCESS_PROFILE
connect secman/secman
set col SEC_LABEL a25
select count(*) "No Access Set",
sa_session.label('TEST1POL') SEC_LABEL
from midtiersrv.test;
exec sa_session.set_access_profile ('TEST1POL','CLEARED_USER');
select count (*) "CLEARED Policy Set" ,
sa_session.label ('TEST1POL') SEC_LABEL
from midtiersrv.test ;
exec sa_session.set_access_profile ('TEST1POL','NOTCLEARED_USER');
select count (*) "NOTCLEARED User Policy Set",
sa_session.label ('TEST1POL') SEC_LABEL
from midtiersrv.test ;
-- I'm using a Application Context to maintain tags on privilages
drop context test_context;
create or replace package secman_pkg as
procedure set_access;
end;
/
create or replace package body secman_pkg as
procedure set_access as
v_ldap_result varchar2(100);
begin
-- Do some lookup on LDAP using DBMS_LDAP. Get following back form
LDAP lookup.
v_ldap_result := 'CLEARED_USER';
dbms_session.set_context('TEST_CONTEXT', 'SECLEVEL',
v_ldap_result);
sa_session.set_access_profile ('TEST1POL','CLEARED_USER');
end;
begin
null;
end;
/
create or replace context test_context using secman.secman_pkg;
-- Now I need to be able to define the access for users based
-- on their LDAP entries. Will do this during database login
create or replace trigger secman.set_user_acces
after logon on database
declare
v_ldap_result varchar2(10);
begin
secman.secman_pkg.set_access;
end set_user_acces;
/
-- Now lets connect and test to see if it works?
prompt Normal Connection from SECMAN
connect secman/secman
select sys_context ('TEST_CONTEXT','SECLEVEL') Context from dual;
select count(*) "No Access Set",
sa_session.label('TEST1POL') SEC_LABEL
from midtiersrv.test;
-- Now the lets test the trigger and authentication
-- procedure for the MIDTIERSRV
prompt Normal Connection from MIDTIERSRV
connect midtiersrv/midtiersrv
select sys_context ('TEST_CONTEXT','SECLEVEL') Context from dual;
select count(*) "No Access Set",
sa_session.label('TEST1POL') SEC_LABEL
from midtiersrv.test;
-- But when I connect as the MIDTIERUSR user via the MIDTIERSRV proxy
user
-- it all goes WRONG!!!
-- Why does the proxy user and the owner of the procedure that changes
the access
-- profile not have the rights to do so when the connection is a proxy
connection.
prompt Proxy Connection of MIDTIERUSER via MIDTIERSRV
connect midtiersrv[midtieruser]/midtiersrv
select sys_context ('TEST_CONTEXT','SECLEVEL') Context from dual;
select count(*) "No Access Set",
sa_session.label('TEST1POL') SEC_LABEL
from midtiersrv.test;
|
| | 1 answer | Add comment |
|
| data guard question Extents 16:25:15 |
| | Hi
Can you help me with this scenario pls.?
Oracle 9.2.0.6 on HPUX
Suppose I have a production database with redo log size of 50MB.
Generally we have about 3-4 log switches a day. There are days we have
50-60 log switches a day. Using data guard how do I ensure that the
standby database is always not less than 1 hour behind the production?
What I mean is on any given day we wont lose more than 1 hours of data.
Thanks
|
| | 3 answer | Add comment |
|
| using SELF in object method EliSiR 14:57:23 |
| | Hi all,
I'm experiencing some difficulties working with object's methods with
Oracle 10g. I'm trying to build a set of methods that manage some nested
tables used into an object, but I've found some problems when working
with the self parameter.
In order to retrieve the right and unique object to update from the
table I need to know the invoker's ref. Well I've tried for long to use
the REF function with the self parameter without any success! It's due
to the REF definition that need a correlation parameter as argument I
think. So something like
select ref(self) into var from dual;
won't work. I've used this trick even with other variables but nothing
happened so it seems a limit of ref function. Well I dunno now how to
get the ref I need...is the only one thing to do to pass the right ref
as parameter completely ignoring self?? It's not exactly an elegant
solution in my opinion...
I'm wondering why they passed self as object and not as ref of
object!!With the ref I would have done all tasks even cause the deref
function is designed to take all parameters insted, not only correlation
ones!!!
My second problem was found when trying to update object's attribute
using self!Well something like self.attribute:= value affects the object
only within the method. When I query the table the object is exactly as
before calling the method....
I've tried even explicitly declaring the self parameter as "IN OU" even
with the "NO COPY" compiler directive without any success. If the object
is passed to method not copying itself...why the changes doesn't remain
outside the procedure???
Sorry for the long message...I've tried to explain all in few words..but
as you cans see...my doubt aren't few. I hope to read some suggestion
from more experienced users...tnx everyone.
Best regards,
Davide
|
| | Add comment |
|
| newbie : getting rid of IN clause Dn.Perl@Gmail.Com 10:09:30 |
| |
I have two tables :
table t1; fields : name old_qty new_qty
Entries : ('aa', 100, 115) and ('aa', 122, 222)
table t2; fields name qty_change
Entries : (aa, 15) (aa, 100) (aa, 92)
I want to find entries in t2 whose qty_change is not 'reflected'
in table t1.
Wrong query :
select t2.* from t2, t1 t1
where t1.part = t2.part and new_qty - old_qty <> qty_change
-- and not exists (
-- select null from t2 aa where t1.part = aa.part and new_qty - old_qty
= aa.qty_change)
-- )
(Even when the above 3 lines are uncommented, the
query is still wrong.) It's obvious why the query is wrong
but I somehow thought that a clause on the lines of
select ... FROM t2 t2, t1 aa, t1 bb where ...
(with t1 used twice in FROM list) would be the best
way to write the query.
Correct query :
select * from t2
where (part, qty_change)
not in (select part, new_qty - old_qty from t1
where t1.part = t2.part)
But does a better way to write the query exist?
(Both tables have a 'timestamp' field which serves as primary key.)
Please advise. TIA.
|
| | 3 answer | Add comment |
|
| Formatting output using utl_smtp? Guest 09:50:31 |
| | Hi,
I've generated an email using the utl_smtp.write_data function on
Oracle 9i. Is it possible to format the data a bit...mainly to center
it?
I am trying to generate data similar to this format:
ID Name Action
----------------------------------
123 Stacy Update
23445 Brian Add
Each of these items are retrieved through a cursor. Any ideas?
|
| | 1 answer | Add comment |
|
| Kernel parameters for Oracle 9i on HP-UX 11i Alexander Skwar 05:29:15 |
| | Hello!
"Once upon a time", I found a document on metalink which described
recommended kernel parameters for Oracle 9i on HP-UX 11i and other
operating systems. But I can't remember the doc id or what search
terms I used to find it.
Maybe some of you know this document? If so, could you please be
so kind and post a link/id?
Thanks a lot,
Alexander Skwar
--
Liebe ist nur ein anderer Ausdruck fГјr Schweinerei.
-- Berthold Brecht (Herr Puntila und sein Knecht)
|
| | 4 answer | Add comment |
|
| archive log maintenance on physical standby EdStevens 03:16:35 |
| | Platform: Oracle 10.2.0.1.0 on Solaris 5.10
DataGuard with physical standby. Daily backups of the primary are
keeping archivelogs cleaned out and usage of recovery_file_dest
constant.
On the physical standby db, archives are being received and applied,
but no housekeeping seems to be done. Usage of v$recovery_file_dest
keeps climbing.
I queried v$archived_log on the standby to determine oldest known (to
the db) archivelog, then manually deleted all the older stuff from the
recovery file dest. (nearly a month's worth), but the value of
v$recovery_file_dest.space_used continues to climb.
What is best practice for keeping the recovery file dest from filling
up and stalling the archiver process on the physical standby?
|
| | 1 answer | Add comment |
|
| RMAN / controlfile / TDPO issue Evan Ehrenhalt 01:58:58 |
| | HELP!!!
We are seeing an intermittent error when using RMAN to backup our
archive logs.
The archive logs are moved to tape and deleted, but there are errors on
the controlfile backup. Whenever this happens, the logs themselves seem
fine. Just the controlfile fails to backup.
Can anyone tell me why the controlfile backup would cause this error,
when the archivelog backup goes fine?
Here is the background:
Oracle 9.2.0.6 + security patches.
RMAN is 9.2.0.6.0 (same ORACLE_HOME)
Tivoli Data Protection for Oracle (TDPO) 5.2.0.0
----------------- RMAN Logfile ------------------
Starting backup at 28-JUL-06
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=103986 recid=102783 stamp=578189102
channel c1: starting piece 1 at 28-JUL-06
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=1 sequence=103987 recid=102784 stamp=578189702
channel c2: starting piece 1 at 28-JUL-06
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 07/28/2006 00:20:02
ORA-19506: failed to create sequential file,
name="DB1P_ARCHIVE_20060728_578190000_s19709_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS1017E (RC-50) Session rejected: TCP/IP connection failure
RMAN>
----------------- RMAN SCRIPT ------------------
RMAN script and settings:
connect target /
connect catalog $logn
configure backup optimization on;
configure default device type to 'sbt_tape';
configure channel device type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
configure controlfile autobackup on;
run {
allocate channel c1 type 'sbt_tape' parms
'ENV=(DSMI_ORC_CONFIG=/opt/tivoli/tsm/client/oracle/bin64/dsm.opt)';
backup filesperset 10
format '%d_ARCHIVE_%T_%t_s%s_p%p' tag '$ORACLE_SID Archive'
(archivelog like '/u01/app/oracle/admin/${ORACLE_SID}/arch/%' delete input);
release channel c1;
}
----------------- Typical Tivoli Log ------------------
***** Each backup has a start, a number of bytes send, and an end.
***** In this example, 205017,
***** It starts,
***** backs up R25PROD_ARCHIVE_20060731_597246624_s29484_p1
***** Size 33554432 bytes,
***** then ends.
07/31/06 13:50:25 ANR0406I Session 205017 started for node URANIAORA
TDP Oracle SUN) (Tcp/Ip 170.140.13.75(41834)). (SESSION: 2050
07/31/06 13:50:35 ANE4991I (Session: 205017, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2535I File
/adsmorc//R25PROD_ARCHIVE_20060731_597246624_s29484_p1 = 33554432 bytes
sent (SESSION: 205017)
07/31/06 13:50:35 ANR0403I Session 205017 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205017)
***** Controlfile success
***** Start backup controlfile by deleting the old copy (never exists).
07/31/06 14:20:23 ANR0406I Session 205103 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(42121)). (SESSION: 205103)
07/31/06 14:20:23 ANE4994S (Session: 205103, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2602E The object
/adsmorc//c-2375565327-20060731-00 was not found on the TSM
Server(SESSION: 205103)
07/31/06 14:20:23 ANR0403I Session 205103 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205103)
***** Now do the actual controlfile backup:
07/31/06 14:20:23 ANR0406I Session 205104 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(42122)). (SESSION: 205104)
07/31/06 14:20:24 ANE4991I (Session: 205104, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2535I File /adsmorc//c-2375565327-20060731-00 =
1835008 bytes sent (SESSION: 205104)
07/31/06 14:20:24 ANR0403I Session 205104 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205104)
***** Control file failure, it looks like this for a failure
07/31/06 13:50:35 ANR0406I Session 205020 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(41837)). (SESSION: 205020)
07/31/06 13:50:35 ANR0403I Session 205020 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205020)
No action, just a start, then an end. While on the RMAN side I get the
error above.
Any thoughts?
Thanks
|
| | 6 answers | Add comment |
|
| Oracle Apps Requirement Luckystarduke 01:35:58 |
| | Hello All,
We have the following requirement.
Please send matching Profiles along with the Rate Expectations,
Availability and Contact Details of the Candidate for the same.
Strong Oracle Developer with experience in Oracle applications
financials modules (Accounts payable, Purchasing, iprocurement,
iexpense, and general ledger). Primary responsibilities will be doing
production support for all financial modules fixing day to day issues.
Should be strong in following skills:
Oracle work flow, PL/SQL, Oracle Reports and Oracle forms.
Java, Oracle Applications framework (OAF) are plus.
Location:- Chicago,IL
Duration:- 5 months
Rate:- Open
Let me know if you need more information on the same.
Many Thanks,
Renuka
Technical Recruiter
KLM Software Services Inc.
1111 N. Plaza Dr
Suite 101
Schaumburg, IL 60173
Tel : 847-995-9556 Ext 212
Fax : 847-995-9557
NOTE : This email is not intended to be a solicitation. It is targeted
to recruiting and consulting professionals. If you have received this
in error, please accept our apologies and to be removed from our
mailing list reply to renuka@klmss.com with "REMOVE" in the subject
heading and your email address in the body. If you have already asked
to be removed, and are currently continuing to receive our emails,
please send us the any older or alias email address/es. This sometimes
are forwarded to the new email address and we must delete these older
or alias address/es from our list in order to stop mail from reaching
your current address. We regret any inconvenience caused to you and
sincerely appreciate your continued patience and cooperation.
|
| | Add comment |
|
|
