- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-00600 internal errorcode [ktfbbsearch-7],[125]
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2005 09:13 PM
тАО08-29-2005 09:13 PM
For some records it works fine and after some time for other records it gives this error.
After restart it works fine for sometime.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2005 09:25 PM
тАО08-29-2005 09:25 PM
SolutionIt sounds like, system/kernel is not tuned against Oracle recommended values. System is running shortage of resource after long time usage. You can observe some messages in the syslog too.
The following Tunable kernel parameters recommended for Oracle 9i.
Parameter value
STRMSGSZ 65535
dnlc_hash_locks 512
max_thread_proc 4096
maxdsiz 0X60000000
maxdsiz_64bit 0X100000000
maxfiles 4096
maxfiles_lim 2048
maxssiz 0X800000
maxssiz_64bit 0X9000000
maxswapchunks 2048
maxtsiz 0X4000000
maxtsiz_64bit 0X80000000
maxuprc 1024
maxusers 1024
nflocks 2048
npty 1024
nstrpty 1024
semmni 2000
semmns 2000
semmnu 2000
shmmax 0X120000000
shmmni 2000
Good Luck,
Rajesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2005 10:10 PM
тАО08-29-2005 10:10 PM
Re: ORA-00600 internal errorcode [ktfbbsearch-7],[125]
The only thing that can provide some info is the numeric values. In you case it's [125].
After some googling I found this:
"it is a reported bug.
the error only applies to locally managed tablespaces trying to create an initial extent greater than 63M when using a non standarad block size (i.e not 4k,8k,16k,etc..) .
workaroud is to use a standard block size of 8192 or something like that with locally managed tablespaces. "
But anyway, the best thing you can do is call Oracle Support.
Alex.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2005 10:22 PM
тАО08-29-2005 10:22 PM
Re: ORA-00600 internal errorcode [ktfbbsearch-7],[125]
My experience is that Oracle discovers new patches are needed, updates the website but does not bother to notify users until they call support.
ORA-00600 is a catchall. The database knows something is wrong, but can not provide you with anything more specific.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2005 10:58 PM
тАО08-29-2005 10:58 PM
Re: ORA-00600 internal errorcode [ktfbbsearch-7],[125]
you did not post your oracle version.
Did you make any changes to your tablespace? Is it LMT or DMT?
What is your block size?
any major change you did before you started to get this error?
As others have said, these types of errors are better solved by Oracle Support (Metalink).
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2005 04:05 PM
тАО08-30-2005 04:05 PM
Re: ORA-00600 internal errorcode [ktfbbsearch-7],[125]
For error ORA-00600 internal errorcode [ktfbbsearch-7],[125]
Oracle says that using block sizes that are not a power of 2 (like suggested number 4096, 8192, ...) causes this problem. This error may occur for Locally Managed Tablespaces.
As Yogeeraj asked are your tablespaces Locally Managed Tablespaces, and what is the DB_BLOCK_SIZE.
SQL>select tablespace_name, extent_management from dba_tablespaces;
SQL>show parameter db_block_size
As you got the ORA-600 it will be better if you log an iTAR with Oralce and try to solve the issue.
Indira A