This has been covered in many places, so this will be a short version. This is not using the insecure r?? commands with .rhosts.
Assume both machines have the same or similar ssh installation.
"hosthere" is where you are logged on. "hostfar" is where you want to log on.
Use an empty passphrase and default key location.
hosthere $ ssh-keygen -t dsa
Place "pub" file on hostfar in ~/.ssh as "authorized_keys2".
hosthere $ scp id_dsa.pub hostfar:.ssh/authorized_keys2
Now ssh and scp to "hostfar" should not prompt for a password.
Troubleshooting includes checking permissions of .ssh directory and files.
Sunday, May 14, 2006
Tuesday, May 09, 2006
Oracle Profile Limit Not Working
It can be useful to set a high CPU usage limit to stop runaway queries. "High" is application-specific, so set the limit as appropriate.
When the limit is reached, the session will be killed with the message, "ORA-02393: exceeded call limit on CPU usage".
If the limit does not work, verify the resource_limit parameter is set to true.
prompt -- Set pfile for: resource_limit=true
alter system set resource_limit=true scope=both;
drop profile profile_example
/
CREATE PROFILE profile_example
LIMIT CPU_PER_SESSION UNLIMITED CPU_PER_CALL 120000
CONNECT_TIME UNLIMITED IDLE_TIME UNLIMITED SESSIONS_PER_USER
UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED PRIVATE_SGA UNLIMITED
COMPOSITE_LIMIT UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED PASSWORD_VERIFY_FUNCTION NULL
/
alter user limt_me profile profile_example
/
When the limit is reached, the session will be killed with the message, "ORA-02393: exceeded call limit on CPU usage".
If the limit does not work, verify the resource_limit parameter is set to true.
prompt -- Set pfile for: resource_limit=true
alter system set resource_limit=true scope=both;
drop profile profile_example
/
CREATE PROFILE profile_example
LIMIT CPU_PER_SESSION UNLIMITED CPU_PER_CALL 120000
CONNECT_TIME UNLIMITED IDLE_TIME UNLIMITED SESSIONS_PER_USER
UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED PRIVATE_SGA UNLIMITED
COMPOSITE_LIMIT UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED PASSWORD_VERIFY_FUNCTION NULL
/
alter user limt_me profile profile_example
/
Subscribe to:
Posts (Atom)