on 03-16-2007 3:05 PM
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!!!!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It was Ulimits to the oraSID ID. Changed the ulimits to unlimited, restarted the box and the install went thru without issue. Thanks everyone.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.