Visit Our UNIX and Linux User Community


aix-oracle


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users aix-oracle
# 1  
Old 04-16-2002
Question aix-oracle

what is the reason oracle is giving ora-600 space leak error?
how to rectify this error?
# 2  
Old 04-16-2002
aix-oracle

I'm not sure what ora-600 space leak error is. But there is a good website www.support.oracle.co.uk

You may be able to find something helpful there.

Good Luck
# 3  
Old 04-17-2002
I am not a DBA by any means, but I did find this:
http://www.orafaq.com/msgboard/unix/messages/874.htm

I also ran a quick google to see what popped up and saw a few other people were having this problem with Oracle on AIX. I didn't research it completely, though, so it may just be coincidence.
# 4  
Old 04-17-2002
I just re-read this post again, and this isn't the same error that you talked about above. A tool that you may use (I'm not sure if it has to be installed, or if it's in by default) is the $ORACLE_HOME/bin/oerr command to determine what the cause of an error may be.
An example of it's usage would be:
$OARCLE_HOME/bin/oerr ora 6000
to look up error ORA-06000

Hope this helps.
# 5  
Old 04-19-2002
Computer

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
# 6  
Old 04-29-2002
you could also use the command orerr <oracle error code> to get the description of an error (instead of searching thru' websites).

for example,

> oerr ora 03212
03212, 00000, "Temporary Segment cannot be created in locally-managed tablespace"
// *Cause: Attempt to create a temporary segment for sort/hash/lobs in
// in permanent tablespace of kind locally-managed
// *Action: Alter temporary tablespace of user to a temporary tablespace
// or a dictionary-managed permanent tablespace


you need to have the help files loaded to see the error.
# 7  
Old 04-30-2002
unfortunately oracle does not maintain the help files properly. as i said this is a generic error the output from the system diagnostic tool would be something along the lines of

>oerr ora-0600
//*internal error, contact oracle support for help in diagnosing

they are not much help here. usuall 600's are a result of bus or internal problems which cannot be diagnosed without matching a stack trace from the trace file to an existing case with oracle. this is easiest done in metalink by tyoing the rror and the exceptions in the search box.

Previous Thread | Next Thread
Test Your Knowledge in Computers #459
Difficulty: Medium
NTP uses an epoch of January 1, 1970.
True or False?

10 More Discussions You Might Find Interesting

1. AIX

AIX and Oracle

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

2. AIX

aix 61 and oracle 11

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

3. UNIX for Advanced & Expert Users

Oracle RAC on AIX

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

4. AIX

Oracle 9.2.0.1.0 on AIX 5300-07

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

5. AIX

AIX to Windows Oracle DB

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

6. AIX

oracle 10g on AIX 5

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

7. AIX

Aix, Oracle and Java

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

8. AIX

AIX 6.1 and Oracle 9.2.0

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

9. AIX

oracle 9i on AIX 5.2

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

10. UNIX for Advanced & Expert Users

Oracle and AIX

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

Featured Tech Videos