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.
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)
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)
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)
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)
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)
