Prev: what does dbms_stat.gather_database_stats_job_proc do?
Next: dbora not start automatically database
From: JMecc on 7 May 2007 13:30
Thanks for the help. The bashrc file now includes:

export CLASSPATH=./:/usr/scratch/jdbc/lib/classes12.zip
export ORACLE_BASE=/database
export ORACLE_HOME=$ORACLE_BASE/Oracle10g/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH

but I still get an error trying to run sqlplus:

bash-3.00$ . oraenv
ORACLE_SID = [jrl2] ? btap
bash-3.00$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

What should my ORACLE_HOME be? The locations are:

bin: /database/Oracle10g/bin
files: /database/Oracle10g
data: /database/oradata
inventory: /u01/app/oracle/oraInventory

Thanks,
Jonathan

From: Frank van Bortel on 7 May 2007 13:46
JMecc schreef:

> What should my ORACLE_HOME be? The locations are:
>
> bin: /database/Oracle10g/bin
> files: /database/Oracle10g
> data: /database/oradata
> inventory: /u01/app/oracle/oraInventory
>
<quote>
And, to top things off:
export PATH=$ORACLE_HOME/bin:$PATH
</quote>

You say: bin: /database/Oracle10g/bin
That would make ORACLE_HOME equal to /database/Oracle10g,
now wouldn't it?

Fits with your "files" location, I'd say.
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
From: JMecc on 7 May 2007 14:11
Yes, that ORACLE_HOME makes sense, but changing that and logging out &
back in still doesn't help. The error is exactly the same either
way.

bash-3.00$ . oraenv
ORACLE_SID = [jrl2] ? btap
bash-3.00$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

Jonathan

From: Keith on 7 May 2007 14:21
On May 7, 2:11 pm, JMecc <j...(a)telus.net> wrote:
> Yes, that ORACLE_HOME makes sense, but changing that and logging out &
> back in still doesn't help. The error is exactly the same either
> way.
>
> bash-3.00$ . oraenv
> ORACLE_SID = [jrl2] ? btap
> bash-3.00$ sqlplus
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software
> directory
>
> Jonathan

$ORACLE_HOME/install/changePerm.sh

From: JMecc on 7 May 2007 14:51
I find no such script (changePerm.sh) in the $ORACLE_HOME/install
directory, nor with find:

bash-3.00$ find -name changePerm*
bash-3.00$ find -name *Perm*
../sysman/admin/scripts/db/ohFilesPerm.pl
../sysman/admin/scripts/db/ohExeBinPerm.pl
../sysman/admin/scripts/db/iFileRefPerm.pl
../sysman/admin/scripts/db/dbAuditPerm.pl
../sysman/admin/scripts/db/dbDataFilePerm.pl
../sysman/admin/scripts/db/dbInitParamFilesPerm.pl
../sysman/admin/scripts/db/dbControlFilesPerm.pl
../oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
jaznPrincipalPerms.uix
../oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
jaznGranteePerm.uix
../oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
jaznPermissionMgt.uix
../oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
jaznNewGrantPermission.uix
../jdk/demo/plugin/jfc/SwingSet2/src/Permuter.java
../jdk/demo/jfc/SwingSet2/src/Permuter.java
bash-3.00$ find -name *change*
../sysman/admin/scripts/db/changeStateJob.pl
../sysman/admin/emdrep/sql/db/latest/changemgr
../assistants/dbca/doc/help/dbcaasm_change_disk_discovery_path.html
../oc4j/j2ee/oc4j_applications/applications/em/em/images/database/sql/
changeditemicon_status.gif
../nls/data/old/data_changes.htm

Could you open it and check which files are affected?
Jonathan

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: what does dbms_stat.gather_database_stats_job_proc do?
Next: dbora not start automatically database