 | | | Oracle List | |
Hello
I need to disable regular user logins to the 10g console. I must not be
using the right set of words in Metalink search as I 'm unable to find
anything there (or via google search) how to pre
none that I know of. BTW that hash function changed in 10g since the
HV are alphanumeric instead of numeric only.
Raj
On 9/21/06 Adi Hirschtein <adi@(protected) > wrote
>
> Hi Guys
> I 'm tryingNo I do not confuse. I just was not 100% sure if Oracle can do it
because I 've never tested it myself.
The point is I 've never used this option is that together with Data
Protection one wants HighYou might like to investigate http //inpowersoft.com/
Though I have no experience with the tools I have seen a demo.
On 9/20/06 dba1 mcc <mccdba1@(protected) > wrote
>
> we plan to migrate ORACLE We have certain Users running queries that frequently
fill-up the TEMP tablespace. Is there a way to
specify quota on TEMP. We are on 10gR2 and I already
found that this stopped working in 10gR2 (itA select into query must return ONE and ONLY ONE row. Anything else is
an error! Your query returns no rows. There are no_rows and
too_many_rows (check correct spelling) exceptions provided. Look Thanks for your help.
I was able to create my standby last night.
Yes the "disconnect from session " works just like nohup
and it has nothing to do with disconnecting from the current
SQL*plus sessioHi list
Any thoughts or comments on Oracle and TimesTen database?
How useful is this software?
--
Best Regards
Syed Jaffar Hussain
8i 9i & 10g OCP DBA
I blog at http //jaffardba.blogspot.com/
Cleveland Ohio company needs a DBA to join their staff. Must Have
Oracle Applications DBA experience.
This is a fantastic reputable company offering a great work
environment great people and a chI am clearly attempting something silly here but bear with me.
There is a linux patch for grid control 10.2 which adds in monitoring
for E-Business suite - Patch 4678538 on metablink. So I thought What Kind of a TBS is this ???
- G
On 9/20/06 Alessandro Vercelli <alever@(protected) > wrote
>
> Hi all
> I needed to change storage parameters for a table partion
>
> SQL > select table_name part
Quite Dangerous ?! b Worthy of a Critical CPU
(can be seen as a Vulnerability)
The latest Rediscovery for 5458753 is
"*** 09/19/06 09 54 pm *** Rediscovery Information
1. if the application design This morning I found this bug which " can occur much more easily " in
10.2.0.2 onwards and the workaround is so funny.
Essentially this bug happens when you have more than one schema with
identical t > it might be finger-in-the-air time. Does anyone have sizing information
> for flashback database logs?
> How do they compare in size with say the archive logs created over the
> same period?
CA follow up
The OS mirror issue means that system admin must unfortunetely be quite
involved in the failover process or DBA must take some tasks from
sysadmin. I used to work in such an environment
On 09/20/2006 04 29 21 AM seron wrote
>
> Have you got any suggestion how to resolve my problem? I know that
> change server hostname resolve this problem but it doesn 't recover BUG )
>
> Be
Hi Mladen
> > Mladen Gogala <mgogala@(protected) > 09/20/06 02 46pm > > >
> > PRAGMA EXCEPTION_INIT(CONFUSE -600)
> > and then
> > WHEN OTHERS THEN
> > RAISE CONFUSE
> > END
> > That would be a <html > <div style 'background-color ' > <DIV class RTE >
<P >I 've used stored outlines in our production environement. Most of the times it works fine. Howver I 've noticed that after databaseif that is being done as part of another job there is long standing
bug that prevents all SQL run as (part of) a job is marked with
address '0 ' or '00 ' in v$ and hence you can 't detect through v$.
Pwe have a DELL server with Redhat AS 3.4 installed. I
found one of ORACLE file have wield size (ORACLE
9ir2). I used "ls -al " look it and it show very
large but if I check it inside ORACLE and An Oracle session is not the same as a SQL*Plus session running on the
OS. Did/can you verify the session is still active in that instance
after that command is issued?
rr
On 9/19/06 Bobak Mark <Mark.Bobak@(protected) > wrote
>
> Brian see MetaLink Doc ID 222813.1 "How to Automate Startup/Shutdown of
> Oracle Database on Linux ".
>
I had not seen that note previoDid you check if you are behind a firewall and that is pushing a idle timeout
- Ganesh
On 9/19/06 Shreeni <shreeni@(protected) > wrote
> My TOAD connection time-outs almost every 10 mins of idleThere are no miracles in this world.
A few quotes from
http //www.primebase.com/xt/download/pbxt_white_paper.pdf
PBXT is transactional but only writes data once namely to the log.
This has a n________________________________
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Wolfgang Breitling
> In addition to my warning about "inappropriate " use of I did 9.2.0.1 - > 9.2.04- > 10.2.0.1 on Linux without any problems.
like anything test it first.
On Sep 19 2006 at 09 33 AM bill thater wrote
> problems? gotchas? collateral damage? don 't do it Wojciech
Ghassan is correct. The only user in this file is dbsnmp. This is the
account that the 10g Agent uses to connect to the database. There
should be no other user in this file.
Tom
How do you fix a looping chain of syns? Drop the synonym and recreate the
public synonym?
sys@(protected) > create or replace public synonym DBA_AUDIT_TRAIL for
DBA_AUDIT_TRAIL
2 /
Synonym created.
s
>I have question about directory which is created by command "create
> directory ..... "
>
> Is it possible to list contents of directory from sql. If yes could you give
> me answer.
In 10G you can |
|
|
