cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01157 after installation restart

Former Member
0 Kudos

Hi All.

I am attempting to install an ECC 5.0 SR 1 system on AIX 5.3 and Oracle 9.2. The installation had an issue during the tablespace creation phase due to incorrect soft/hard filesize limits. This issue has been corrected. However, after restarting the installation, when attempting to create the PSAP<SID> tablespace, I receive the following error:

ERROR 2007-03-16 10:01:04

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-01157: cannot identify/lock data file 3 - see DBWR trace fileORA-01110: data file 3: '/oracle/SRP/sapdata3/srp_1/srp.data1'

Is this possible a leftover lock from the first attempt? Has anyone seen this issue before? How do I correct this please Thanks!!!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

in sql first shutdown the db

then startup in mount mode

drop the table space

alter database datafile '<path>' offline drop;

after dropping shutdown the db again and then startup.

this will eliminate the error ORA-01157.

Pl dont forget to award points is resolved.

Regards

Answers (4)

Answers (4)

Former Member
0 Kudos

It was Ulimits to the oraSID ID. Changed the ulimits to unlimited, restarted the box and the install went thru without issue. Thanks everyone.

Former Member
0 Kudos

Hi All,

There is no datafile yet. However, in the ORacle logs, I can see this:

ORA-01157: cannot identify/lock data file 3 - see DBWR trace file

ORA-01110: data file 3: '/oracle/SRP/sapdata3/srp_1/srp.data1'

ORA-27092: skgfofi: size of file exceeds file size limit of the process Additional information: 131071 Additional information: 256001 Deleted file /oracle/SRP/sapdata3/srp_1/srp.data1

ORA-1157 signalled during: CREATE TABLESPACE PSAPSRP DATAFILE '/oracle/SRP/sa...

Which is odd, becasue root has hard/soft fsize limits set at -1. What else can be limiting the creation of this file? Oh, the specific SQL command in question here is:

CREATE TABLESPACE PSAPSRP DATAFILE

'/oracle/SRP/sapdata3/srp_1/srp.data1' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

So, we're only talking about a 2GB file. Thanks everyone.

Former Member
0 Kudos

Hello Tim,

To discard size problems, why don't you try to run the command from a sqlplus, but modifying the file sizes? ...(initial 1000M, maxsize 1500M).

If the tablespace is created without errors, then you're sure there's a OS parameter problem.

Best Regards,

JC Llanes.

former_member204746
Active Contributor
0 Kudos

check fsize limits of user ora[sid] ...

former_member204746
Active Contributor
0 Kudos

check date/timestamp on this file, if it has the date/time of your old installation, you can rename it. Anyways, if this fails, you can always restart DB load from scratch after deleting all sapdata files.

Former Member
0 Kudos

can you pl check whether the file is available at location /oracle/SRP/sapdata3/srp_1/srp.data1

check SAP Note 24169 - ORA 1157

Note 546006 - Problems with Oracle due to operating system errors

Cheers,

-Sunil