Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Can 2 users own one file_system together?
Operating Systems Solaris Can 2 users own one file_system together? Post 302211871 by trantuananh24hg on Friday 4th of July 2008 11:58:49 PM
Old 07-05-2008
Oah! I knew the decrease one by one if I add the more user to one group.

Code:
$id -a 
uid=176(loyalty) gid=116(oinstall) groups=116(oinstall),115(dba)

But unfortunately, I am a newbie on Solaris when I can not execute any oracle application after this loyalty user was added.

Code:
$ ORACLE_HOME=/Billingoracle/oracle/product/10.2.0/NEF
$ export ORACLE_HOME
$ sqlplus /nolog
sqlplus: not found
$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:52:43 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL> exit
$ bash
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 05-JUL-2008 10:53:18

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:54:09 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/a0289@NEF as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> exit
bash-3.00$ ORACLE_SID=BILLING
bash-3.00$ export ORACLE_SID=BILLING
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:55:35 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/a0289@NEF as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> exit

bash-3.00$ su - oracle
Password:
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:56:05 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string     NEF
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ exit
bash-3.00$

I did not call sqlplus application from the Oracle_Home, although the Oracle_Home and Oracle_SID was exported right now.

Would you tell me why?

Thank you very much!
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

no of users

Is there any way to find the number of unique users in a system other than who | cut -d" " -f1 | sort -u | wc -l ? (3 Replies)
Discussion started by: asutoshch
3 Replies

2. Solaris

do i need these users?

uucp:x:5:5:uucp Admin:/usr/lib/uucp: nuucp:x:9:9:uucp Admin:/var/spool/uucppublic:/usr/lib/uucp/uucico smmsp:x:25:25:SendMail Message Submission Program:/: listen:x:37:4:Network Admin:/usr/net/nls: nobody:x:60001:60001:Nobody:/: noaccess:x:60002:60002:No Access User:/:... (3 Replies)
Discussion started by: csaunders
3 Replies

3. HP-UX

Users

Is there a command to tell what applications certain users ran in past few months? And thier last login? This is on HPUX machine Thanks! (1 Reply)
Discussion started by: catwomen
1 Replies

4. HP-UX

Limiting SFTP Users While Not Limiting Regular Users?

Hi, I have searched the web and have come back with nothing that is satisfactory for what I require. SFTP is my corporations new file transfer standard. What I require is a method to lock down SFTP users to their directory (they may go to sub directories) while not restricting regular users. ... (2 Replies)
Discussion started by: Emancipator
2 Replies

5. Solaris

To restrict the users not to change the passwords for NIS users

Hi All, How to restrict the NIS users not to change their passwords in for NIS users?? and my NIS user is unable to login to at client location what could be the problem for this ? Any body can help me. Thanks in advance. (1 Reply)
Discussion started by: Sharath Kumar
1 Replies

6. Red Hat

Showing all users in 'users' and 'top' commands

Hi All, I work in a multi user environment where my school uses Red Hat Linux server. When I issue commands such as "top" or "users", I get to see what others are doing and what kinds of applications they are running (even ps -aux will give such information). "users" will let me know who else is... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

7. Red Hat

users cannot switch with "su" to another users

Hi, i have a problem, itīs because users without belonging wheel group cannot switch to another user , when the password is introduced says not right password. The only solution for now is to add them to wheel users, but then i have another problem, they can login as root. Is there any... (3 Replies)
Discussion started by: pabloli150
3 Replies

8. Shell Programming and Scripting

Create multiple users with individual passwords to users

hi, i am new to shell scripts i write a shell script to create multiple users but i need to give passwords to that users while creating users, command to write this script (1 Reply)
Discussion started by: DONFOX
1 Replies

LEARN ABOUT DEBIAN

sql::reservedwords

SQL::ReservedWords(3pm) 				User Contributed Perl Documentation				   SQL::ReservedWords(3pm)

NAME

       SQL::ReservedWords - Reserved SQL words by ANSI/ISO

SYNOPSIS

	  if ( SQL::ReservedWords->is_reserved( $word ) ) {
	      print "$word is a reserved SQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by ANSI/ISO SQL standard.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003".

       is_reserved_by_sql1992( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:1992".

       is_reserved_by_sql1999( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:1999".

       is_reserved_by_sql2003( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:2003".

       reserved_by( $word )
	   Returns a list with SQL standards that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_sql1992
       is_reserved_by_sql1999
       is_reserved_by_sql2003
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords::DB2

       SQL::ReservedWords::MySQL

       SQL::ReservedWords::ODBC

       SQL::ReservedWords::Oracle

       SQL::ReservedWords::PostgreSQL

       SQL::ReservedWords::SQLite

       SQL::ReservedWords::SQLServer

       ISO/IEC 9075:1992 Database languages -- SQL

       ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)

       ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28						   SQL::ReservedWords(3pm)
All times are GMT -4. The time now is 01:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy