mzh

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

Case Sensitive Passwords in Oracle Database   11g Case sensitive passwords (and auditing) are a default feature of newly created Oracle 11g databases. The Database Configuration Assistant (DBCA) allows you to revert these settings back to the pre-11g functionality during database creation. The SEC_CASE_SENSITIVE_LOGON initialization parameter gives control over case sensitive passwords. If existing applications struggle to authenticate against 11g, you can use the ALTER SYSTEM command to turn off this functionality. SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon       ...

Upgrading 10gR2 Database Instance to 11gR2 Database Instance STEP 1: Install The Software: First download and install oracle 11g R2. Execute runInstaller to install “SOFTWARE ONLY” option. NOTE: DO NOT SHUTDOWN DATABASE BEFORE RUNNING DBUA. STEP 2: Run Pre-Upgrade Information tool The software was installed under “/ultimus/oracle/product/11.2.0/db_1″ location. Once the software is installed, then go to location $ORACLE_HOME/rdbms/admin and copy  utlu112i.sql script to /tmp directory. Now login to 10g database “/ as sysdba” and startup the 10g database, then: SQL > spool /tmp/upgrade.spl SQL > @/tmp/utlu112i.sql SQL > spool off The output should look something like this: Oracle Database 11.2 Pre-Upgrade Information Tool    . ********************************************************************** Database: ********************************************************************** --> name:      ...

Loading Data from SQL Server to Oracle Database Using ODBC Connection Step 1: Creating an ODBC connection: n   To create an ODBC connections go to -> Control Panel -> Administrative Tools . n   Double Click on Data Sources (ODBC) . n   Choose System DSN tab. n   Click Add button. n   Choose SQL Server and click Finish button. n   Choose name of Connection and select server. n   Click Next> . n   Enter sa users password . n   Click Next > . n   Click “ Change the default database to:” option and select the database from which you want to fetch data to oracle. n   Click Next > , n   Click Test Data Source to test the connection. n   If successful the following the system will show some window like the following. n   Click ...

  “at” utility in unix is similar to the “cron” daemon except for that “at” jobs are run only once while cron jobs are recurring. “at” is primarily used to schedule a job which can be command or a script to run once at a particular time although it can be made to reschedule the job. This could be immediatly or at a later time. The at utility reads commands from standard input and groups them together as an at job, to be executed at a later time. How to Create an at Job: Start the at utility, specifying the time you want your job executed. $ at [-m] time [date]  "-m" Sends you email after the job is completed. time Specifies the hour that you want to schedule the job. Add am or pm if you do not specify the hours according to the 24-hour clock. Acceptable keywords are midnight , noon , and now . Minutes are optional. date Specifies the first three or more letters of a month, a day of the week, or the keywords today or tomorrow . At the  at prompt, type...

Profiles in Oracle Profiles are used to limit resources a user can use. Then, they can be assigned to users with alter user ... profile command. Limitable resources The following limits can be specified: Kernel limits: Maximum concurrent sessions for a user: (sessions_per_user) CPU time limit per session: (cpu_per_session) CPU time limit per call: (cpu_per_call) Call being parse, execute and fetch Maximum connect time: (connect_time) The session will be dropped by oracle after specified time. Maximum idle time (idle_time) The session will be dropped by oracle after specified time of doing nothing. Long running processes are not idle! Maximum blocks read per session: (logical_reads_per_session) Maximum blocks read per call: (logical_reads_per_call) Maximum amount of SGA: (private_sga) In order to enforce kernel limits, resource_limit must be set to true. Password limits: Maximum failed login attempts: (fa...

Finding Total Session Count: SELECT 'Currently, ' || (SELECT COUNT(*) FROM V$SESSION) || ' out of ' ||        VP.VALUE || ' connections are used.' AS USAGE_MESSAGE   FROM V$PARAMETER VP  WHERE VP.NAME = 'sessions'; To find sessions that are blocked or blocking other sessions, the one of the following queries: select t.process, t.sid, t.SERIAL#, t.blocking_session, t.USER#, t.USERNAME   from v$session t  where blocking_session is not null; select l1.sid, ' IS BLOCKING ', l2.sid   from v$lock l1, v$lock l2    where l1.block =1 and l2.request > 0   and l1.id1=l2.id1   and l1.id2=l2.id2;