Skip to Content
author's profile photo Former Member
Former Member

Oracle Pre-Load Actions error

HI All,

I am trying to install SAP R/3 4.7 IDES, Oracle 9 with patch 9.2.0.3.0 on 2003 Server SP2. I have encountered the following error during Database Instance installation step of Oracle Pre-load Actions .

CJS-00084 SQL Statement or Script failed. Error Message: Executable C:\oracle\ora92/bin/sqlplus.exe returns 3.

ERROR 2007-06-13 10:25:46

FJS-00012 Error when executing script.

I have already tried following solutions.

1) directory C:\oracle\ora92/bin/sqlplus.exe is there I able to connect as sysdba

2) I changed “C:\SAPinst_Oracle_KERNEL" name with no spaces

3) Installed Oracle without installing Database.

I think I am making a mistake in following two steps.

1) I did installed Ms Loop Back adapter but what exact entry I need to put in Host file?

2) When I installed Oracle and run “Sapserver.cmd” file, windows message popup and ask which program I want to use to open “Sapserver.rsp” file and I choose notepad.

After Oracle installed, I run some Sqlplus commands and able to connect as sysdba but listener status command showing one listener is running and other status unknow. After installation stop, Listener status giving TNS adapter error.

Please help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jun 28, 2007 at 10:29 AM

    > 1) directory C:\oracle\ora92/bin/sqlplus.exe is there

    the <b>correct path</b> to your oracle home should be something like <b>\oracle\<SID>\<oracle version> ==> \oracle\TST\920

    </b>

    > 1) I did installed Ms Loop Back adapter but what

    > exact entry I need to put in Host file?

    i do not think you will need a loopback adapter when installing on win2k3 srv...what you'll need is a hostname (afaik without any domains etc) and an (unique) ip address...the ports used by sap (eg. 3200, 3300 etc.) must be available (= not used by any other application on that server)

    -> which guides/notes did you follow?

    GreetZ, AH

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 06:39 AM

    try to find out which sql-script should be executed.

    Edit the script and delete the line

    WHENEVER OSERROR.....

    restart the installation.

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 06:56 AM

    >> have already tried following solutions.

    >>1) directory C:\oracle\ora92/bin/sqlplus.exe is there I able to connect as sysdba

    >>2) I changed “C:\SAPinst_Oracle_KERNEL" name with no spaces

    >>3) Installed Oracle without installing Database.

    never change the directory name of SAPinst working directory. It is designed in this version to use a directory with spaces and it will work with it.

    What you should not do is to copy additional CDs (like Export, Kernel) into directories having blanks in the path.

    >>1) I did installed Ms Loop Back adapter but what exact entry I need to put in Host file?

    >>2) When I installed Oracle and run “Sapserver.cmd” file, windows message popup and ask which program I want to use to open “Sapserver.rsp” file and I choose notepad.

    That should not happen at all.

    The response file is opened by Oracle's setup.exe which is invoked by sapserver.cmd. Is the Oracle CD located on a directory containing blanks?

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 07:51 PM

    Thanks for reply.

    Which .sql file to look for WHENEVER OSERROR..... ?

    I serached all the .sql files but can't find WHENEVER OSERROR......

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.