Code:
rflow@ucabclg1pp]netech$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
:o
while connecting to database i am getting the above error.
---------- Post updated at 08:49 AM ---------- Previous update was at 08:48 AM ----------
This error can be rectified by adding the ORACLE_HOME in your .p
I am wanting to create a file in Solaris, so that I can export a few "items" whenever the machine is started up.
i.e.
I want to export ORACLE_HOME and ORACLE_SID and some other directories, of my own, when the machine has started up.
These are the 2 Oracle folders I need to export:
export ORACLE_HOME=/oracle/product/11.1.0/db_1/
export ORACLE_SID=orcl
This is the other folder I need to expor
hi
i have some lines in a text file like,
export ORACLE_HOME=/home/dell/instantclient_11_2
export LD_LIBRARY_PATH=$ORACLE_HOME:${LD_LIBRARY_PATH}
export PATH=$ORACLE_HOME:$ORACLE_HOME/sdk:${PATH}
how to run this file such that every line will be exported in unix session
Hi
Can some one please look this over for errors?
I have a piece of Linux script. It tells me some syntax error. I couldn't find it. Please help me to identify them. Thanks.
Hi,
i have the following code in shell named as test3.sh..
Code:
#!/bin/sh
.
Dear all
I wrote a shell script which runs perfect in OEL linux 5.2 but its failing in AIX 5.3
this scripts check if db is up then it wont proceed else proceed with rest steps.
any help is appreciated.
--------------------------------------------
Code:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/101
ORACLE_SID=yscc02
NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256
export ORACL
ello,
Could you give me some advices on the systemd service and the script it starts which in turn run oracle.
I hv no idea why the systemd service will ruin the oracle listener. whenever I start the listener this way, it shows "support no service."
if i run the 'lsnrctl start' and 'dbstart' manually, it has no problem.
I install sqlplus using these steps https://help.ubuntu.com/community/Oracle%20Instant%20Client
but I am getting error while type "sqlplus"
**sqlplus: error while loading shared libraries: libclntsh.so.11.1:
cannot open shared object file: No such file or directory**
and I check my env variable :
ORACLE_HOME=/usr/lib/oracle/11.2/client
ORACLE_SID=XE
PATH=/usr/local/sbin:/usr/local/bin:/usr/s