- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.0.4 returns 7497 error
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
тАО04-26-2004 10:17 PM
тАО04-26-2004 10:17 PM
Oracle 8.0.4 returns 7497 error
We├В┬┤ve got a ORACLE 8.0.4 Database running in a HPD230 machine.
PRO*C process aborted last morning while trying to connect to database. Oracle returns 7497 error:
contal1 18: oerr ora 7497
07497, 00000, "sdpri: cannot create trace file '%s'; errno = %s."
// *Cause: The trace file cannot be created for writing.
// *Action: Check if the dump directory exists and whether it is writable.
I reviewed dump directories and it seems to be OK... can anyone help?
Thank
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 10:30 PM
тАО04-26-2004 10:30 PM
Re: Oracle 8.0.4 returns 7497 error
could you do reply on the output of this kernel parameter?
# kmtune -q maxfiles
it seems HP-UX kernel parameter, MAXFILES, limit has been exceeded, accordingly to Oracle Metalink DocID 145437.1. Also read 1011677.6 if you have access to Metalink.
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 10:57 PM
тАО04-26-2004 10:57 PM
Re: Oracle 8.0.4 returns 7497 error
Sysdef returns:
maxdsiz 16384 - 256-655360 Pages -
maxfiles 2048 - 30-2048 -
maxfiles_lim 2048 - 30-2048 -
maxssiz 2048 - 256-655360 Pages -
Attached is full sysdef return, tha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 11:47 PM
тАО04-26-2004 11:47 PM
Re: Oracle 8.0.4 returns 7497 error
check file descriptor:
# ulimit -n
should return 2048
are there any other accompanying error message beside ORA-07497?
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 12:41 AM
тАО04-27-2004 12:41 AM
Re: Oracle 8.0.4 returns 7497 error
which user receives this message ?
(oracle process owner)
Have you try to run a trace as user oracle (trace current session) and look for the file to validate dump directory. May not be the expected one. cf. thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=541980
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 10:57 PM
тАО04-27-2004 10:57 PM
Re: Oracle 8.0.4 returns 7497 error
ulimit returns 2048 as you suggested, there is no other message than posted one.
Luc:
SQL> select name,value from v$parameter where name like '%dump%';
NAME VALUE
---------------------------------------
shadow_core_dump full
background_core_dump full
background_dump_dest /oracle/admin/contal/bdump
user_dump_dest /oracle/admin/contal/udump
max_dump_file_size 10240
core_dump_dest /oracle/admin/contal/cdump
6 rows selected.
Dump directories exists... and all seem to be OK (permissions...).
User who receives the message is not oracle.
Any other thing to check?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 03:19 AM
тАО04-28-2004 03:19 AM
Re: Oracle 8.0.4 returns 7497 error
Very obvious one but whatever : have you checked the space on the device ?
Do you see any syslog entries on filesystem full ?
Cheers,
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 03:31 AM
тАО04-28-2004 03:31 AM
Re: Oracle 8.0.4 returns 7497 error
Could you try to run a session as user oracle (connect as user system)
alter session set SQL_TRACE=TRUE;
select user from dual;
exit and check for the trace file. What is the location of such file ?
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 04:08 AM
тАО04-28-2004 04:08 AM
Re: Oracle 8.0.4 returns 7497 error
I checked space on device and it seems to be OK, I├В┬┤ll re-check syslog looking for any clue.
Jean-Luc,
Trace files are stored in /oracle/rdbms/log, we used themseveral times for "tkprofing".
Do you see any problem with trace?
It├В┬┤s the first time this problem appears in 3 years
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 04:40 PM
тАО04-28-2004 04:40 PM
Re: Oracle 8.0.4 returns 7497 error
The error that you are experiencing ORA 7497 sdpri: cannot create trace file '%s'; errno = %s. implies that the trace file cannot be created for writing.
For this you need to check the USER_DUMP_DEST and BACKGROUND_DUMP_DEST settings point to a valid writable directory. And also check these settings do NOT include an environment variable. Ie: Use full explicit pathnames for these parameters. Check for full OS kernel tables
From the above replies / suggestions looks like all these had been done. ORA-7497 sdpri: cannot create trace file '', errno=. with no information is possibly exhaustion of the file descriptors allowed for a given process OR for the system in total. Check any user limits on file descriptors and raise these.
When you say the user getting this error is ont ORACLE user, did you check manually if you can create a file as that user in the expected directory (oracle/admin/contal/udump and /oracle/rdbms/log) and check if you can create a LARGE file there manually.
And when you say it occurred for the first time since 3 years, was this user able to connect to the database with ProC process before.
Indira A