Hi,
we are running 9.2 on HP-UX here.
We have pg_aggregate_target configured, but I realized (in my opinion) very
high memory consumption of Oracle Unix processes.
a) How come that one Oracle Connection (i.e. dedicated Unix process on HP)
is using up at least 22 MB of RAM? It is using 22 MB if
Title: Savepoints in 9i
Hi Friends ,
In my application , we are having a program written in C which executes the sql command that is passed as an argument to it. When I call the procedure to
Create a savepoint SP1 and then to rollback to the named savepoint , it throws an oracle error
Hi.
Execute in sqltrace is for that particular session only whereas in statspack, it's system wide.
A lot of sessions might have executed the same query.
Best regards
VIVEK_SHARMA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/17/2003 02:19 PM
Please respond to ORACLE-L
To:
Check out Jacques e-mail address - he *works* for Quest ;)
-Original Message-
Wolfgang Breitling
Sent: 15 November 2003 07:04
To: Multiple recipients of list ORACLE-L
Someone must have created sys.x_$ views on some of the sys.x$ tables.
Installing statspack does that for example for
We are doing Interest processing on a SET of 10,000
Bank A/cs
Following SQL Query Shows DIFFERING values for :-
Execute from SQL_TRACE = 2584
Executions from Statspack report =
10,000
Qs. What is the reason for this?
SQL_TRACE :-
call count cpu elapsed disk
query current
Helmut,
I don't know how you are measuring your numbers, but beware that what the operating
system reports is often somewhat misleading. Typically, shared memory is often
'attributed' to each and every process linked to it. When you think about it it makes
sense, but at the same time it
Hi Arup,
Yes, AQ is enabled for this database - thanks for the information.
- Bill.
At 07:59 13/11/2003 -0800, Arup Nanda wrote:
Have you enabled Advanced Queue Manager process in the init file?
aq_tm_processes? If so, this wait event occurs when the process just waits
to see some messages in
Hi Arup,
Yes, AQ is enabled for this database - thanks for the information.
- Bill.
At 07:59 13/11/2003 -0800, Arup Nanda wrote:
Have you enabled Advanced Queue Manager process in the init file?
aq_tm_processes? If so, this wait event occurs when the process just waits
to see some messages in
DB Code compilation and library cache lock issueHi,
To detect whether you are waiting for a compile to finish, you can just check
v$session_wait and see if your current session is waiting for library cache pin wait
event. Without such wait event ,compiling a procedure can just be finished in
We are doing Interest processing on a SET of 10,000 Bank A/cs
Following SQL Query Shows DIFFERING values for :-
Execute from SQL_TRACE = 2584
Executions from Statspack report = 10,000
Qs. What is the reason for this?
SQL_TRACE :-
call count cpuelapsed disk query
Hi List,
One of my customers gets HP Servicedesk 4.5 implemented. The database that
has been created by on of the DBA's for the application is Oracle 8.1.7.4,
on AIX 4.3.
The database has characterset UTF8, which is the standard here.
Now ServiceDesk has bad performance. HP claims that the
Mladen, we must have started in the same era. You're describing the
environment I started with, however, our disk was 10MB. So you remember
SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well?
Carel, I know that. That was my first oracle version. I installed V4 on an
IBM
PC/XT with WD 20MB hard drive
Hi Stephane,
thanks for your reply.
We are measuring the values by getting the OS process ID of a specific
Oracle connection and then trach that process ID using glance (on HP-UX).
Since the SGA is ab 1.5 GB, it is definitely not attached to the memory
consumed by each process. I know that
Hi all,
Is anyone using the QUOTA_SIZE setting in the LOG_ARCHIVE_DEST_n
parameters? I am trying to use this for a local archive destination in a
non-Dataguard configuration. However if the destination fills up, although
the error is correctly identified and reported (alert log and
Randy,
We have both weekly and monthly summary tables and the date data field
is defined as DATE. It is populated by the pl/sql package that
summarizes the data using a date value passed to the package as the
ending date for the week or month. On the first of the month or Sunday
we run the
Hi!
We are currently discussing Oracle licensing issues. Due to the number of
users, named user licensing is not an option for us.
Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we
are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is
this possible
Helmut,
Seems a bit high to me as well. Concerning the PGA issue, what about running
something like :
col name format A25
select n.name,
round(min(s.value) / 1024) MIN K,
round(avg(s.value) / 1024) AVG K,
round(max(s.value) / 1024) MAX K
from v$statname n,
v$sesstat
List,
I have been asked to produce a process for documenting the
request,test,deployment, etc of the server OS, client OS, and databases
that we use. I have googled for 'software deployment control' and
'software change management' without much success. We are looking for a
written procedure not
I do. I thought that IAD (graphic interface which came with 2.0
in version 5) was a solution to all problems. Version 4 was used
for training purposes only. First real apps were developed with
5.0 and 5.1.22.
On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote:
Mladen, we must have started in the
Your process has parts of SGA attached to it. The only way to actually find out
is to examine the process address space wia kernel debugger or /proc file
system. First, try with ps -lp PID and see how big is the RSS (resident set size).
On 11/17/2003 02:09:26 AM, Daiminger, Helmut wrote:
Hi,
Carel-Jan,
About two weeks ago, Faan DeSwardt [EMAIL PROTECTED] posted to the thread
Unicode: UTF-16 to UTF-8 conversion, saying UTF-8 is variable-length encoding
and so is slower than the fixed-width UTF-16, and also US7ASCII. Maybe it's the
same issue here comparing UTF-8 with WE8ISO8859P15.
Gogala,
I've been searching for a /proc filesystem implementation on HPUX for years. I
don't think it's there yet.
Yong Huang
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Your process has parts of SGA attached to it. The only way to actually find
out
is to examine the process address space wia
Hi!
Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when
was the deadline for acceptance confirmation from IOUG-A?
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi!
You should check the licensing agreements first, AFAIK you need a licence
for each CPU in server, it doesn't matter how many of them you actually use.
Also I haven't heard that HP-UX supported CPU affinity anyway...
Tanel.
- Original Message -
To: Multiple recipients of list
Tanel,
The emails/letters should be coming out soon. They have been working on
scheduling.
Daniel Fink
Tanel Poder wrote:
Hi!
Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when
was the deadline for acceptance confirmation from IOUG-A?
Tanel.
--
Please see the
Oracle version 8.1.7
AIX 4.3.3
I am trying to configure mult-threaded server on one of my development
databases. In my init.ora file, I set
(mts_dispatchers=(address=(protocol=tcp))
mts_servers=10
When I bring up the database, I can see the dispatcher and
servers. When I connect to the
Peter:
8.1.7 is pretty picky about syntax.
Here's what I have in my 8.1.7.4 database. (It's
Solaris, but I believe the parameter is the same)
MTS_DISPATCHERS=(address=(PROTOCOL=TCP)(HOST=atex-ent-prd1))(disp=2)
mts_servers = 20
Good luck!
Barb
--- Schauss, Peter [EMAIL PROTECTED] wrote:
Talked with Stan Yellott Friday. His is scheduling and confirming today.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Tanel Poder
Helmut:
I think (???) if you have MC Service Guard installed, you can specifically
allocate CPUs for specific processes. For the SQL*Net stuff, not sure if
you can limit these.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile:
The fine manual doesn't seem to reveal anything new.
Here's what you need to do:
Write some pure PL/SQL code with which you can duplicate
this problem, and post it to the list.
If you can't duplicate it that way, it's very likely to
be a Pro*C problem, in which case you should:
Write some C
Here's a wild guess, could it have anything to do with turning on automatic undo and
setting undo_suppress_errors (sp?) to true? Is the savepoint command erroring and not
being trapped?
Daniel Fink
Jared Still wrote:
The fine manual doesn't seem to reveal anything new.
Here's what you need
You have to make sure the dispatchers are registered with the
listener. Use lsnrctl services to make sure. The error you gave
shows that they are not registered.
If your listener is not on 1521, then the dispatchers won't know how
to find it to register. You'll have to add the listener=
Jacques --
Huh? I thought the question was, give me all the usrs where there exists a
record containing a 1,5, and 7. How can that return one record, when there
are two users -- and only two users -- who have the 1,5,7 combination? The
data provided shows that both GAP and GPA have a 1, 5 and
Do you know how SQL*Plus was called during Oracle V4? (And maybe
earlier,
but this is as far as my history with Oracle goes)
They called it UFI, which means User Friendly Interface!
And that dreaded afiedt.buf came was a copy of the Advanced User Friendly
Interface Buffer (edt was
Hope you don't mind the intrusion... I used HLI back in 5.0.20 days, and the
big problem converting in 5.1.22 when everything had to go to IAPXIT. When
were IAP|IAG replaced with IAD? I thought that came in around 1.3... was it
later? Because by v2 it was SQL*Forms...
Bambi.
On 11/17/2003
IAD was the executable (on VMS) that the Sql*Forms command ran (D for
Designer). IAG was to generate a form (G for Generate). IAP to execute it
(P for something that I can't remember). This was SqlForms 3.0.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
P was Program... it was the Y/N program file.
-Original Message-
Sent: Monday, November 17, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
IAD was the executable (on VMS) that the Sql*Forms command ran (D for
Designer). IAG was to generate a form (G for Generate). IAP to
hi
i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good.
- using aq and dq message processing
- using snapshot replication
- using ro standby
Sai - In your first sentence, you ask about modeling. Then the rest of your
posting appears to relate to data movement? Which topic are you interested
in discussing? For data movement, the best method often relates to the
amount of data you estimate you will be moving, and how often.
Dennis
Helmut
Tanel's understanding matches mine. CPU-based licensing makes it wise to
install Oracle only on servers used exclusively for Oracle. You might also
consider Oracle Standard Edition licensing.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Ron
The organization that is providing concepts behind improving deployment
processes is ITIL. Start at http://www.itil.org. This is not a software
package (but some software packages comply with ITIL's concepts). It isn't
even a set of procedures, but a set of processes that will assist you in
Hi!
Only string manipulation/comparision is slower with variable width charsets
than with fixed width ones, because with variable width ones (UTF-8) you
have to check the highest bit of each byte to check whether it shows that
the next byte is part of current character or is part of next
dennis
i am sorry to have been real unclear. data movement is what i am interested in.
Bellow, Bambi scribbled on the wall in glitter crayon:
Do you know how SQL*Plus was called during Oracle V4? (And maybe
earlier, but this is as far as my history with Oracle goes)
They called it UFI, which means User Friendly Interface!
And that dreaded afiedt.buf came was a copy of
Yet another case of the right hand not knowing what the left hand is doing. Now I'm
curious to find out which team is creating those x_$ views.
-Original Message-
Mark Leith
Check out Jacques e-mail address - he *works* for Quest ;)
--
Please see the official ORACLE-L FAQ:
Boy do I feel stupid!
Thank you Mr. Khedr and Mr. Breitling. I know the views are there, but at first I
thought that maybe there were being created as part of the database creation process
in some cases. In the first database I looked at, the X_$ views had the same creation
date as the database
Dennis,
Thanks for the reply and I appreciate the starting URL.
We have a service or help desk already and I would like to make it
browser based
but I am banging my head against the wall of we don't use it or need
it why train for it
mentality.
You mentioned the particular servers that are
When I do lsnrctl services, I get two entries for each instance.
For example:
tawk has 1 service handler(s)
DEDICATED SERVER established:33 refused:0
LOCAL SERVER
tawk has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The original question was show me the users who have ALL the values in the list but
NOT MORE than the values in the list.
-Original Message-
Bellow, Bambi
Huh? I thought the question was, give me all the usrs where
there exists a
record containing a 1,5, and 7. How can that
make love
-Original Message-
Sent: Monday, November 17, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
Bellow, Bambi scribbled on the wall in glitter crayon:
Do you know how SQL*Plus was called during Oracle V4? (And maybe
earlier, but this is as far as my history with Oracle
Well, not all hope is lost. Look at the following URL's:
http://www.makalis.fr/~bertrand/FreeVMS/indexGB.html
http://www.bosbc.com/
The second one is a commercial product, but certainly provides a
familiar layer.
On 11/17/2003 02:04:25 PM, Thater, William wrote:
Bellow, Bambi scribbled on
At 10:34 17-11-03 -0800, you wrote:
Performance depends on a lot of things, such how much string operations you
got, what are the contents of your strings (are they mainly latin chars or
are there lots of asian ones etc..).
Tanel.
Thanks Tanel for your respond. I doubt whether a query will go
Just a guess:
select distinct
usr
from
xxx
where
(select
count(*)
from
xxx
group by Usr)
=
(select
count(*)
from
xxx
group by Usr, val)
-Original Message-
Sent: Thursday, November 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Thanks Yong. I doubt whether this can have such a significant effect, or it
must be that due to some incompatability an index can't be used (or simply
isn't even there). They have to trace the session, alas I'm not allowed to
touch the system (other project, other budget blah blah)
At 06:54
We've purchased nuTPU from aSoft:
http://www.asoft-dev.com/tpu_info.htm
It's very good, although most of my low level EVE replacements don't work
(e.g. off-screen cursor handling, custom comment handling, etc.).
Development appears to be stopped as there have been no new patches or
versions in a
Using Bambi's table and values. Try this query, it's ugly but it works (kind of like
the contributor...)
Daniel
1 select o.usr, count(o.usr)
2 from (select distinct usr, val
3from gab
4where val in (1,5,7)
5 and usr not in (select usr
6
Bellow, Bambi scribbled on the wall in glitter crayon:
make love
not war
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]
The knack of
Peter,
If you declare in the init.ora file where the listener is running, then the
database automatically connects to the listener. This is the second tawk
entry in your lsnrctl status listing.
If you declare the database in the listener.ora file, then the listener goes
looking for the
Thanks for all of the suggestions. I took a look at my init.ora
file and discovered that I had the services and db_domain
entries disagreed with the database global_name value and. I fixed
those entries, bounced the database and the connections started coming
in on the shared server.
Peter
Here's a wild guess. If the character set is changed, a 10 MB segment (from the
first extent to high water mark) may become 20 MB or 5 MB. Then CBO changes the
plan and it happens to be a bad one.
Yong Huang
--- Carel-Jan [EMAIL PROTECTED] wrote:
At 10:34 17-11-03 -0800, you wrote:
Bill, that's a wrong answer. The correct answer is make love, not children.
On 11/17/2003 02:54:42 PM, Thater, William wrote:
Bellow, Bambi scribbled on the wall in glitter crayon:
make love
not war
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... --
No characterset changed yet. They want us to recreate the database. the
system is going live in a few weeks. I simply hate changing things because
someone says so. It might be the quickest solution, but most probably not,
and then it's a waste of time, energy etc.
Here's a wild guess. If the
Carel-Jan
Look at it this way. Easier to fix the character set now. And if the
performance is still bad, then they've got one less excuse. Being a DBA
means learning to live with disappointment.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday,
No, sorry, that is the correct answer. The original question was Does
anyone remember TECO? In TECO, if you entered the command make love, it
would respond not war.
Two points to Bill and thanks for the smile to both,
Bambi.
-Original Message-
Sent: Monday, November 17, 2003 2:14 PM
If you remove the database declarations from your listener.ora file
does it cause a problem if the listener is not running when
the database comes up?
Thanks,
Peter Schauss
-Original Message-
Sent: Monday, November 17, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L
Peter,
If
Gabriel,
How about this untested code?
Alan.
select
usr
from
(
select
usr,
sum(decode(val,1,1,0)) look1, -- flag for 1
sum(decode(val,5,5,0)) look2, -- flag for 5
sum(decode(val,7,7,0)) look3, -- flag for 7
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let
Looks like someone has been tapped for Sarbanes Oxley.
Ron Rogers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/17/2003 05:14 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:software deployment control
Michael Milligan wrote:
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . .
Actually, I believe it is even more restrictive than that.
It doesn't matter how many CPU's are in the machine, what matters
is how many CPU's the machine is capable of holding.
So what they are really licensing is not the # of CPU's, but
the class of the machine.
Try digging in the archives,
Micheal,
Could you shrink the rbs even smaller? This should work if the first two
extents of each rbs are in the 'first' blocks of the datafile. If not, the best
solution is to create new smaller ones as you drop the others and then resize.
Regardless of the solution, do this during a slow time
DENNIS WILLIAMS wrote:
Being a DBA means learning to live with disappointment.
Well said, well spoken, Dennis.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Fink
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
The high water mark for the rollback segments is preventing you from shrinking the files.
Use alter rollback segment SEGMENT_NAME storage ( optimal OPTIMAL_SIZE)
to set an optimal size for the segment, then use 'alter rollback segment SEGMENT_NAME shrink'
to shrink the rollback.
You may want
Thanks for the info.
It's 8.1.7.4, and it's not hard-coded. I changed it from 50% to 0%, but the
damage had been done. Maybe you're just nostalgiac for the good old days of
v6!
I did set an optimal, and used shrink. That worked fine to shrink the
segments, but they are still scattered
Daniel,
Thank you very much. I'll do what you suggested, on both counts. I'll try
shrinking them more first, then create new ones if needed.
Thanks again,
Mike
-Original Message-
Sent: Monday, November 17, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Micheal,
Could you
hi
data movement for a reporting database from a OLTP intensive db is what i am
interested in.
We can buy machines with the CPUs installed but turned off and only activate
them when needed. I don't think we need to license Oracle for the CPUs that are
turned off.
Regards,
Denny
--
Denny Koovakattu
Quoting [EMAIL PROTECTED]:
Actually, I believe it is even more restrictive than
$ make lovemake: *** No rule to make target
`love'. Stop.
- Original Message -
From: "Bellow, Bambi" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:24
PM
Subject: RE: Re[2]: var source_data
varchar2(12)
make love
Sai - All data in the database? How large, how active is the source
database?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 17, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
hi
data movement for a reporting database from a OLTP
The fun part is that if the database will perform better after recreation
for some reason, then the HP guys (and probably your bosses) will tell you,
we said so or smth like that :)
Of course when performance goes bad again after a week, HP guys will
probably ask for a block size change + db
[EMAIL PROTECTED] wrote:
Actually, I believe it is even more restrictive than that.
It doesn't matter how many CPU's are in the machine, what matters
is how many CPU's the machine is capable of holding.
So what they are really licensing is not the # of CPU's, but
the class of the machine.
Try
I really hate to admit it, but I agree. Doing otherwise is a simple recipe for
hypertension, stroke an early death. Besides, it's so much more gratifying be
able to say I TOLD YOU SO.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, November
Hi Everyone,
The second part of my new paper on row level security is out today. This
part talks about the issues with row level security, the dictionary
views that can be used to check configuration and also how to detect if
row level security is used using trace and sql. There is a link to this
Ok, guys I have to apologize twice,
First: the delay to answer your very kind emails, (you
know the urgent problems dont let you time for the
important ones)
Second: maybe my question was not clear enough,
ciertanly what Bambi says is what I need give me all
the usrs where there exists a
Jacques Kilchoer wrote:
Mr. Begun: I'm not convinced that your answer is quite the right one.
I've provided two solutions but I'm still confused :). Jacques, does
that mean that I understand English and the original query was Ok? :)
--
Vladimir Begun
The statements and opinions expressed here are
Hi,
Since everyone is just guessing, can you say more detail about the bad
performance? High CPU usage with no idle so client wait for CPU time? or Low CPu usage
but client still wait? or High disk io rate with 100% disk busy?
Can you show us some data about your aix box and statspack
Hi,
I have also been researching on how to monitor oracle process memory utilization
on different platform . And on hp, it seems more difficult.
I once see a note on metalink talking about using kernel debugger on HP to detect
it, here is a sample output, but I do not know the
Well, the last number is, obviously, the size of the area. Only the maps of
shared memory, text and data are of some interest. Text is, in case of an
oracle process, $ORACLE_HOME/bin/oracle and you don't have any influence
over it. The data section are the auxiliary structures. If you are
Mr. Begun,
I didn't answer your comment about making the query work with the decode vs. using a
user-written PL/SQL function because I wanted to compare timings for both. I created a
table with 200,000 rows and compared the VB (Vladimir Begun) query to the JRK (my)
query. The runtimes were
Jacques,
you can use my first name -- Mr. is too official for this list :). You have modified
the query,
however I would suggest you to check execution plan (and present it here) and remove
LENGTH(TRANSLATE(:list, ',0123456789-E', ',')) by replacing it using number of
elements in the
list i.e.,
I would like to make an application in OAS 408 to connect to an 817 database. When I try to create a DAD to establish this connection, I get this error: OWS-05566 caused by ORA-12202: TNS internal navigation error. Can anyone enlighten me on what these errors mean and how to work around it?
DB
Hi Rhojel,
8.1.7 comes with the 9iAS installed automatically as
part of the regular software install.
May I ask why you're using OAS?
Regards,
Melanie
--- [EMAIL PROTECTED] wrote:
I would like to make an application in OAS 408 to
connect to an 817
database. When I try to create a DAD to
Is it possible to run Forms6i in client-server mode against an Oracle
9.2.0.4 database? One of the developers where I work flatly states that
Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot
find any specific information either confirming or denying this assertion.
Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've
setup multimaster replication and as a result got temporary tablespace about
10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna
to free them for my purposes.
Perhaps you could clarify what you mean
What will happens if I remove all occurence of IPC protocol from
communication level, i.e. Listener? Can U work only over TCP/IP?
--
(VirVit)
Oracle 9i DBA beginner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VirVit
INET: [EMAIL PROTECTED]
Fat City Network
Hi Melanie,
This was how the application was implemented in my new company, they used OAS 408.
Still gettingfamiliar with their application.. this is what happened: I transferred the dev DB
to another host for maintenance purposes and when I tried to configure a DAD
for that DB in OAS, I got
Hi Don
We have moved to oracle 9i (9.2.0.3) and are running Forms6i without any
problem. According to the Metalink certification matrix Forms 6i patch
set 13 and above are certified with Oracle 9.2 (or 9i). The matrix does
not distinguish between minor releases of Oracle (i.e. 9.2.0.3 and
Hi Rhojel,
I'm sure you know this, but that error message usually
leads you straight to Oracle support.
Are the protocols on each box the same? Are the
sqlnet.ora files the same? Or do they at least each
have AUTOMATIC_IPC set to OFF?
Regards,
Melanie
--- [EMAIL PROTECTED] wrote:
Hi
Hi Melanie,
Yup, I've checked all that. I guess that's the only option I have right now (Oracle support).
There's not much documentation for this error in Metalink, I guess they want us to go to them
directly on this one..=) But I'll do some double checking on those points that you've
99 matches
Mail list logo