Oracle Error 7446
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About
Ora-00449: Background Process 'rbal' Unexpectedly Terminated With Error 448
Us Learn more about Stack Overflow the company Business Learn more about hiring ora-01012: not logged on developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange oracle support is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-00449: background process 'MMAN' unexpectedly terminated with error 7446 up vote 1 down vote favorite One of our Oracle servers went down rather badly last night, and we have been unable to bring it online since. Attempting to startup each instance results in: SQL> Connected to an idle instance. SQL> ORA-00449: background process 'MMAN' unexpectedly terminated with error 7446 ORA-07446: sdnfy: bad value '' for parameter . SQL> Disconnected After running this, none of the instances are online. The listener reports that is running, at least. The first instance (asdb) in the order has a number of (mostly repetitive sections) in its alert.log, but nothing in there seems particularly likely. The other instances have blank (but writeable) alert.log files. Where should I investigate to try and get this back online? oracle oracle-10g share|improve this question asked Nov 25 '11 at 1:13 Jivlain 1166 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted For some reason, it seems that the bdump and cdump directories for each instance had been deleted. I don't know who (or what) did that, but restoring them fixed the problem. share|improve this answer answered Nov 25 '11 at 4:07 Jivlain 1166 1 Thanks for posting your solution - I hope you get to the bottom of it and if so please edit your answer here to let us know. In the meantime I suggest you make your answer as 'accepted' –Jack Douglas♦ Nov
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 24 Replies Latest reply on Aug 4, 2010 12:42 AM by jgarry starting DB instance Ramesh_R Aug 3, 2010 9:22 AM Hi , Yesterday i http://dba.stackexchange.com/questions/8391/ora-00449-background-process-mman-unexpectedly-terminated-with-error-7446 had a problem to stop one database instance immediately. I used kill like shown below [oracle@rac1 backup]$ ps -eaf | grep smon oracle 7882 1 0 16:14 ? 00:00:06 asm_smon_+ASM1 oracle 8553 1 0 16:15 ? 00:00:15 ora_smon_rock1 oracle 23324 1 0 16:39 ? 00:00:06 ora_smon_TESTDB oracle 15916 21301 0 17:17 pts/3 00:00:00 grep smon [oracle@rac1 backup]$kill -9 23324to kill https://community.oracle.com/thread/1111041 my TESTDB. Now i need to start the instance. How to do that? when i issued sqlplus / as sydbai got the below error [oracle@ABC /]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 3 11:17:30 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-07446: Message 7446 not found; No message file for product=RDBMS, facility=ORA; arguments: [appl/oracle/product/10.2.0_db/rdbms/log] [user_dump_dest] ORA-07446: Message 7446 not found; No message file for product=RDBMS, facility=ORA; arguments: [appl/oracle/product/10.2.0_db/rdbms/log] [user_dump_dest]What would be the reason and what should i do for the same? I have the same question Show 0 Likes(0) 1988Views Tags: none (add) dbContent tagged with db, instanceContent tagged with instance, startingContent tagged with starting This content has been marked as final. Show 24 replies 1. Re: starting DB instance Chinar Aug 3, 2010 9:27 AM (in response to Ramesh_R) First set ORACLE_HOME then try again: export ORACLE_HOME='location' export ORACLE_SID=
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-07446 JavaScript enabled. This tool uses JavaScript https://venzi.wordpress.com/2008/04/17/strange-oracle-errors-and-their-real-reasons/ and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle error VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace oracle error 7446 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
nomount ORA-00449: background process ‘CKPT' unexpectedly terminated with error 7446 ORA-07446: sdnfy: bad value " for parameter . Damn, checkpoint process doesn't come up but why? The solution is simple and if you ask me the error message is bad. No not bad, it's incomplete. The error was that there didn't exists a bdump and udump directory where the init file pointed to (Oracle 9.2.0.6). And it seems that this is a bad thing for the background process CKPT and pretty sure for all the others too. Not sure what this "sdnfy" means…. A nice other one is this: SQL> shutdown immediate ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Not sure why this Linux error is printed out, but to be fair, that seems to be a problem with that box I'm currently working on. Like this:Like Loading... Related Leave a Comment Leave a Comment » No comments yet. RSS feed for comments on this post. TrackBack URI Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Notify me of new posts via email. About About the author Disclaimer The views expressed on this blog are my own and do not necessarily reflect the views of Oracle and its affiliates! The views and opinions expressed by visitors on this blog are theirs solely and may not reflect mine! Categories Cod