Oracle Error 1157 Encountered
Contents |
db to dump file, ORA-01157 error If this is your first visit, be sure to check out the FAQ by clicking
Ora-01157 Ora-01110
the link above. You may have to register before you can ora-01157 cannot identify/lock data file tempfile post: click the register link above to proceed. To start viewing messages, select the forum that you ora 01157 ora 01110 system01 dbf want to visit from the selection below. Results 1 to 8 of 8 Thread: exporting db to dump file, ORA-01157 error Tweet Thread Tools Show Printable Version Email
Ora-01110 Data File 201
this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-08-2005,04:39 AM #1 chandrasekhar20 View Profile View Forum Posts Junior Member Join Date Mar 2005 Posts 4 exporting db to dump file, ORA-01157 error Hello oh good men of DBASupport!!! I am trying to make a dump file out
Dbwr Trace File Location
of my database and have been encountering the error . exporting tablespace definitions EXP-00008: ORACLE error 1157 encountered ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf' EXP-00000: Export terminated unsuccessfully The same error occurs when I try to load data using the "imp" command. Please help me out here. This is getting critical for my project. Thanks in advance. Chandra Reply With Quote 03-08-2005,04:42 AM #2 OracleDoc View Profile View Forum Posts The Doc is in! Join Date Sep 2003 Location over the hill and through the woods Posts 995 What did Metalink have to say about it? Oracle it's not just a database it's a lifestyle! -------------- BTW....You need to get a girlfriend who's last name isn't .jpg Reply With Quote 03-08-2005,04:47 AM #3 anandkl View Profile View Forum Posts Senior Advisor Join Date Aug 2001 Location chennai,bangalore Posts 840 Hi, Check the status of this file select status from dba_data_file where file_name='FILE_NAME'; Also see if th
chandrasekhar200 Messages: 5Registered: March 2005 Location: none Junior Member Hi all, I am trying to make a dump file out of my database and have been encountering the error . exporting tablespace definitions alter system check datafiles EXP-00008: ORACLE error 1157 encountered ORA-01157: cannot identify/lock data file 201 - see
Ora-01157 Cannot Identify/lock Data File Standby
DBWR trace file ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf' EXP-00000: Export terminated unsuccessfully The same error occurs when I try to ora-01157 ora-01110 solution load data using the "imp" command. Please help me out here. This is getting critical for my project. Thanks in advance. Chandra Report message to a moderator Re: ORA-01157 [message http://www.dbasupport.com/forums/showthread.php?46668-exporting-db-to-dump-file-ORA-01157-error #110541 is a reply to message #110510] Tue, 08 March 2005 09:36 vjeedigunta Messages: 201Registered: March 2005 Location: Hyderabad Senior Member is the temp file present .. ? Report message to a moderator Re: ORA-01157 [message #110593 is a reply to message #110510] Tue, 08 March 2005 17:19 KumarD Messages: 8Registered: March 2005 Location: india Junior Member Hi, please type the following http://www.orafaq.com/forum/t/41986/ command at SQL/SVRMGRL prompt by connecting as Sysdba select status from v$tempfile where file#=201 if the status displayed as offline...then checkout the location of the file...confirmed whether file is there or not.... if the file is corrupted or missing and u want to avoid recovery steps then it's a file which belongs to temporary tablespace please create a new temporary tablespace then do the export/import it will work the problem why you got the error is Export/Import when it operates on database it needs a temporary segments from a tempfile....if that file is not available then it cannot perform it's operation kumar Report message to a moderator Re: ORA-01157 [message #110595 is a reply to message #110510] Tue, 08 March 2005 18:31 dilip kumar Messages: 111Registered: December 2003 Senior Member hi checkout the temp01.dbf file status.... Dilip Report message to a moderator Re: ORA-01157 [message #111042 is a reply to message #110510] Sat, 12 March 2005 12:23 chandrasekhar200 Messages: 5Registered: March 2005 Location: none Junior Member Hi KumarD, God bless you man! It worked. I had to make a tablespace, make it the default temp. tablespace and then dr
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don http://www.dba-oracle.com/t_ora_01157_cannot_identify_lock_data_file_string_see_DBWR_trace_file.htm Burleson Blog
ORA-01157 tips Oracle Database Tips by Burleson Consulting December 15, 2015 Question: I'm getting the ORA-01157 and https://community.oracle.com/community/developer/search.jspa?q=ORA-01157 ORA-01110 when trying to bring my tablespaces online: SQL> alter tablespace example online; alter tablespace example online * ERROR at line 1: ORA-01157: cannot identify/lock data file 5 - see DBWR data file trace file ORA-01110: data file 5: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF' How do I fix this ORA-01157 error? Answer: First, the Oracle docs note this on the ORA-01157 error: ORA-01157: cannot identify/lock data file string - see DBWR trace file Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. ora-01157 cannot identify/lock The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES. As we see, the ORA-01157 is caused by a locking issue with the database writer (DBWR) background process. During a recovery, this can be caused by a unopened data files (i.e. database mounted but not open), a missing file, a permission problem in the file (e.g. no write permissions 770 on the files owned by Oracle). If the background process is unable to reach a data file, or is unable to lock it because it is in use , ORA-01157 is thrown because the database does not allow access. The other files will not be affected, but it is important to know that opening the database using the first instance will need to use online data files. there should bCommunityOracle 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.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle 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 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