06-25-2002
Dear Kelam_Magnus,
Thank you for your information.
The problem has been solved by resetting the permissions on the users login shell files i.e., /usr/bin/ksh, /u95/bin/share/ksh and /var/adm/shserv .
it was a great experince for me. i did the follwoing.
1. after ORACLE DATABASE crash, I logged in as ORACLE user and type the SVRMGRL , connected to the oracel internal and shutdown the database (this is the way we startup and shutdown the database through SVRMGR).
2. Took the backup (cold backup) of existing database files using shell script. In the shell script i have change mode command (chmod) to set some permissions. (This created the problem).
3. I restarted the PC , then i could not login as any except root.
su - login_name also did not work. I checked the home directories, /etc/passwd files, /etc/profiles, users .profiles, users previlages everything seems alright.
4. Today when i try to login from the remote machine it displayed can not exec /var/adm/shserv permission denied.
5. Started giving the permissions and later on it displaed no shell.
6. Reset the permissions for korn shell (ksh) including link files also. Root is working because for roor login shell is /sbin/sh. for this permissions are absolutely fine.
7. Finally i could loging as ORACLE and restored the backup and restarted the DATABASE today itself..now i am relax..
thank you for ur info once again..
hope we will meet again if any ...
10 More Discussions You Might Find Interesting
1. HP-UX
Hi All,
I m facing a problem that, i m not able to login as root user on cde on hp-ux 11.00, i can login as root on commond line as well as telnet. Thanks in Advance for help.
Regards,
Awadhesh (1 Reply)
Discussion started by: Awadhesh
1 Replies
2. UNIX for Dummies Questions & Answers
How to give an ordinary user the superuser (root) ID which is 0 (9 Replies)
Discussion started by: sharaola
9 Replies
3. Solaris
Hi to All,
I have configured telnet service in my server but am not able to login with root user in Linux Servers.
For that what can i do ?
Please help me
Thanks in Advance. (1 Reply)
Discussion started by: Sharath Kumar
1 Replies
4. Solaris
I am running 5.10 Generic_120011-14
Sunblade 1500
I have one client that was working fine in a training environment. Then this week the user is unable to login as the user that is created by default. The students do not have access to root to change system files or user accounts. This is... (11 Replies)
Discussion started by: deaconf19
11 Replies
5. Debian
hello friends,
one user is created named "user1"
I login as "user1" . Now when i do "su -" to be root user I have to give password for root .
Is there any way through which we can skip giving the password to root.
i.e.
user1@work:~$ su -
Password: xxxxxx
work:~$
I don't want that... (1 Reply)
Discussion started by: pradeepreddy
1 Replies
6. UNIX for Dummies Questions & Answers
Hi folks.
our developer had a root user and he changed some settings about root user. We have not known what he changed.
There is an oracle user, we can login to oracle, no problem. But when we try to login to root user we are getting this error :
$ su root
Password:
bash:... (9 Replies)
Discussion started by: futi
9 Replies
7. Solaris
Hi!
Can someone please tell me how to log-in to Solaris as a superuser or as a root?
I have tried using "root" as a username, and my superuser password i had set in the terminal for the log-in password but it says "Roles can only be assumed by authorized users". "Permission denied."
I'm... (1 Reply)
Discussion started by: CarlosP
1 Replies
8. Shell Programming and Scripting
hello all,
if we haven't set a password to root user, how can we login as root user in konsole by using su? is it necessary to set password for root to login as root user?how can we set password to root user? (6 Replies)
Discussion started by: aarathy
6 Replies
9. Shell Programming and Scripting
Hi Every body,
I would need a shell script program to login as different user and perform some copy commands in the script.
example: Supppose ora_toms is the active user
ora_toms should be able to run a script where user: ftptomsp pass: XXX should login through and run the commands
... (9 Replies)
Discussion started by: ujjwal27
9 Replies
10. UNIX for Advanced & Expert Users
Anyone has met the error following:-
1. Only root could login Redhat
2. Trying su another user by root, the error will be
su: warning: cannot change directory to /home/user: permission denied
su: /bin/bash: permission denied
3. I have checked the permission of the folder given and even... (2 Replies)
Discussion started by: jc0616
2 Replies
LEARN ABOUT REDHAT
alter_database
ALTER
DATABASE(7) SQL Commands ALTER DATABASE(7)
NAME
ALTER DATABASE - change a database
SYNOPSIS
ALTER DATABASE name SET variable { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET variable
DESCRIPTION
ALTER DATABASE is used to change the session default of a run-time configuration variable for a PostgreSQL database. Whenever a new session
is subsequently started in that database, the specified value becomes the session default value. The database-specific default overrides
whatever setting is present in postgresql.conf or has been received from the postmaster.
Only a superuser or the database owner can change the session defaults for a database.
PARAMETERS
name The name of the database whose session defaults are to be altered.
variable
value Set the session default for this database of the specified configuration variable to the given value. If value is DEFAULT or, equiv-
alently, RESET is used, the database-specific variable setting is removed and the system-wide default setting will be inherited in
new sessions. Use RESET ALL to clear all settings.
See SET [set(7)] and the Administrator's Guide for more information about allowed variable names and values.
DIAGNOSTICS
ALTER DATABASE
Message returned if the alteration was successful.
ERROR: database "dbname" does not exist
Error message returned if the specified database is not known to the system.
NOTES
Using ALTER USER [alter_user(7)], it is also possible to tie a session default to a specific user rather than a database. User-specific
settings override database-specific ones if there is a conflict.
EXAMPLES
To disable index scans by default in the database test:
ALTER DATABASE test SET enable_indexscan TO off;
COMPATIBILITY
The ALTER DATABASE statement is a PostgreSQL extension.
SEE ALSO
ALTER USER [alter_user(7)], CREATE DATABASE [create_database(l)], DROP DATABASE [drop_database(l)], SET [set(l)]
SQL - Language Statements 2002-11-22 ALTER DATABASE(7)