06-21-2007
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.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
if i set Oracle home in the command line as
export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by
typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was... (3 Replies)
Discussion started by: DILEEP410
3 Replies
2. Shell Programming and Scripting
I need to find all the files that have group Read or Write permission or files that have user write permission.
This is what I have so far:
find . -exec ls -l {} \; | awk '/-...rw..w./ {print $1 " " $3 " " $4 " " $9}'
It shows me all files where group read = true, group write = true... (5 Replies)
Discussion started by: shunter63
5 Replies
3. Cybersecurity
Under oracle user file abc.txt was created. Oracle user belong to dba group on UNIX Server. However other non Oracle users which belongs to some other network groups need read only access to this file.
Every time when I login as other then oracle user and try to view this file it saying that I... (2 Replies)
Discussion started by: groosha
2 Replies
4. UNIX for Advanced & Expert Users
What would be a practical way of making sure files I upload to/edit in a particular directory on a server always have the correct group permissions?
I'm forgetful, so I try to automate things like chgrp'ing the files when I'm done. I could write a script to be run by cron. Is that the only way,... (2 Replies)
Discussion started by: mregine
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
As root, I want to create a directory and set the group and ownership permissions at the same time with one command, instead of making the directory, then going back and doing a chown and chgrp.
I don't see an option for this in the mkdir man page. Would I pipe chown and chgrp with my... (1 Reply)
Discussion started by: moose123
1 Replies
6. Shell Programming and Scripting
Please help me with commands for the following file operations
File description
5 columns in total , sorted by column 1 value
First formatting,
1) Records with duplicate column 1 values are to be ignored. Just consider the first occurrence of such a record.
2) Records with (column 2 -... (3 Replies)
Discussion started by: newbie83
3 Replies
7. Shell Programming and Scripting
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies
8. Red Hat
Hi,
In the following output you can see the the user "richard" is a member on the team/group "developers":
# id richard
uid=10247(richard) gid=100361(developers) groups=100361(developers),10053(testers)
but in the following details of the said group (developers), the said user... (3 Replies)
Discussion started by: indiansoil
3 Replies
9. Solaris
Trying to figure out the best method of security for oracle user accounts. In Solaris 10 they are set as regular users but have nologin set forcing the dev's to login as themselves and then su to the oracle users.
In Solaris11 we have the option of making it a role because RBAC is enabled but... (1 Reply)
Discussion started by: os2mac
1 Replies
10. UNIX for Beginners Questions & Answers
Hello friends
alter system set global_names = true scope = spfile;
------ Post updated at 11:53 AM ------
application level error is below (1 Reply)
Discussion started by: ded325
1 Replies
LEARN ABOUT DEBIAN
make-sqldeveloper-package
MAKE-SQLDEVELOPER-PACKAGE(1) Oracle SQL Developer Debian package builder MAKE-SQLDEVELOPER-PACKAGE(1)
NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder
SYNOPSIS
make-sqldeveloper-package [options] <file>
DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.
The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
when downloading the source.
This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet-
work/developer-tools/sql-developer/> to create the Debian package from.
OPTIONS
-b|--build-dir <dir>
base directory to build package (autogenerated)
-e|--email <email>
local maintainer email (use DEBEMAIL or auto-generate)
-i|--install
install the generated package - needs root privilege (no)
-k|--keep-dir
keep the build directory (no)
-l|--revision <number>
local revision to append to package version (1)
-m|--maintainer <name>
local maintainer name (use DEBFULLNAME or leave empty)
-r|--root-command <command>
command to gain root privilege for package build (fakeroot)
-u|--upstream-version <version>
force the upstream version (autodetected)
-h|--help
display the help screen
-v|--version
show the program version
<file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>
AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.
This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).
GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)