Oracle Webinars Coming Up In August 2013

Oracle Webinars Coming Up

Aug. 29: Oracle 12c RAC Upgrade Syed Jaffar Hussain (Oracle ACE Director) explains how to upgrade a 2 node 11gR2 clusterware and database to Oracle 12c. Register now (Limited spaces).

Sept. 10: How to Enable Risk-Free Database Experiments Kyle Hailey (Oracle ACE, OakTable) looks at different types of cloning technology and demonstrates how to setup risk-free database experiments. Register now(Limited spaces).

Last webinar: Performance is a Feature: Here is the Spec. Cary Millsap (Oracle ACE Director, OakTable) explains why great performance at scale doesn't happen by accident and how performance should be measured.Watch video.

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

How to unlock the user oracle (ORA-28000)

How to unlock the user
How to unlock the user in oracle, or how to solve ORA-28000



SQL> conn sqlplus AS sysdba
Enter password:
Connected.

SQL> ALTER USER username   2    ACCOUNT UNLOCK;

example:

SQL> conn sqlplus as sysdba
Enter password:
Connected.
SQL> alter user scott
  2  account unlock;

User altered.

SQL> conn  scott/tiger
ERROR:
ORA-28001: the password has expired


Changing password for scott
New password:
Retype new password:
Password changed
Connected.





Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

COMING SOON for ORACLE DBA , LINUX , and News

COMING SOOON

 

 

Download and Installation of Oracle VM Virtual machine

 Step by step with snap shot 

Download and Installation of Oracle VM Virtual machine in windows 

Here we will see, from where we can download the oracle Vm virtual machine and how install it .

1. Prerequisites

2.Download location

3. Installation .

1. Prerequisites

               i) Memory (RAM) 2 GB

               ii)Hared Disk space 8GB

2. Download Location 

                http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html

this is the location where you will get the oracle VM

from here you can select your platform where you need to install oracle vm

3. Installation 

                after download you will get this file

•  Double click on the setup file.

image "a"

•  I am installing in "windows7" so i am getting image "a" else you will directly reach to next step

image "b"

•  Click on "next"

image "c"

• Select the option according to your choice. it will not effect on installation. 

image "d"

• Installation started  

image "e"

• Click on "finish" and your installation is complete. 

image "f"

"Image F" sis showing the Oracle VM virtual box.

• You can download this in PDF format  form below link

              "http://chetanyadavds.blogspot.in/p/documentation.html"

Or

• You can watch this on video on

               "http://chetanyadavds.blogspot.in/p/videos.html"

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

tns error

ORA-12154 : "TNS:could not resolve  service name"

Cause : oracle Net Services cannot locate the connect descriptor specified in the  tnsnames.ora configuration .

>> verify the tnsnames.ora files exists and that accessible .
>>verify that tnsnames.ora file in the location by the TNS_ADMIN environment variable.

ORA-12198: "TNS: could not find  path to destination  "
ORA-12203: "TNS: unable to connect the destination "

>> verify that you have correctly enter the service name of the database that you  want to connect.
>> verify that service name address ADDRESS parameter in the connect descriptor of your  tnsname.ora file are correct .
>> verify that you tnsname.ora  file stored in the directory defined in the TNS_ADMIN environment Variable

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

tnsnames.ora

sample tnsnames.ora

---------------------------------------------------------------------------------------------------

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = xp)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

---------------------------------------------------------------------------------------------------



here my DB name is "ORCL"
host is "XP"

The tnsnames.ora file is used to store the net services names. The deafault location is %ORACLE_HOME\network\admin on windows and $ORACLE_HOME/netwrok/admin/on UNIX.

any mistake is there or u wanna give any suggestion so please write to me ............

Configuring Network settings on Oracle VM

any mistake is there or u wanna give any suggestion so please write to me ............