user name

[francisco a. buenviaje]

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

[Donald Kok]

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.

[Keely Jackson]

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.

[Telia BackOffice]

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

[KapilRaj]

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

[Christian Gebhardt]

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

[Clemens van Everdingen]

Hi,

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

C.

[francisco a. buenviaje]

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

[Clemens van Everdingen]

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.

[francisco a. buenviaje]

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

[Clemens van Everdingen]

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.

[Clemens van Everdingen]

Hi,

Problem solved ?
If yes why no rabit ?

C.

[francisco a. buenviaje_1]

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