Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sun and oracle accounts
you say that you su to proto. is that su or su - (minus).
do an env in both working and non working accounts and compare the environment variables.
it would seem to me that you do not have the required oracle environment set up in the proto login.
Phil West
Unix Sys Admin and Oracle Financials DBA
+44 (0) 20 7623 5222 x5221
-----Original Message-----
From: Steff Gonos [mailto:steff_gonos_at_yahoo.com]
Sent: 16 August 2000 18:05
To: Multiple recipients of list ORACLE-L
Subject: sun and oracle accounts
In light of the topics about SA I am have a problem that maybe you all can shed some light on.
I am running Solaris 7 and Oracle 8.1.5. Many months back I created an Oracle account under both the Sun system and Oracle. I also created an id called PROTO with the same permissions. They worked.
Now, after some time, PROTO is hosed. Here is what is happening. When I log on the Sun box directly using ORACLE and then login to oracle using that ID all is good. If I stay on the sun box as Oracle, then switch to PROTO to get to the database, all is good.
If I logout of the Sunbox and come in as PROTO, I get in to the OS, if I try to use PROTO to login to oracle, I get all the standard, TNS names, Oracle not available messages (I try various combinations of login/password and instance, instance.world..... which will change the error messages I am getting.
This tells me that when I come in as PROTO something is wrong, yet using the Oracle ID, and then switching to PROTO is ok. I have tried to check the paths and copied and recopied the shells to ensure that they are the same. I am running C-shell by the way.
Can anyone more knowledgable in Solaris point me where else
to look? I've even created a new id, copying the .cshrc
and .login files to the new id, from the ORACLE working
one,
and still get the same problems.
Thanks a lot.
Steff Gonos
TASC - Litton.
Steff Gonos
steff_gonos_at_yahoo.com
-- Author: Steff Gonos INET: steff_gonos_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Aug 17 2000 - 06:08:16 CDT
*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients. Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.