Hi all,

Baan: BaanERP5.0c
UNIX: Solaris 8
Database: Oracle 8.0.4
ORACLE_HOME=/baan/oracle/804
ORACLE_SID=baan
The oracle run well.

I had set ORACLE_HOME and ORACLE_SID, but when I run command ora8_inst6.2 in the ${BSE}/bin directory,following the error occur:

Oracle environment settings:
----------------------------
ORACLE_HOME = /baan/oracle/804
ORACLE_SID =
NLS_LANG = american_america.ko16ksc5601
NLS_SORT = binary

Located Oracle utilities:
----------------------------
sqlplus = not found





I can get the ORACLE_SID is baan via command echo $ORACLE_SID, why here can not be got.

Can you help?


Thanks in advance!

Hi,

possibly the environment variable PATH has not the desired path for the sqlplus command.
Try setting PATH:

PATH=$PATH:$ORACLE_HOME/bin

and then run your stuff.

Regards

BaaN recommends NLS_LANG be set to AMERICAN_AMERICA.WE8ISO8859P1

Although this is not related to the original question, I would like to comment on the previous reply.

The nls_character set the database instance is created with does not really matter. Most of the times it depends on other factors than Baan (fi the language of Oracle error messages you prefer).

Once you have choosen any character set, be sure that the NLS_LANG parameter contains the same character set as the one that was used to create the instance.
So WE8ISO8859P1 or US7ASCII or KO16KSC5601 or whatever is OK.

Note that when NLS_LANG is not set, the Oracle client side (the Baan/Oracle driver) defaults to US7ASCII, and Oracle enables a 'feature' to translate data between the client and server side character sets. This results in data (strings, screen dumps) corruption.
To avoid this, keep the NLS settings in sync between client and server, and Oracle will always return what was originally inserted.

Alex,

I get the impression that you set the Oracle parameters, but that they are not seen by child processes of your shell.
Did you 'export' the environment variables, so that they are passed on to child processes? Several shells (like ksh) only pass exported shell variables to their childs.

So I will how to do?





Thank in advance !

in /etc/profile

ORACLE_SID=baan
export ORACLE_SID

I have done as above the thread, I can also get the variable ORACLE_SID, but the error still occur.


Can you help me?




Thanks in advance!

Alex,

Have you checked that the 'sqlplus' program is in your PATH? Try to run 'sqlplus' yourself from within $BSE/bin before executing ora8_inst6.2. By the way, you should use ora8_maint6.2 to create a user.

I can not find "sqlplus" in the $BSE/bin ,can find it in the $ORACLE/bin. I try to run the script "sqlplus" in the $ORACLE/bin as the "root" user,the following error occur:

Enter user-name: system
Enter password:
ERROR:
ORA-07200: slsid: oracle_sid not set


But I run the script "sqlplus" well as the "oracle" user.

Can you help me?



Thanks in advance!

Alex,

The point is that 'sqlplus' needs to be accessible to the ora_maint6.2 utility which is in $BSE/bin. So therefore your $ORACLE_HOME directory must be listed in your PATH environment variable.

If 'sqlplus' is not in $ORACLE_HOME/bin directory, then you have a problem. It should be there. See if it's anywhere else on the system and ask whoever did the Oracle installation if they installed the 'sqlplus' files or not.

The "sqlplus" is in the $ORACLE_HOME/bin, and run well as the "oracle" user. But there is above error as the "root" user.

My $ORACLE_HOME directory had also be listed in PATH environment variable.

But there is still error.


Can you help me?

Thanks in advance!

Alex,

You have to make sure you can run 'sqlplus' as user root without problems. Check the environment of user 'oracle' and 'root' and compare both. Add any Oracle related settings to user 'root' environment if necessary.

This may be a long shot but, check if 'root' is authorized for the primary group of 'oracle' in Unix user settings. This should have been done at install time. Also, check permissions on sqlplus and above directories.