The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Special Forums > UNIX and Linux Applications
Google UNIX.COM
Home Forums Register Rules & FAQ Members List Arcade Search Today's Posts Mark Forums Read


UNIX and Linux Applications Questions involving software not covered by other forum go here. This includes Databases and Middleware.


Other UNIX.COM Threads 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 3 Weeks Ago 10:06 AM
Oracle database connection pools setting skully Oracle Updates (RSS) 0 4 Weeks Ago 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

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-21-2007
Registered User
 

Join Date: Nov 2005
Posts: 127
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
oracle user and group setting

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.
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 02-26-2008
Registered User
 

Join Date: Feb 2008
Location: Fairfax VA
Posts: 9
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
Connect to DB issue

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?
Reply With Quote
Google UNIX.COM
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -7. The time now is 09:31 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger

Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102