on 03-02-2011 11:04 PM
Hi All,
I am fairly new to SAP BASIS setup. I have installed IDES ECC 6.0 on Oracle(Win2003 as a guest on VMWare).
At the time of installation the install program installed a part of the Oracle database files on an external harddisk.
The ABAP server starts normally and I am able to connect to it without any issues. However, the disp+work.EXE always stays on yellow with a message : J2EE status info unavailable.
When I tried to connect to the database through configtool to check the setup of the parameter I am unable to connect to the database I get the following error:
Error occurred while working with Configuration(Scanning). Msg:Error while connecting to DB.
and the system.log shows
java.sql.SQLException: ORA-00376: file 102 cannot be read at this time and then ORA-01110: data file 102: "<location>".
Although the file is present at the location mentioned. This is the location of the external hard drive which is available with the correct drive letter. Is there anyway this can be resolved?
I would definitely like to get the Java server up and running.
All help is highly appreciated guys! Thanks.
Regards,
Manish
Hi,
Check SAP Note 328785 - ORA-00376: File cannot be read at this time
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny,
Thank you so much for the reply. But, now when I try to connect to Oracle it tells me that Oracle is not available.
Just to let you know I changed the paging file size before I posted the message earlier to 20 GB, just to see if that would solve the issue. Could this Oracle issue be a result of this change?
Thanks again.
Regards,
Manish
Hey Sunny, you are star!!
This note helped me resolve this issue!!
Now my Java server is also up and running I have greens!!
The issue with Oracle not available was resolved by the below:
"
/message/1824609#1824609 [original link is broken]
Re: ORA-01034: Oracle not available after service restart
Posted: Aug 16, 2007 12:28 PM in response to: user588442 in response to: user588442
One thing to check. If the Oracle service starts, but you get the "Connected to idle instance" is in the Registry on windows boxes.
Start->Run-> type in REGEDIT and hit return.
In the Registry editor, navigate to HKEY_LOCAL_MACHINEsoftwareOracle
Under this key, you should have a key like: Ora_db10g_Home1, or whatever you called your ORACLE_HOME. Under there, you should see: ORA_<SID>_AUTOSTART. Make sure that is set to TRUE. This starts the actual instance when the service starts. Otherwise, if set to FALSE, the service will start, but the database is "idle"."
Thank you.
Appreciate all your help man...
Manish
ERP, EAI, BI
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.