04-19-2002
in order to be able to diagnose an ora-600 error. you need the exceptions to the error (this typically is displayed in [kvskdk] format immediately following the error. you can also take a look at the entire error and trace file message by going to
/$ORACLE_BASE/admin/$ORACLE_SID/bdump/alert*.log assuming your .profile is correctly set up for the oracle user.
while oerr is a great utility for diagnosing, or at least finding a place to start in diagnosing most oracle errors. it is completely useless when it comes to oralce 600's (internal error, that usually only oracle can help with, and they do not document through oerr)
1) I would create a metalink account metalink.oracle.com (free) and only takes a few minutes top complete application
2)I would find the actual alert message( in the log mentioned above), and take a look at the trace file (which is mentioned in the alert log and is usually ../udump from the directory above. take the entire 600 including exceptions and enter it in the search line on metalink. hopefully it will set you up with a few articles that might help pertaining to your memory leak
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi @all
Who's able to help me?
I've a running Oracle DB on AIX 4.3.3.
You've also an Oracle Client running for this.
So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things,
but it doesn't work. Thanks a lot!
Regards
Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies
2. AIX
Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run"
and i can't start the installation of ORACLE 9i...
see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies
3. AIX
Hi All,
I need to update some AIX servers from 5.2 to 5.3 OR 6.1 .
The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 .
I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies
4. AIX
Hello
Im trying to install oracle on my AIX 5.3 server.
Im doing all things right as Oracle says...
When im trying to run the instalation it gives me an error about JRE.
But i already have JRE installed as you can see...
Someone can help me or guide me?
Im new in with this..
... (1 Reply)
Discussion started by: gfca
1 Replies
5. AIX
hi
can anyone help me by telling step by stem oracle10g installation in AIX 5 .
Munir
mondolsoft
Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies
6. AIX
Dear All,
I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Discussion started by: prav_06
2 Replies
7. AIX
Seek help from all of the experts here.
Database Oracle 9.2.0.1.0 run on AIX 5300-07.
The system is running so slow that sometime 1 click of changing screen will take more than 5 minutes.
The hardware in this LPAR is 6CPUs, 21GB-RAM, 42GB-Paging and run on p570 server POWER 5+.
And the vmo... (2 Replies)
Discussion started by: kwliew999
2 Replies
8. UNIX for Advanced & Expert Users
I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
Discussion started by: johnf
1 Replies
9. AIX
Hi,
we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11.
Our base interest is on vmo and disk setup
On aix 5.3 we change lru_file_repage to 0.
We split disk layout ( emc cx4 ) to tree volume groups:
- one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
Discussion started by: prebila
5 Replies
10. AIX
Hello All,
I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO.
They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache.
To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies
LEARN ABOUT DEBIAN
port_alert
port_alert(3C) Standard C Library Functions port_alert(3C)
NAME
port_alert - set a port in alert mode
SYNOPSIS
#include <port.h>
int port_alert(int port, int flags, int events, void *user);
DESCRIPTION
The port_alert() function transitions a port into or out of alert mode. A port in alert mode immediately awakens all threads blocked in
port_get(3C) or port_getn(3C). These threads return with an alert notification that consists of a single port_event_t structure with the
source PORT_SOURCE_ALERT. Subsequent threads trying to retrieve events from a port that is in alert mode will return immediately with the
alert notification.
A port is transitioned into alert mode by calling the port_alert() function with a non-zero events parameter. The specified events and
user parameters will be made available in the portev_events and the portev_user members of the alert notification, respectively. The flags
argument determines the mode of operation of the alert mode:
o If flags is set to PORT_ALERT_SET, port_alert() sets the port in alert mode independent of the current state of the port. The
portev_events and portev_user members are set or updated accordingly.
o If flags is set to PORT_ALERT_UPDATE and the port is not in alert mode, port_alert() transitions the port into alert mode. The
portev_events and portev_user members are set accordingly.
o If flags is set to PORT_ALERT_UPDATE and the port is already in alert mode, port_alert() returns with an error value of EBUSY.
PORT_ALERT_SET and PORT_ALERT_UPDATE are mutually exclusive.
A port is transitioned out of alert mode by calling the port_alert() function with a zero events parameter.
Events can be queued to a port that is in alert mode, but they will not be retrievable until the port is transitioned out of alert mode.
RETURN VALUES
Upon succesful completion, 0 is returned. Otherwise, -1 is returned and errno is set to indicate the error.
ERRORS
The port_alert() function will fail if:
EBADF The port identifier is not valid.
EBADFD The port argument is not an event port file descriptor.
EBUSY The port is already in alert mode.
EINVAL Mutually exclusive flags are set.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Architecture |all |
+-----------------------------+-----------------------------+
|Availability |SUNWcsr, SUNWhea |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
|MT-Level |Safe |
+-----------------------------+-----------------------------+
SEE ALSO
port_associate(3C), port_create(3C), port_get(3C), port_send(3C), attributes(5)
SunOS 5.10 1 Oct 2003 port_alert(3C)