UNIX for Dummies Questions & Answers

In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found"..

set the necessary profiles.

or execute with the full path of sqlplus

i am new to unix can u tell me how to find the files and wht path i need to mentioned i am strugling for this since last 1 month

---------- Post updated at 04:08 AM ---------- Previous update was at 03:49 AM ----------

i got the files $ORACLE_HOME now i want to know in which file i need to make change to login in oracle

Did you install the database as root or is root member of the os-group dba ? If non of both you will not be able to connect as sysdba.
Usually sqlplus is located at $ORACLE_HOME/bin. You specified ORACLE_HOME during installation of the database (or the database-client).
The default ORACLE_HOME varies between Oracle-releases.

Usually databases are not installed by root but a seperate user (the default username is oracle). Find out if there is such a user on your system (an easy way would be to view /etc/passwd). Oracle-Versions >= 8i come with a script that sets up the environment for you which is /usr/local/bin/oraenv. /usr/local/bin usually is part of your standard PATH. So assuming your database-user is oracle logging in would look like this after you log in to root:

Code:

su - oracle
. oraenv
-- here you're asked which ORACLE_SID you'd like to work with
sqlplus / as sysdba

m facing one more problem in unix when m pressing @ sign so automatically system put me on next just becaue of that m not able to execute sql files
SQL> @
a.sql

Imho. This is not a routine unix problem. Not heard of this exact fault before and it would take some effort to generate this effect with unix commands. Spilling coffee in the keyboard would be easier!

First: Can you try a different physical keyboard? Can you try a different terminal? Anybody else got the problem?

Second: Ignoring sqlplus. Does typing the @ character at the shell command prompt behave differently when you are logged in as root compared with when you are logged in as oracle or any other user?

I second methyl that you should investigate this strange behavior.
But as a workaround to your actual problem you may use the SQL*Plus-command start instead of @ to start a command-file.