on 04-25-2010 1:55 PM
Hi,
I am in a process of installing EHP4 READY on Solaris , with ORacle database.
at 13 Phase CREATE DATABASE, the installation hangs up
when i check the log ora_sql_results.log it says
SP2-0310: unable to open file "ora_scr_tmp.sql"
not getting any clue i have added group sapinst to user orasid, and also gave full permission to the file
"ora_scr_tmp.sql "
still no luck,
please advise.
Regards,
Irfan..
Hi my friend
What's your Oracle patch version?
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi again,
I found the error now and the issue is solved by changing the permissions of the /tmp/sapinst_instdir ...before 770 now 777 and all is working fine.
bye
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
could you please explain how you resolve the issue, which permissions have you changed. I'm stuck with the same issue
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
it was permission problem, i gave full persmissions, its working fine..
Thanks to all of you.
Regards,
Irfan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Irfan,
SP2-0310: unable to open file "ora_scr_tmp.sql"
There are 3 possibilities...
1. Users and there Group membership is incorrect.
2. ORACLE_HOME directory permissions are not set or incorrect.
3. Profile parameters are not set..
Check this as below:
1. Check the Users and Group membership as below:
Users -----------> Primary Groups
---------------------------------------------------------
<SID>adm ------> sapsys,oper,dba,sapinst
ora<SID> -------> dba,oper,sapinst
2. Check that ORACLE_HOME has 755 permissions and ora<sid>:dba should be the user and owner. You can set it with below command:
# chmod 755 -R /oracle
# chown ora<SID>:dba -R /oracle
3. Check if you defined ORACLE_HOME and ORACLE_SID environment variable for user ora<SID>.
Regards.
Rajesh Narkhede
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.