Oracle Error 1157
Contents |
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
Ora-01157 Ora-01110
. exporting tablespace definitions EXP-00008: ORACLE error 1157 encountered ORA-01157: cannot identify/lock ora-01157 cannot identify/lock data file tempfile data file 201 - see DBWR trace file ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf' EXP-00000: Export terminated unsuccessfully The
Dbwr Trace File Location
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 Report ora 01157 ora 01110 system01 dbf message to a moderator Re: ORA-01157 [message #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 alter system check datafiles KumarD Messages: 8Registered: March 2005 Location: india Junior Member Hi, please type the following 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:
db to dump file, ORA-01157 error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can
Ora-01110 Data File 201
post: click the register link above to proceed. To start viewing messages, select the ora-01157 ora-01110 solution forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: exporting db to
Ora-01157 Cannot Identify/lock Data File Standby
dump file, ORA-01157 error Tweet Thread Tools Show Printable Version Email 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 http://www.orafaq.com/forum/t/41986/ 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 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' http://www.dbasupport.com/forums/showthread.php?46668-exporting-db-to-dump-file-ORA-01157-error 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 this files needs recovery. select * from v$recover_file; Also check the most recent tracefile generated. It would tell you exactly what would be the issue. Try running dbverfiy on this datafile. It could be that this particular datafile is corrupt. regards anandkl anandkl Reply With Quote 03-08-2005,05:11 AM #4 OracleDoc View Profile View Forum Posts The Doc is in! Join Date Sep 2003 Location over the hill and thr
and SafetyAsset NetworkAsset https://scn.sap.com/thread/3382583 Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster http://www-01.ibm.com/support/docview.wss?uid=swg21476723 Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital data file AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel ora-01157 cannot identify/lock Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT
or 126 Technote (troubleshooting) Problem(Abstract) I am trying to create a new data source in the ODBC data source Administrator by using the SPSS_OEM ODBC drivers. I can select the driver and enter in what I think is the correct information to access my data, but I keep receiving this error message when I try to test the connection: Specified driver could not be loaded due to system error 126 (Driver) or Specified driver could not be loaded due to system error 1157 (Driver) Where (Driver) is the name of the driver you are using. What is happening? Resolving the problem There are four possible reasons for receiving this error message: 1) The appropriate client software needs to be installed. Refer to the System Requirements of the driver you are trying to configure for the specific client software requirements. System Requirements can be found in the Connect ODBC Reference Guide. The Connect ODBC Reference Guide can be accessed on the SPSS CD-ROM under /Merant/books/Connodbc/Books.pdf. Choose the Connect ODBC Reference Guide from the menu. For example, if you are trying to configure a Data Source for the DataDirect Connect ODBC driver for Oracle, you must have SQL*NET or Net8 installed (the client software version required will depend on the database version). Users must have the 32-bit version of the client software installed for a 32-bit driver/database and the 16-bit version of the client software a 16-bit driver/database. Reboot your computer after any changes. 2) The client software is not on System Path. Please refer to solution # 19786, "What are the client software requirements for the SPSS_OEM Connect ODBC drivers?". This solution contains a list of file names that can be used to locate the client installation directories. The files in that list are not the only client software files needed, they are listed only to assist in locating the installation directory of the client software packages. The directory where the database-specific client software is installed must be added to the System Path. There are occas