Sitemap

Amicuk Programming Answers

Dumps due to ORA: 01116

-0001-11-30   Views:0

Advertisement

HELLO, We are getting too many dumps in ECC system "DBIF__RSQL_SQL_ERROR" Please find the log How to correct the error     Database error text........: "ORA-01116: error in opening database file      83#ORA-01110: data file 83: '/oracle/SID

HELLO,
We are getting too many dumps in ECC system "DBIF__RSQL_SQL_ERROR"
Please find the log
How to correct the error
    Database error text........: "ORA-01116: error in opening database file
     83#ORA-01110: data file 83: '/oracle/SID/sapdata12/sr3_67/sr3.data67'#ORA-2704
    1: unable to open file#Linux-x86_64 Error: 13: Permission denied#Additional
     information: 3"
    Internal call code.........: "[RSQL/FTCH/MARM ]"
    Please check the entries in the system log (Transaction SM21).
Regards,
uday

The replay answer
Advertisement
Hi,
As per your question & dump arises may be few things happen-:
1.) Please check permission of all datafiles at OS Level.
2.)Please check sm21 Log .
3.) Please check any datafile may be missing or deleted.
4.) check alert &  trace log of oracle in path /oracle/SID/saptrace.../...
Please check the following points hope this will resolve issue.
get back if u require further assistance.

Go to See the other 5 answers

Dumps due to ORA: 01116

Category:DefaultRelease time:-0001-11-30Views:130

HELLO, We are getting too many dumps in ECC system "DBIF__RSQL_SQL_ERROR" Please find the log How to correct the error     Database error text........: "ORA-01116: error in opening database file      83#ORA-01110: data file 83: '/oracle/SID[More]

Node 1 evicted due to ORA- 29740

Category:DefaultRelease time:2015-10-11Views:130

Hi Guys, We have a two node cluster with 10.2.0.2 on Hp unix 11.31 Yesterday node 1 was evicted by the other node due to ORA 29740 error; When I checked the alert log file I sae some IPC errors, below are some excerpts from the alert log files of bot[More]

Export backup terminated due to ORA-00600: internal error code, arguments:

Category:DefaultRelease time:-0001-11-30Views:130

Hi, exp system/system full=y file=exp_bkp.dmp log=exp_bkp.log statistics=none My export backup terminated unsuccessfully and database also down due to ORA-00600: internal error code, arguments: [17147], [0x4152199C], [], [], [], [], [], [] os version[More]

Getting error in mailing program :Cause: FDPSTP failed due to ORA-29277

Category:DefaultRelease time:2015-10-11Views:130

in the following program i am submitting a request and sending concurrent program log file (.REQ file)as an attachment but getting following error,plese tell me where i am wrong ORACLE error 29277 in FDPSTP Cause: FDPSTP failed due to ORA-29277: inva[More]

Fdpstp failed due to ora-12899 value too large for column

Category:DefaultRelease time:2015-10-11Views:130

Hi All, User facing this problem while running the concurrent program. the program is complted but with rhis error. fdpstp failed due to ora-12899 value too large for column Can any one tell me the excat solution for this? RDBMS : 10.2.0.3.0 Oracle A[More]

Getting Short dump due to large amount of data

Category:DefaultRelease time:2015-10-11Views:130

Hi experts, When we are running RALM_ME_MEASP_FULL_DOWNLOAD_SD  program, every time we are getting Short dump due to large amount of data. please suggest how to run this program without short dump. Thanks & Regards Prashant GuptaHi, you do run the wr[More]

FDPSTP failed due to ORA-06550: line1 ,column:" Wrong number of types of ar

Category:DefaultRelease time:-0001-11-30Views:130

Hi All I am tying to submit the concurrent request through buttom, when i press the button.. the request is submitting but showing the error"FDPSTP failed due to ORA-06550: line1 ,column:" Wrong number of types of argument in call" What are[More]

ORA-01116: error in opening database

Category:DefaultRelease time:-0001-11-30Views:130

I am trying to run a query in UNIX via sqlplus and I am getting this error sqlplus username/password @querymane.sql ORA-00604: error occurred at recursive SQL level 1 ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/u01/app/oracl[More]

Getting Error in Data Collection - FDPSTP failed due to ORA-23401

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am really new to ATP Setup and after referring to the Metalink notes, I have compelted the setups required to calculate ATP in Sales Order Window. But when I am submitting the Data Collection which is the last step I guess, the program is e[More]

Oracle Error code: 1116, message: ORA-01116: error in opening database file

Category:DefaultRelease time:-0001-11-30Views:130

Hi , Please advise on this error message Oracle Error code: 1116, message: ORA-01116: error in opening database file 202 ORA-01110: data file 202: '/u02/app/oracle/oradata/ubidev12/dbf/temp02.dbf' All these while, the dashboard working well in my loc[More]

ORA-20100: ORA-01116: error in opening database file

Category:DefaultRelease time:-0001-11-30Views:130

Hi - I'm hitting this error for the first time. Anyone encountered this before? Any suggestions will be very appreciated. Thanks! 141 EXCEPTION 142 143 when others then 144 raise_application_error('-20100',SQLERRM); 145 End; 146 / 20080207 20080312 D[More]

Hot
OK here the problem, When i plug in my zen touch the computer makes 3 quick "I recognized the device" noises. then nothing shows up anywhere , not in WMP, not in NOMAD explorer, or anywhere. When i Unplug it it makes the Disconnected noise. Help [More]
My gradient filled background is not showing up in Internet Explorer on a PC. I'm working on a MAC, so I don't know of anyway to preview a new MUSE Site in I.E. since it's no longer supported on a Mac. When the Home Page is viewed, my blue sky gradie [More]
Dear Friends, We are using Manual BRS in our client. For this Our client has requested to update the statement automatically. For this we did a BDC progrm to update the statement. BDC program working fine. Because subledger account and main account g [More]
I have Office 2008 for the Mac. Our servers are all Windows servers. I have some alias icons set up on my desktop for some spreadsheet files that live on these servers. If I click on the icon, Excel opens and I can edit the document and save it back [More]
Can anyone gve me any advice on how to make a countdown timer in actionscript 3? I have tried several ways and have so far been unsucessful.Here's something simple: var endDate:Date = new Date(2012, 11, 21); var t:Timer = new Timer(500); t.addEventLi [More]
Hi, I have both the default Apache and MAMP installed. I have succesfully installed subversion and can use svnserve and the command line. I am trying to configure apache, but... There is no moddavsvn in /Apache2/modules and being a 'little knowledge [More]
OAS 4.0.8 documentations states that to invoke a JServlet cartridge, the URL must be in the following format: /virtual_path/java_class_name[path_info][?QUERY_STRING]]http://hostname:port]/virtual_path/java_class_name[path_info][?QUERY_STRING] For exa [More]
hi , i just want to know how can i format my laptop ??Boot to the recovery HD, Command+r keys at startup, open Disk Utility from the screen that comes up. Then select the Macintosh HD name on the left then the Erase tab at the top on the right and cl [More]
Hi All, Can somebody tell how can i get MAC id for maintaing Unique client id at server. or is there any alternative way to do this? Thanks in advance.. CKUsually people just use cookies for that.Read other 2 answers [More]
Been trying to get this Ipad2. Waited on line at the store for 3 hours and they ran out, Purchased it online and got a long April 18 delivery date, went back to the Apple store this morning and waited in the rain only to find they had none. Well that [More]