 | | | Oracle List | | Greetings
I am attempting to install Oracle and create the ASM instance and am
using oracleasm to configure the disks. I am installing Oracle
10.2.0.1.0 Enterprise Edition on RHEL3. The disks look l
Did you run the clusterverify (cluvfy) sucessfully?
Did you create the partitions for ASM disks and set the ownerships
correclty.
Were you able to read the asm disks from all the nodes.? (simple dd)On 04/04/2007 12 49 00 PM ryan_gaffuri@(protected) wrote
> I checked the certification matrix on metalink and Redhat 5 is not on it. Its been out for a couple of months. Out sys admin wants us to moYou don 't mention a version but if it 's relatively recent then this
select * from v$sort_usage
should tell you what you want to know.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQueHi Sanjay
You should be able to change your host ip to the vip ip for the service
associate with the database you are connecting to and the sid the that
service. You would in theory have then failovOn 04/04/2007 12 17 20 PM fmhabash@(protected) wrote
> Hi all
>
> has anyone used the AIX command 'migratepv ' to move Oracle files (raw or
> cooked) online outside of Oracle?
Where is "outside ofI don 't know anything about it but I just googled it too and all the
links for free downloads and Alexey 's websites seem to have been
shutdown so I guess Rampant owns it.
-----Original Message-----Query USER$ to get the list of users whose passwords are coming up and
send them email.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On BehalHi List
Anybody running 9i client on a 64 bit Windows 2003 O/S?
Thanks
Roger Xu
Senior Staff Analyst
Cadbury Schweppes PLC
P please don 't print this e-mail unless you really need to.
-------Hi
There is this new feature in 10g that allows you to authenticate roles based
on packages. You can use that feature for this situation of yours.
create role < > identified using schema.package
Here is a link to a description of how to do it quicker than a full
exp/imp by using transportable tablespaces
http //asktom.oracle.com/pls/asktom/f?p 100 11 0 P11_QUESTION_ID 3002
0192108317#608Is it still true that CPUJan2006 is the first CPU that must be applied and
then additional CPUs can be applied?
I am being told by a vendor that
1. Applied CPUJan2006
2. Applied CPUJan2007 whiHow about disparador - could be a synonym for gatillo.
The thing abouut Spanish is it could be difficult to translate a colloquial word like trigger. Maybe the pharse "disparador del c?digo del progIf only the first computer scientists knew that possibility to sue...
On 04/04/2007 02 07 25 PM Brady Mark wrote
> Could you add a DDL trigger on before alter of that package to check
> existence of the table and create it if missing? The package will still
> go invYou might find this post by Mogens N?rgaard useful
http //wedonotuse.blogspot.com/ "DBVerify? I think not. ".
Stefan
On 4/3/07 Manmohan Jalsingh <mjalsingh@(protected) > wrote
>
> Hi
>
> Has anyonThe SAN/Systems Administrators claim its possibly to have a Site A/Site B setup(at two locations). Use SRDF asynchronously to populate and keep both sites active.
1. I don 't think its possible to acHi Folks
We have a report query with bind variables. This query has 20 sql_childs.
when we use literals which are taken from the sql_bind_capture view the
query uses the optimal plan.I have invalidatHello
In Oracle 8 when performing a select query on another database threw DB
link Oracle opens a transaction that could only be closed by commit or
rollback. That could be harmful when developersWe have noticed that Streams generating more than 5x Redo on Master when TXN_LCR_SPILL_THRESHOLD set to Infinite and when we updated 300K rows in one txn. From the stats we captured during the test iOn 4/2/07 Steve Adams <steve.adams@(protected) > wrote
>
> The list server does not appear to be sending out rejection notes for
> posts that are rejected as too big. I have therefore added the follAre you both running the query with the exact same bind variables
values? Any chance he ran the query for a more popular value? Perhaps
he 's not running it that way now but maybe he did earlier wheHemant
If I understand this correctly the issue is around the redo overhead imposed
by DELETE. If you are licensed to use partitioning then you can try out a
DIY refresh using a partition swap meth
As an exercise or thought experiment how would I "throttle " (ie
control the rate of)
an Oracle Database session 's I/O ?
For CPU utilisation I could use "nice " or "renice " but what about Tusc does some but
1) Are they descent in your area? Our are for database not much else
2) You have to sign a contract for like 8 hours a month and you can give them some things to do for Oracle (or maybe sqlplus) coverts all text entered to upper case by default.
Try putting the name of the object in double quotes.
Stefan
On 4/2/07 John Dunn <JDunn@(protected) > wrote
>
> I do a selHi
oracle recently did a soft audit in our organisation to find out what they
call "real usage " of Oracle database licenses. To do this they counted all
users of all databases or if the nr of OraclWRT 9.2.0.8 there 's only one thing that 's bitten us and it only applies
if you have any SQL embedded within a PL/SQL block that gets data via a
database link from another 9.2.0.8 database on a plaHi Andrew
I 'd be interested in such a matrix too -- I 'll be able to add tru64 and
hp-ux to that. Perhaps others.
Stefan
On 3/31/07 Nigel Thomas <nigel_cl_thomas@(protected) > wrote
>
>
> Andrew
>
Bala
Check your alert log - you 'll probably find an ORA-7445 in there along with
a message pointing to a trace file with the core dump. In that trace file
you 'll find the offending sql statement. Th |
|
|
