- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: weird problem when login in using sqlplus from...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 04:57 AM
тАО05-19-2003 04:57 AM
user could not login to DB using
sqlplus user/password eventhough environment for ORACLE_HOME and ORACLE_SID were correct.
got error :
ORA - 01034 OracleNot Available and
ORA - 27101 Shared Memory Realm Does Not Exist.
From Unix user oracle, I could login fine.
sudo to such user,and indeed, could not login, but, if I used
sqlplus user/pass@SID, it worked fine !!! ???
so, problem must be with tnsnames.ora, I thought. I have a symb link from
/etc/tnsnames.ora and all other .ora files to
$ORACLE_HOME/network/admin/*ora files. Changed premissions on the tnsnames file to be wide open.
SAME PROBLEM :-((( !!!!
looked at oracle account, and ORACLE_HOME was
/u00/app/oracle/product/8.1.7 while user's ORACLE_HOME was /u00/app/oracle/product/8.1.7_64
THere is a symbolic link from 8.1.7_64 to 8.1.7, meaning that they point to the same directory.
When I changed his ORACLE_HOME to point to the 8.1.7 directory, it WORKED FINE !!! ??????
Validate it by changing the ORACLE_HOME for the oracle unix account, and IT FAILED to work there.
Question ? WHY ???
links point to the same directory, and tnsnames is a link from /etc pointing to the proper place ? What am I missing here ?
thanks,
Henrique
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 05:02 AM
тАО05-19-2003 05:02 AM
Re: weird problem when login in using sqlplus from non oracle unix account
TNS_ADMIN=/app/bin/oracle817/network/admin
Also, can you perform an 'env' as the user concerned and post it here?
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 05:12 AM
тАО05-19-2003 05:12 AM
Re: weird problem when login in using sqlplus from non oracle unix account
Have you set your TNS_ADMIN environment variable?
Normally, with 8.1.7, the ora-27101 is reporting that the shared memory key generated by the client doesn't match any currently existing keys. This is to be expected if the ORACLE_HOME used by the client isn't the same as the one used to startup the database with OR the ORACLE_SID is not correctly referencing the right instance.
Please revert
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 05:17 AM
тАО05-19-2003 05:17 AM
Re: weird problem when login in using sqlplus from non oracle unix account
I CAN login using sqlplus, as long as I qualify the string with the @SID_NAME, even with the 8.1.7_64 directoryon ORACLE_HOME.
without the @SIDNAME string, will only work fine, if I have 8.1.7 directory instead.
????????????????????????????
env for such user is :
> env
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt
/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/samba/man:/opt/resmon/share/man:/opt/pred/share/man/%L:/opt/pred/
share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/sudo/man:/opt/perf/man/%L:/opt/perf/man:/opt/OV/man/itose/%L:/opt/OV/man/itose:/opt/graphics/common/man
:/opt/audio/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/image/share/man:/opt/imake/man:/opt/pwplus
/share/man://opt/perl/man
PATH=/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/opt/perl/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/con
trib/bin/X11:/opt/resmon/bin:/usr/sbin/stm/uut/bin/progs:/opt/pred/bin:/opt/hparray/bin:/usr/sbin/diag/contrib:/opt/sudo/bin:/opt/perf/bin:/opt/OV/bin/OpC:/opt/graphic
s/common/bin:/opt/langtools/bin:/opt/imake/bin:/usr/local/bin:/opt/pwplus/bin:.:/develop/radia/bin:/develop/radia/link:/u00/app/oracle/product/8.1.7/bin:/u00/app/oracle/product/8.1.7/lib:.
COLUMNS=167
EDITOR=vi
LOGNAME=SOMEUSER
HOSTNAME=SOMESERVER
ORACLE_SID=SIDNAME
ERASE=^H
PS1=$HOSTNAME:$PWD/
Radia >
SHELL=/usr/bin/ksh
HISTSIZE=1000
HOME=/home/SOMEUSER
TERM=hpterm
ORACLE_HOME=/u00/app/oracle/product/8.1.7
PWD=/home/SOMEUSER
TZ=EST5EDT
ENV=/home/SOMEUSER/.kshrc
LINES=55
uxsd01:/home/SOMEUSER/
Again,
sqlplus user/pass@SID works either way
sqlplus user/pass ONLY WORKS if ORACLE_HOME points to 8.1.7 instead of 8.1.7_64 enventhough they are the samedirectories from following the symb link.
cheers,
Henrique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 05:29 AM
тАО05-19-2003 05:29 AM
Re: weird problem when login in using sqlplus from non oracle unix account
BTW, the SIDNAME here on the env for this account, is THE SAME as the one which I am trying to login. Just made it generic.
AND, as you can see,when I change ORACLE_HOME, then, I CAN login fine without the
@SIDNAME string.
very weird indeed !!!
Henrique
PS.: This instance is patched up with 8.1.74 patch, but does not have the latest security patch.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 06:34 AM
тАО05-19-2003 06:34 AM
Re: weird problem when login in using sqlplus from non oracle unix account
See man pages for setprivgrp(1M), getprivgrp(2), privgrp(4)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 06:52 AM
тАО05-19-2003 06:52 AM
Re: weird problem when login in using sqlplus from non oracle unix account
THe problem is that setting up 8.1.7_64 for the oracle account, SHOWS the same problem.
It only worked there before, because the oracle account had the ORACLE_HOME pointing to the proper directory.
This is one of those things that will BOTHER ME until I find out why this is not working. It is a SYMBOLIC LINK to the same directory !!
Why is there a problem with THIS symbolic link ? :-(((
Thanks,
Henrique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 09:40 AM
тАО05-19-2003 09:40 AM
Re: weird problem when login in using sqlplus from non oracle unix account
chmod 4755 $ORACLE_HOME/bin/oracle
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 09:59 AM
тАО05-19-2003 09:59 AM
Re: weird problem when login in using sqlplus from non oracle unix account
thanks guys, BUT, BOTH accounts fail to work properly, when their ORACLE_HOME is set to
8.1.7_64 directory, which is symbolic link to 8.1.7 !!! SAME DIRECTORY, same files, same permissions ( btw, oracle executable is 4751 ).
I think I reinstalled oracle on this box and set the ORACLE_HOME to 8.1.7 the second time around. Not sure if any compiled code has 8.1.7 now instead of 8.1.7_64. However, it still does not explain why it fails if the name of the directory is something else or is a link !!!
ARE THERE ANY PROBLEMS WITH LINKS on hpux 11 and oracle 8.1.7 ? this simple makes no sense at all, but I can recreate the problem any time I want to !!
Henrique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 10:15 AM
тАО05-19-2003 10:15 AM
Re: weird problem when login in using sqlplus from non oracle unix account
Thats pretty stable, old technology.
Who made the symbolic link?
If root did it, this could be an issue.
Proper Oracle setup is to NOT allow root to fire up sqlplus. There are a lot of good reasons.
Do an ll on the symbolic link. If root owns it, delete it and recreate it using the oracle admin account.
If what I've said isn't the cause of the problem then its probably purely an environment problem. See prior posts. Envirnonment for oracle users should be consistent across user accounts.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com