Skip to main content

Generating public/private rsa key in Solaris

To set the auto authentication in ssh please follow the steps described below:


bash-3.00$ ssh-keygen -t rsa
Generating public/private rsa key pair.

Enter file in which to save the key (/home/oracle/.ssh/id_rsa):  <Press Enter>


Enter passphrase (empty for no passphrase):  <Press Enter>


Enter same passphrase again:  <Press Enter>

Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
22:55:d2:30:cb:5f:7b:eb:1e:ec:8e:72:48:cb:05:b6 oracle@DCDB01

bash-3.00$ pwd
/home/oracle

bash-3.00$ cd .ssh/
bash-3.00$ cat id_rsa.pub | ssh root@172.17.2.100 "cat - >> /.ssh/authorized_keys"

The authenticity of host '172.17.2.100 (172.17.2.100)' can't be established.
RSA key fingerprint is b5:3a:ce:a0:9f:44:18:ee:a0:33:a3:c6:ff:1a:b0:c3.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.17.2.100' (RSA) to the list of known hosts.

Password: 
< Provide password of remote host. i.e. 172.17.2.100 >

< Check That the authentication is working >

bash-3.00$ ssh root@172.17.2.100

Last login: Wed May  9 10:12:55 2012 from 172.17.2.101
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
You have new mail.
Sourcing //.profile-EIS.....


root@DCDB3 # 


< So, the connection was established>

Comments

Popular posts from this blog

Starting and Stopping the Oracle Enterprise Manager Console

Starting and Stopping the Oracle Enterprise Manager Console To access the Oracle Enterprise  Manager Console from a client browser, the  dbconsole  process needs to be running on the server. The dbconsole process is automatically started after installation. However, in the event of a system restart,change in IP, or other changes, you can start it manually at the command line. To start the  dbconsole  process from the command line: Navigate into your  ORACLE_HOME/bin  directory. Run the following statement: ./emctl start dbconsole Additionally, you can stop the process and view its status. To stop the  dbconsole  process:          ./emctl stop dbconsole To view the status of the  dbconsole  process:         ./emctl status dbconsole -------------------------------------------------------------------------------------------------------

Query to check the OPTIMAL UNDO RETENTION

Query to check the OPTIMAL UNDO RETENTION _____________________________________________________________________________ SELECT d.undo_size / (1024 * 1024) "ACTUAL UNDO SIZE [MByte]",        SUBSTR(e.value, 1, 25) "UNDO RETENTION [Sec]",        ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]"   FROM (SELECT SUM(a.bytes) undo_size           FROM v$datafile a, v$tablespace b, dba_tablespaces c          WHERE c.contents = 'UNDO'            AND c.STATUS = 'ONLINE'            AND b.name = c.tablespace_name            AND a.ts# = b.ts#) d,        v$parameter e,        v$parameter f,        (SELECT MAX(undoblks / ((end_time - begin_time) * 3600 * 24)) undo_block_per_sec  ...

Solution of problem: Resultset Exceeds the Maximum Size (100 MB)

Solution of problem: Resultset Exceeds the Maximum Size (100 MB) I was running a select statement in PL/SQL Developer. it was a short query but the data volume that the query was fetching was huge. But when ever i Click the button Fetch Last Page or press 'ALT+End' button a message box comes after a while saying: Then I started looking for the exact reason of this sort of problem in Google. When I realized there was no direct solution in the web, I started looking the PL/SQL Developer Software menu and found the ultimate solution. The reason of this problem is there is a parameter of maximum result set size in PL/SQL Developer Software which is by default set to 100 MB. To change this parameter you have to go to the following location: 1. Goto Edit Menu and click ' PL/SQL Beautifier Options '. A new window will open. 2. Click SQL Window of " Window Types ". 3. Now Change the value of "Maximum Result Set Size( 0 is unlimited)"  ...