Home » Infrastructure » Linux » os autentication error
os autentication error [message #556667] Tue, 05 June 2012 23:55 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i just try to create the user authencated by os. i follow the below steps
# useradd pritesh
# passwd ranjan

SQL> SHOW PARAMETER os_authent_prefix

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix                    string      ops$
SQL>

CREATE USER ops$pritesh IDENTIFIED EXTERNALLY;
GRANT CONNECT TO ops$pritesh;

su - pritesh
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=ORCL
sqlplus /

when i m going to connect it gives the follwoing error

sqlplus:error while loading shared libraries: libsqlplus.so: cannot open shared object file: no such file or directory.

[pritesh@localhost ~]$
where i have done mistake please suggest me. os rhel 4 oracle 10.2.0.1.0.

regards
pritesh ranjan

[EDITED by LF: removed superfluous empty lines; applied [code] tags]

[Updated on: Wed, 06 June 2012 01:38] by Moderator

Report message to a moderator

Re: os autentication error [message #556672 is a reply to message #556667] Wed, 06 June 2012 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your environment is not correctly set.
Post "env | sort".

Regards
Michel
Re: os autentication error [message #556769 is a reply to message #556672] Wed, 06 June 2012 08:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>sqlplus:error while loading shared libraries: libsqlplus.so: cannot open shared object file: no such file or directory.
could be OS permission (or lack thereof)
Re: os autentication error [message #556775 is a reply to message #556769] Wed, 06 June 2012 09:34 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
could be OS permission (or lack thereof)

i can't understand it please clear it.

thanks & regards
pritesh ranjan
Re: os autentication error [message #556776 is a reply to message #556775] Wed, 06 June 2012 09:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
does OS user have OS permission to access file "libsqlplus.so"?
lack of OS permission could produce posted error message
Re: os autentication error [message #556784 is a reply to message #556776] Wed, 06 June 2012 10:38 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
how can i check it os user have permission or not to access the file "libsqlplus.so". please clear it or any link suggest me.

by the way i m confused to set my environment. when i type the env command on my command prompt this give me following output.

[oracle@localhost ~]$ env
SSH_AGENT_PID=3173
HOSTNAME=localhost.localdomain
DESKTOP_STARTUP_ID=
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
WINDOWID=48234577
GTK_MODULES=gail:atk-bridge
USER=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
ORACLE_SID=orcl
GNOME_KEYRING_SOCKET=/tmp/keyring-OliGCH/socket
ORACLE_BASE=/u01/app/oracle
SSH_AUTH_SOCK=/tmp/ssh-lnMjUL3108/agent.3108
SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/3108
USERNAME=oracle
MAIL=/var/spool/mail/oracle
DESKTOP_SESSION=default
PATH=/usr/kerberos/bin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/u01/app/oracle/product/10.2.0/db_1/bin:/bin:/usr/bin:/usr/l ocal/bin:/usr/X11R6/bin
GDM_XSERVER_LOCATION=local
INPUTRC=/etc/inputrc
PWD=/home/oracle
XMODIFIERS=@im=none
LANG=en_US.UTF-8
ORACLE_TERM=xterm
GDMSESSION=default
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/home/oracle
SHLVL=2
GNOME_DESKTOP_SESSION_ID=Default
TMP=/tmp
LOGNAME=oracle
CVS_RSH=ssh
CLASSPATH=/u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/ jlib
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-JDxLqblwGj,guid=ecbdc94fcb26b3f28ebc2cc4ee7d4800
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
G_BROKEN_FILENAMES=1
COLORTERM=gnome-terminal
XAUTHORITY=/tmp/.gdmK2OAFW
_=/bin/env

i confisud here to set the oracle path.i dont know which is my oracle path and how can i set them such as (export PATH=$PATH:$ORACLE_HOME/bin).

thanks & regards
pritesh ranjan
Re: os autentication error [message #556786 is a reply to message #556784] Wed, 06 June 2012 10:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
why are you using an OS where you don't know OS basics?

>how can i check it os user have permission or not to access the file "libsqlplus.so"?
could you answer this question when OS was Windows?

[Updated on: Wed, 06 June 2012 11:02]

Report message to a moderator

Re: os autentication error [message #556792 is a reply to message #556784] Wed, 06 June 2012 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when i type the env command on my command prompt this give me following output.


Please post "env | sort"

I see no LD_LIBRARY_PATH nor LIBPATH variable (not know which is relevant on your system, set both to contain Oracle libraries).

Regards
Michel

[Updated on: Wed, 06 June 2012 11:05]

Report message to a moderator

Re: os autentication error [message #556871 is a reply to message #556792] Thu, 07 June 2012 02:22 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
output of the command

env|sort

[oracle@localhost ~]$ env|sort
_=/bin/env
CLASSPATH=/u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/ jlib
COLORTERM=gnome-terminal
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-i1cQrte0Zw,guid=dba0ca4fa1ef8f6bbc6996a6476b8000
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-WY8XmC/socket
GTK_MODULES=gail:atk-bridge
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=localhost.localdomain
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_SID=orcl
ORACLE_TERM=xterm
PATH=/usr/kerberos/bin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/u01/app/oracle/product/10.2.0/db_1/bin:/bin:/usr/bin:/usr/l ocal/bin:/usr/X11R6/bin
PWD=/home/oracle
SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/3128
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=3192
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-JStBHz3128/agent.3128
TERM=xterm
TMP=/tmp
USERNAME=oracle
USER=oracle
WINDOWID=50331729
XAUTHORITY=/tmp/.gdm14DHFW
XMODIFIERS=@im=none
[oracle@localhost ~]$

regards
pritesh ranjan
Re: os autentication error [message #556876 is a reply to message #556871] Thu, 07 June 2012 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I see no LD_LIBRARY_PATH nor LIBPATH variable (not know which is relevant on your system, set both to contain Oracle libraries).


Regards
Michel
Re: os autentication error [message #556945 is a reply to message #556876] Thu, 07 June 2012 08:16 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
could be OS permission (or lack thereof)
i just provide the os permission to a specific file by using the chmod command from root user as define below.

#chown pritesh:pritesh '/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so'

#chmod 777 '/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so'

[pritesh@localhost ~]$ ls -l '/u01/app/oracle/product/10.2.0/db_1/libsqlplus.so'

-rwxrwxrwx 1 pritesh pritesh 1047293 Jun 22 2005 libsqlplus.so

[pritesh@localhost ~]$ ls -l '/u01/app/oracle/product/10.2.0/db_1/lib'

-rwxrwxrwx 1 pritesh pritesh 1047293 Jun 22 2005 libsqlplus.so
now when i m trying to start the sqlplus gives the follwing error.

[pritesh@localhost ~]$ 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

thanks & regards
pritesh ranjan


Re: os autentication error [message #556948 is a reply to message #556945] Thu, 07 June 2012 08:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

what don't you understand regarding about error above?
Re: os autentication error [message #556982 is a reply to message #556948] Thu, 07 June 2012 21:59 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

the oracle_home path is already set. just like i check

HOME=/home/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=/usr/kerberos/bin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/u01/ap
p/oracle/product/10.2.0/db_1/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin

where i m doing mistake and which path i will set.
if i m wrong then how can i get the right path of oracle_home.

regards
pritsh ranjan

Re: os autentication error [message #556986 is a reply to message #556982] Thu, 07 June 2012 22:19 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i always get this error whern change the user pritesh to oracle.

[pritesh@localhost ~]$ su - oracle
Password:
-bash: /u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i386/server:: No such file or directory
-bash: /u01/app/oracle/product/10.2.0/db_1/rdbms/lib:/u01/app/oracle/product/10.2.0/db_1/lib:/usr/lib:/usr/X11R6/lib: No such file or directory
[oracle@localhost ~]$
is this error SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
occur due to missing the above file.

regards
pritesh ranjan
Previous Topic: System tablespace datafiles
Next Topic: Default tablespaces in ORACLE
Goto Forum:
  


Current Time: Thu Mar 28 14:35:18 CDT 2024