topic Re: user name in Operating System - HP-UX

user name

francisco a. buenviaje — Wed, 25 Sep 2002 06:27:44 GMT

hi! i need some help,
i have created a new username thru SAM in replacement of the old one, with the different username, but with the same userid, group id and i even set same default folder. the problem
is, i encountered error while running programs specially programs which establish connection to our oracle. what seems to be the problem?

i'm giving 8 points on this.

thanks a lot

Re: user name

Donald Kok — Wed, 25 Sep 2002 06:33:32 GMT

I get the same with my ingres database. The database keeps also a userdatabase. Man should adjust this as well as the unix userdatabase. I think oracle does the same.

Re: user name

Keely Jackson — Wed, 25 Sep 2002 06:34:27 GMT

Is it using the same default shell? Was the path modified in the old users .profile?

Do the any of the programs you are running depend upon a specific user name in their code? Check it is not hard coded in a script. Also were there any scripts in the old users home directory that are now not there?

Cheers
Keely

ps you should award points depending on whether it answers your question or not.

Re: user name

Telia BackOffice — Wed, 25 Sep 2002 06:38:02 GMT

The dir you choose as user directory will change permissions to the new usr (i it is specified), and all sub directories.
Why not just make a new user connected to the same group.

BR,
Jannik

Re: user name

KapilRaj — Wed, 25 Sep 2002 06:43:49 GMT

Our procedure goes like this,

-- Create the UNIX id
-- Provide the database access

So u did miss the second part & there goes the solution

kaps

Re: user name

Christian Gebhardt — Wed, 25 Sep 2002 07:11:30 GMT

In an Oracle-DB you can have a lot of restrictions to specific OSUSER.
So what are the exact errormessages, are there any ORA-... errors ??

Christian

Re: user name

Clemens van Everdingen — Wed, 25 Sep 2002 07:23:36 GMT

Hi,

depending on the error, but: I guess you have to grant access to the oracle database for the new user.

C.

Re: user name

francisco a. buenviaje — Wed, 25 Sep 2002 07:39:45 GMT

if i'm not mistaken, we've also created the new username and grant resource and access on oracle dbase before we run the job, i also tried creating new user with the same group but still
no luck.

thanks

Re: user name

Clemens van Everdingen — Wed, 25 Sep 2002 07:43:16 GMT

Hi,

As Christian also asked !!!
What error message do you get ??
Any ORA messages.
On system level: any syslog messages ?
Any error log files ?

It is difficult to troubleshoot just mentioning the word error !

C.

Re: user name

francisco a. buenviaje — Wed, 25 Sep 2002 07:54:54 GMT

DBIODIST:(A000) F1-ERRM
F1-ERRL 0000 F1-TABLE IN
here is the error message

DBIODIST:(A000) F2-STAT ER F2-FUNCT READ F2-SQLCD 000001012-

DBIODIST:(A000) F2-ERRM ORA-01012: not logged on
F2-ERRL 0025 F2-TABLE IN

DBIODIST:(A000) F1-STAT F1-FUNCT F1-SQLCD 000000000

DBIODIST:(A000) F1-ERRM
F1-ERRL 0000 F1-TABLE IN
DBIODIST:(A000) F2-STAT ER F2-FUNCT READ F2-SQLCD 000001012-

DBIODIST:(A000) F2-ERRM ORA-01012: not logged on
F2-ERRL 0025 F2-TABLE IN

Re: user name

Clemens van Everdingen — Wed, 25 Sep 2002 08:04:47 GMT

Hi,

Checked a bit around and found in the knowledge base the following to try:

You are getting this error because there is a problem with the NLS_LANG
environment variable. This variable is usually set in the oracle user's
$HOME/.profile file.

Perform the following steps to resolve your error:

1. Set NLS_LANG to the following value:

NLS_LANG=american_america.WE8ISO8859P1

2. Exit.

3. Log back on as the Oracle user

C.

Re: user name

Clemens van Everdingen — Wed, 25 Sep 2002 10:49:04 GMT

Hi,

Problem solved ?
If yes why no rabit ?

C.

Re: user name

francisco a. buenviaje_1 — Thu, 26 Sep 2002 04:45:10 GMT

hi guys! thanks for the help specially to C.,
problem was solved, sory for the rabbit, this is my 2nd time to login to itrc and im not so familiar with the facility, and also my login accout was declined, i dont know why so i have to create a new one just to login.

again, thanks a lot, you're all a big help

francis