Operating System - HP-UX
1748249 Members
3724 Online
108760 Solutions
New Discussion юеВ

Re: svrmgrl & sqlplus error

 
Amod
Occasional Advisor

svrmgrl & sqlplus error

I have just installed Oracle 8.1.7 Enterprise Edition on HP-UX 11.11 During installation it installed a dummy database. But I am not able to connect to this databse. I get following error when I run 'svrmgrl'

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Message 4505 not found; No message file for product=SVRMGR, facility=MGR

Error while trying to retrieve text for error ORA-12571
SVRMGR>

Also when I try to run 'sqlplus' it gives me following error

$ sqlplus
Message file sp1.msb not found
Error 6 initializing SQL*Plus

I searched on the net and figured out that it is something to do with NLS_LANG envirnment variable setting. I am not sure what should be the setting for this variable as the installation guide says if you don't set it will take default (US7ASCII).

Can some one help ?
If you can't change it, enjoy it !!
2 REPLIES 2
John Palmer
Honored Contributor

Re: svrmgrl & sqlplus error

This sounds as though you haven't got your Oracle shell environment set-up correctly.

As well as having $ORACLE_HOME/bin in PATH, as a minimum you also require the following variables to be exported:-

ORACLE_HOME
SHLIB_PATH
ORACLE_SID

Could you please post the output from env, run from your shell.

Regards,
John
Amod
Occasional Advisor

Re: svrmgrl & sqlplus error

Hi John,

Thank you so much .. When you mentioned 'env' I remembered that 'oraenv' needs to be run from .profile of oracle user. How stupid of me to have missed that ?

Thanks again.

Amod.
If you can't change it, enjoy it !!