Hi Chris,
Nice idea!,
Out of interest I was looking for a way to hide or alter the listener
banner info when i was writing the Oracle security step-by-step book for
SANS but i didn't consider how to alter the banner info for the server
as well.
I wanted to find a way to hide banner info to sto
Ok, I like vi, that's why I turn on vi emulation in emacs. I use vim for
quick file viewing because it loads faster than emacs. But, over time, I've
found that emacs gives you a load of little extras that suck you in and
become indispensible. A few that spring to mind: -
- jde - java IDE, does
I have found the following link. It might be what you are looking for
http://home.nc.rr.com/jtlayton/oid2openldap.html
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 29, 2003 10
Hi Yannis (or John ?)
That's GREAT. Exactly what I was looking for. I'll play around with it on
the weekend and give some feedback to the list next week (if somebody is
interested, that is).
Thanks a lot !
Stefan
-Ursprüngliche Nachricht-
Von: Hatzistavrou John [mailto:[EMAIL PROTECTED]
when we were using oracle8i , whe had some process which use "set transaction use
rollback segment".
and now we use undo tablespace and we have still same porocesses .
how can set a rollbback segment for process with undo tablepsace
--
Please see the official ORACLE-L FAQ: http://www.ora
Hi!
You can't anymore.
Either:
1) remove set transaction commands from your scripts
2) if can't remove 'em, set undo_suppress_errors=true in spfile/init.ora
that your scripts wont error out
3) use old fashioned rollback segments - set undo_management=manual in
parameter file.
Tanel.
- Origin
Thanks for this David, it's given me somewhere to start!!!
Cheers
Lee
-Original Message-
Sent: 28 July 2003 17:35
To: Multiple recipients of list ORACLE-L
Here's mine with references to optional packages (mainly jde) removed. Its
set up for windows and cygwin, so if you're using someth
I am looking forward to your feedback.
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 29, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Hi Yannis (or John ?)
That's GRE
Did anybody get to download the presentation? When I try and get it form the
NJ downloads page I get a:
The requested URL /download/Oracle PRN Streams.ppt was not found on this
server.
message. I would very much like to read this.
Thanks
T¬
_
Tim Onions
Speech M
Hi!
Shared pool latch protects memory allocation and de-allocation in shared
pool. Thus probably you have a very volatile shared pool currently. You have
several options, first of them would be to check whether you'r application
is using bind variables. If it is mostly using literal values in SQL,
Im using the osborne OCP books for review. They say you can do
analyze table validate structure into
I do that I get ORA-14510 only place its documented is on metalink and it says:
Error: ORA 14510 Text: can specify VALIDATE INTO clause only for partitioned tables
-
Tim
I am attaching the file to your Email Id Directly and will also pass the message to the support team of the site for correction.
Indy Johal
Tim Onions <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/29/03 08:11 AM
Please respond to ORACLE-L
To: Multiple rec
Resending this email, hoping for a reply this time.
Date: Fri, 25 Jul 2003 07:49:24 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Hemant K Chitale <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From:
imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp
log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs
touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608
Scenario:
I ran this command (as instructed by the tier III tech), got a couple of
warnings b
Tanel,
I think that you've had some unfortunate experiences with RAC. Mind
elucdating them ?
I don't see nodes hanging when one node dies [I'm running a 2-node Tru64
RAC Cluster]
Hemant
At 03:04 PM 28-07-03 -0800, you wrote:
However,
failed transactions must be handled from client side. Queries
Hi all,
Can somebody explain how you can have NULL value for BYTES field in
DBA_DATA_FILES? However, V$DATAFILE view shows the correct size under BYTES
field.
Query the SYS.X$KTFBHC, ktfbhccval field is equal to 1 for the offending
datafiles.
Tempting to bounce this production database later if
Hi,
I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server
and Oracle 7.3.4 client on my NT4 machine. When I connect to
remote/local databases through TOAD 6.5 (which supports LOBs) and
try to fetch a CLOB value I get the 'ORA-03115: Unsupported
network datatype or representation'.
I thi
I sent a reply on that day. Here it is, once again.
Date: Fri, 25 Jul 2003 12:25:59 -0400
Subject: Re: Question about EXTPROC and vulnerability
Hemant,
You are right in wondering why there are three steps.
1. The lsitener must not be listening for the EXTPROC connections - that is
the first l
Title: RE: ORA-03115 (TOAD question!!)
It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem.
Raj
Rajendra dot Jamadagni
We are using AQ for long time . No problems so far .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 8:29 PM
> Hi,
>
> I am looking at using Oracle AQ to post messages.I know they are just like
> any other database tab
Not sure but this might have something to do with charset (if toad can
handle clob??? ) . what is db charset ? is it utf8 .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 8:19 AM
> Hi,
>
> I have Oracle 8i Enterpri
Hi All,
Please help me tune this i/o related wait event. This is my 8.1.6 statspack
top-5 wait list:
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
--
Hi Hans,
direct path write cause would be writing temporary segments when sorts are
too large to be performed in memory, direct path operations like INSERT /+
APPEND or LOB access.
It's hard to guess which one is causing your problems, so I'd suggest you
profiling the call having performance issu
Hi Stephen,
No imp wouldn't close or otherwise impact Oracle instance. I'd look at
init.ora . Someone could make changes there, effective at reboot time
Vadim
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
im
Title: Message
Hrrrmm
- well, we've never seen the problem you describe, and we've got a pretty big
RAC environment here (clusters from two to six nodes, and we combine dev
clusters to build bigger ones as we need). What the situation you describe
sounds like is what happens when there's
> Hi
>
> I use vi on Unix and textpad on windoze. I like to write macros for vi
> so it types repetitive code for me...:-), although I should
> probably use
> an editor with more powerful macro facilities.
>
> cheers
>
> Pete
Pete! Another textpad fan ... way to go! An outstanding text editor for
Hans
I did a search on Google, and found this article:
http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0206/ora-020638/ora02062414
_22868.html
(you'll probably have to patch the link together)
According to this article, your biggest and second biggest wait may be
connected.
Dennis Williams
DBA
I am trying to find any info on if there is a maximum number pf processors that a
server can have and have Oracle standard edition run on it. Just looking to see if
there is a cutoff point in the number of processors where I would be forced to go to
Enterprise Edition of Oracle 8i.. I'm lookin
Two things to check immediately:
(1) Is the Oracle service defined as started automatically in the services?
(2) If yes, is there any error reported in alert log of the database?
Import does not shut the database down.
HTH
Arup Nanda
- Original Message -
To: "Multiple recipients of lis
Stephen,
>From your email, here are the steps as I understand them:
1) run imp command
2) reboot the server (NT/Win2k?)
3) check database and find it is not open
The reboot closed the database (and probably not gracefully). When the server
restarted, the service may have started, but the databas
Last time I checked it was 4 for Windows NT/2000. Not a UNIX shop so can't
comment on that OS.
T¬
_
Tim Onions
Speech Machines
-Original Message-
Sent: 29 July 2003 18:04
To: Multiple recipients of list ORACLE-L
I am trying to find any info on if there
Dave - Maximum of 4 processors.
http://www.pro-dba.com/oracle_database_standard_edition.html
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 29, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
I am trying to find any
Or, for you GPL, cross-platform fans, there's NEdit at http://www.nedit.org
I've made a simple addition to it's extensible config file so that it
properly highlights all available Oracle 8i parameters when editing an
init.ora file. My v5.3 .nedit file can be nabbed from
http://society.servebeer.co
My memory is 4 ... and with typical Oracle Licensing Shennanigans attached
... I remember a few cases from 2001 where clients where arguing whether SE
could be licenced for up to and including 4, or up to but not including 4.
But given that's a two-year-old memory, I can pretty much guarantee Orac
We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an
old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through
Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am
not concerned if Oracle has certified or desupported this, I just want
I'm starting to gather that -- that the reboot did it.
Entertainingly enough I had enough presence of mind to use EM
As SYSDBA and open the database using the InitTPOCS.ora.
The users have been using the application for the last four hours
without
any issues, so, what is the graceful way of shutt
> Two things to check immediately:
>
> (1) Is the Oracle service defined as started automatically in
> the services?
Yes
> (2) If yes, is there any error reported in alert log of the database?
Compared line-by-line the last three starts and they seem identical,
nothing unusual
in the last st
Hans,
Now let me guess Your disks are all RAID 5, right? And you possibly are
bottlenecking on CPU as well? It is clear from the Top 5 that writes are an
issue across the board, to TEMP (direct path write), Redo (log file sync)
and DB files (db file parallel writes). Creating a RAID 1 set of d
We ran 7.3.4 on HPUX 11 and 11i. It ran but we knew we could not relink
and we were headed for another release anyway as part of a migration.
It will run, but not recommended.
Allan
-Original Message-
Sent: Tuesday, July 29, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L
We are
It's a TOAD issue. It's fixed in one of the v7.x versions. The current
supported version is 7.5.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -Original Message-
> From: AK [mailto:[EMAIL PROT
David,
You have to install 7.3.2 binaries for HP 11. Both HP 11 and Oracle binaries
(whatever version you decide) to be installed from scratch as moving from
from 10.20 to 11 itself is not supported. You may request support to provide
7.3.4 version for HP 11.Down load latest patch 7.3.4.5 and a
Sounds like time to upgrade. To the best of my limited knowledge on this, it may well
run, but in 32 bit mode which may mean modifying the .mak files, manually.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 29, 2003 1:05 PM
To: Multiple rec
But, I would like to know how this seemingly high wait for 'direct path write' is
affecting the
overall response time. (ResponseTime = WaitTime + ServiceTime)
If the 'CPU used by this session' is not considered in light of these wait times,
aren't you
getting ready to bark at the wrong tree?
Or, alternatively, you could live EXTPROC where it is, no matter how
wulnerable it is, and trust a good firewall. If you are in a commercial
environment, breaking in a box through the buffer overflow hole would
require a major talent, which is very hard to come by in these days of
cost cutting. I
LOL--I'm the sole ultraedit fan in a den of textpad users & have had
many conversations that start with the phrase "yeah, but can your editor
do this...".
I was of the opinion that they were pretty much equal until someone
(Dennis Williams?) wrote in reminding me of ue's ability to
open/edit/save
We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible set to
7.3.3.0.
The Application uses some old OO stuff written in GemStone.
- Kirti
--- "Ehresmann, David" <[EMAIL PROTECTED]> wrote:
> We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an
> old
I'm pretty sure that SE will run on any size server, but you'll be charged
for EE when that server has more than 4 CPUs... :-)
You'll see info for this at "http://oraclestore.oracle.com"; when you try to
price an SE license on a per-processor basis. Click on the explanation of
"User Minimums" fo
WHO LET THE DOGS OUT!!!
on 7/29/03 11:14 AM, Kirtikumar Deshpande at [EMAIL PROTECTED]
wrote:
> But, I would like to know how this seemingly high wait for 'direct path write'
> is affecting the
> overall response time. (ResponseTime = WaitTime + ServiceTime)
>
> If the 'CPU used by this session
I found out that the OS is HP11i 64bit. Does this change anything, or just
make it harder?
thanks,
David Ehresmann.
-Original Message-
Sent: Tuesday, July 29, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible
Thank you for the replies. It turn out to be a code issue. The developer added
olecmd.dispose(), which fixed the problem.
>>> [EMAIL PROTECTED] 07/28/03 11:54AM >>>
There are some relevant notes on MetaLink that may be of help.
Search on 'visual basic ora-1000'
Jared
On Monday 28 July 2003
I would recommend upgrading to 7.6.x you can download it from www.quest.com
From: "AK" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: ORA-03115 (TOAD question!!)
Date: Tue, 29 Jul 2003 07:49:23 -0800
Not sure but this might
We were using hp 11 64 bit OS but used Oracle software 32 bit because of
Oracle Fianancials 10.7 32 but software. We also tried HP 11i 64bit OS with
7.3.4 in test environment without any issues.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE
Is the INLIST ITERATOR unable to use the index unless we specify NOT NULL? I wanted to
bounce this off the list before we log a TAR.
We are examining the performance of a query and I am trying to understand why an
INLIST ITERATOR is not used if there is not an explicit IS NOT NULL predicate
con
7.6 is BETA. 7.5.2 is the current release. New betas appear frequently.
Also, this version is not free. It's listed at just under $800 US. The
freeware version is v6.x, which has the LOB bug, among a host of others.
Rich
Rich Jesse System/Database Administrator
[EMAI
I'm embarrassed ...
Shutdown immediate via SQL*Plus after verifying all users have
disconnected.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
> -Original Message-
> From: Wolfe Stephen S GS-11 6 MDSS/SGSI
> Sent: Tuesday, July
Folks,
Say a session issues a read request, and finds another session already
reading the block into the buffer cache. If this session waits N ms on a
"buffer busy waits" event, does this N ms of wait get added to the read
times in v$filestat? Or is the readtim in v$filestat purely physical I/O?
Hi All,
I'm trying to use SQL Loader to load data from a text file into a table.
However, I always get error as column SKILL_DESCRIPTION field in data file
exceeds maximum length where the column SKILL_DESCRIPTION is declared as
varchar2(4000). I know the data is <4000 characters, but >1000 c
Buffer busy wait has a different correlation with v$filestat and I/O. Buffer
busy wait simply means that the buffer you're waiting for is pinned by
somebody else.
There are 3 classic situations:
1) DBWR hasn't finished writing to the disk yet.
2) Block is locked by another node (OPS, RAC).
3) RM
Title: Message
We
used to experience problems in our RAC environment when there's an interconnect
failure. There's a workaround for that problem, that was worked for us
-
Create a directory under $ORACLE_HOME/rdbms called ".aixopt". Create
(touch) a file called SUSTAIN_IPC_FAILURE (upperca
Try with external tables. The best thing since sliced bread.
On 2003.07.29 17:39, Anna Li wrote:
Hi All,
I'm trying to use SQL Loader to load data from a text file into a table.
However, I always get error as column SKILL_DESCRIPTION field in data file
exceeds maximum length where the column SK
Hello All,
There are 188 interim patches after 8.1.7.4 patchset. I know that
8.1.7.4 is the last patchset.
1. What methods/strategy do you'll have for installing patches on a
8.1.7.4 64 bit hp-ux 11.11 database?
2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i.
3. Should one install al
Hi
where can I find steps ( procedure ) for upgrading
from 8.1.7 to 9i .
Thanks,
-ak
If its
not an then you can simply run catalog.sql and catproc.sql to upgrade oracle
dictionary tables. Also during 9I installation Oracle ask to upgrade
existing databases on that system.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 3:54
P
Sliced bread or not, the syntax problem will be the same since external
tables are modeled on SQL*Loader syntax... :-)
Anna, I suspect that there is confusion on the SQL*Loader concepts of
"external datatypes" and "internal datatypes", which incidentally is shared
by external tables currently. S
AK,
Start with Note:159657.1 on
MetaLink.
Gudmundur
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 29, 2003 10:54
PM
Subject: upgrade to 9i
Hi
where can I find steps ( procedure ) for
upgrading from 8.1.7
Hello Raj.
BBW with a p3=0 are a consecuence of the I/O subsystem
not being able to provide enough throughput to the
database, as Mladen has said.
But there are also many others causes for BBW. Check
p3.
Also if the session A is waiting for a buffer in the
buffer cache (that's a BBW), the buffer
Can you post the sql, or even the 10053 trace up to the "GENERAL PLANS"
section. That would also answer the question "which exact version/release
of Oracle 9?"
At 12:59 PM 7/29/2003 -0800, you wrote:
Is the INLIST ITERATOR unable to use the index unless we specify NOT NULL?
I wanted to bounce t
That's On 2003.07.29 19:59, Diego Cutrone wrote:
Another thing I think (I'm sorry to disagree with
Mladen on this) is that when DBWR hasn't finished
writing a buffer to the disk, and a session wants that
buffer in exclusive mode, there's a wait and that wait
is computed as a write complete wait an
don't be... this means you are doing something we strongly advocate on
this list... reading the manuals and learning.
--- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]>
wrote:
> I'm embarrassed ...
>
> Shutdown immediate via SQL*Plus after verifying all users have
> disconnected.
>
> v/r
Are you missing something in your reply?
"If its not an then".
>From migrating 8.1.7 to 9i, one has to follow prescribed procedure.
To my knowledge one needs to run u0801070.sql after starting the 8i database in
'migrate'
mode...etc.. etc... I have the GUI thing, sorry!
- Kirti
--- [EMA
Hi Ak,
you can get it here:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
S
Gogala,
RMAN is writing the block. That's right, RMAN locks (pins) blocks in
memory, otherwise it couldn't ensure consistent backup. That is the reason
why RMAN doesn't need "alter tablespace begin backup" command.
I have read that RMAN has the advantage of not generatin
On 2003.07.29 21:36, Prem Khanna J wrote:
Gogala,
RMAN is writing the block. That's right, RMAN locks (pins) blocks in
memory, otherwise it couldn't ensure consistent backup. That is the
reason
why RMAN doesn't need "alter tablespace begin backup" command.
I have read tha
Thanks a lot for your explanation Gogala.
Eagerly waiting for Steve's revised edition of "Oracle Internals".
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www
Once again thanx a lot Tanel for spending your
precious time to make me understand.
Regards,
Jp.
28-07-2003 22:59:25, "Tanel Poder" <[EMAIL PROTECTED]> wrote:
>The point is, that index access is cheap in reality, but CBO thinks it's
>very expensive and chooses next best executin plan in it's op
The user is able to query the v_$ views and statistics are
(Bexplained properly.
(B
(Blet me enable "Event 10046" and see what happens.
(B
(BThanx Tanel.
(B
(BRegards,
(BJp.
(B
(B28-07-2003 22:34:30, "Tanel Poder" <[EMAIL PROTECTED]> wrote:
(B>Hi
(B>Hm, but try to query sys.v_$session s
76 matches
Mail list logo