 | | | Oracle List | | Hi
Assuming your controlfiles will be in 2 disk groups +DG1 and +DG2
do the following
-alter database backup controlfile to trace
-Shutdown the database
-Edit the controlfiles parameter tSandeep
Like several have said there is a way to tunnel DG arch log shipment over
ssh.
I was on site where we did it (we did it for compression not security).
In the end it caused is problems so wDont you see this error?!
Error listening on (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST rac02.risc.com
)(PORT 1522)))
TNS-12542 TNS address already in use
TNS-12560 TNS protocol adapter error
TI just finished installing Oracle on a Sun v40z 4-way dual-core
opteron system. I didn 't worry about the environment variables that
you mentioned but thought I 'd pass along something in case you areHi
Does synchronism matter here? Whether the update in the second database has
to happen synchronously/asynchronously with the changes in first database.
On 1/25/06 Stephane Faroult <sfaroult@(protected)Been racking my brain to see if there is a more... elegant architecture for
the following
- Largish Oracle-based web app... fairly heavy traffic up to 200GB of
application data. 10g pretty fast sI don 't know...this just made me laugh
Only on Linux would one find such literal and direct documentation.
[root@(protected) root]# more /usr/src/linux-2.4.21-4.EL
/Documentation/sysctl/README
DocumentaMichael
qksmm stands for memory management services for the SQL compiler. Which is the version of the database?. If you are on 10g then you can try to set _smm_trace 65535 and a trace file should betry http //unxutils.sourceforge.net/
you dont need to install AFIAK just unzip in a directory and put that in
the PATH
regards
LSC
On 1/24/06 Jesse Rich <Rich.Jesse@(protected) > wrote
We use ASM with PowerPath on EMC storage. Check with EMC on their ASM to see
if it will work with EVA8000.
Raj
On 1/24/06 Kurth Michael J. <mkurth@(protected) > wrote
>
> Is anyone using ASM in a Hi Dex
As per security point of view you should be aware of security policies. Yes you are try abotu DBM_RANDOM package as this is again one of the issue.. and you should revoke the public priv
Afternoon Raja
> > when the below is run i am getting the error. can someone help me
> > begin
> > execute immediate ' select sysdate from dual '
> > end
you need to remove the ' ' fHi
You can 't refer an object like that you need to make the update as an
dynamic sql like
execute immediate x.table_name|| ' set trnx_date null '
/Johan
On Tue 2006-01-24 at 02 33 -0800 raja raoI think this could be useful
SQL > create table my_test_table2 (y number(2) x number(5))
Table created.
SQL > insert into my_test_table2 select 1 rownum from all_objects where
rownum < 7
6 rowFor rebuild operations twice the index space is used during the rebuild as Oracle constructs the new index from the old one.
The space is released once the index is rebuilt.
Roger Xu <roger_Define "stale statistics ".
As far as I am concerned there are two types of statistics - those that
accurately or adequately describe the data in the table for the
purpose of the optimizer - and tHi All
Have a table like ...
FOLDER_ID PARENT_ID
All
Our client is planning to migrate their OLTP application from Oracle 8.1.7
to O9iR2. The current database size is 750 GB.
What is the best method to upgrade the database ?
1. Export/Import fuhi all
I have one small problem. Below is my query which is running on the sql
prompt
*select username|| '( '||sid|| ' '||serial#|| ') ospid ' || process || '
program ' || program username to_charNo but almost. We 're from Ann Arbor and have a place in the
Boyne/Petoskey area. I 've been searching (in vain) for any DBA activity
in the environs...
The code below (thanks Henry) works fine...but I 'm unsure of the mechanics
of assigning to and referencing elements of a nested table.
loop
v_localddls dbms_metadata.fetch_ddl(v_handle)
The VERY BEST place I 've found for these kinds of questions is on the
HTML-DB Forums on Technet.
Sergio Leunissen (the product manager) and Scott Spadefore (one of the
key developers) are on there aBtw things get more fun in 10.2 you can pin cursors without getting library cache pin latch using KGX mutexes. Mutexes are new thing in 10.2 and they enable shared access to objects in somewhat simDear DBAs
> > >
> > >Ah at last somebody who doesn 't like Unix. I must say that
> > >I find dire faults
Actually I like Unix... I think Linux deserves contempt
in place of the lavish praise it gets. The "I hate MGints Norman
Thanks for your replies. I have a better understanding
of what 's going on.
Oracle support did get the original to work but they did it on a
9.2.0.7 database.
I 'll see If you want to use HTML-DB without the need to install Apache or HTML-DB
itself just download and install Oracle-XE from OTN. Its Oracle 's free
version of 10gR2 and comes pre-installed with HTML-DB aI am reading Oracle docs and it states in the 9i Rel 1 release readme notes
that
LOB columns cannot be stored in AUTO SEGMENT SPACE MANAGED tablespaces
But I have a partitioned table (9iRel2) witIf I recall correctly you even have to have at least 1 (presumably 2)
parallel processes per instance to be able to query gv$ views.
Otherwise you will see just data from local instance even queryingHave you tried
recover datafile ' <full_path_of_datafile > '
alter database datafile <full_path_datafile_name > online
Regards
Joseph Amalraj
Juan Carlos Reyes Pacheco < |
|
|
