oracle user and group setting - UNIX and Linux Applications

duke0001 · #1 (**permalink**) 06-21-2007

I am seeking help on this issue.

When I installed Oracle 10g on Solaris 9 sparc box, I created user oracle and assigned oracle user to primary group Oinstall and second group dba. Then installation went successful. After that, I created another user ccmm and assigned ccmm to dba group. Then I created some UNIX scripts and SQL scripts stored on system. When I log into server as ccmm user and tried to connect to Oracle database, it failed. If I log in as oracle user and tried to connect to Oracle database, everything runs fine. My purpose is to log in as ccmm user and connect to Oracle database or start Oracle utilities from there. So where is the problem for ccmm user settings? How can I make ccmm user as Oracle database user on UNIX machine? Thanks in advance.

olenkline · #2 (**permalink**) 02-26-2008

Make sure the environment is correct, that either oracle_sid , only if this user is on the same box, or TWO_TASK is set, as well as ORACLE_HOME and the path statement is correct.

What error are you getting?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how can i add a user to a group	arunkumar_mca	UNIX for Dummies Questions & Answers	4	06-15-2008 10:06 AM
Oracle database connection pools setting	skully	Oracle Updates (RSS)	0	06-02-2008 12:04 AM
setting Oracle Home	DILEEP410	Shell Programming and Scripting	3	12-14-2006 04:15 AM
user/group	sdharmap	UNIX for Dummies Questions & Answers	2	03-08-2002 07:46 AM
User Group	errolg	UNIX for Dummies Questions & Answers	1	01-03-2002 06:50 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode