This week I had fun with Oracle realm … I never though that it would be so much pain stepping out of MS world.. where everything happens at click of button… But any ways I though I would share few things so someone else can be benefitted.<\/p>\n
I will share my story of using SQL Developer …. For those who don’t know … What is SQL Develop… then consider it as\u00a0SSMS (SQL Server Management Studio)\u00a0\u00a0for Oracle \ud83d\ude42\u00a0 … You can write queries.. and perform some basic Admin Operations such as Create\/Drop\/Modify Users<\/p>\n
<\/p>\n
Once you Install Oracle Client tools you may see SQL Developer installed somewhere under your Oracle Home path<\/p>\n
C:\\Oracle\\product\\11.2.0\\dbhome_1\\sqldeveloper\\sqldeveloper\\bin\\sqldeveloper.exe<\/p>\n
When you try to launch this eve you may be prompted to browse JAVA.exe and I tried default things but didn’t work… and then I realized .. I needed JDK (x86 version)… So make sure you get 32-bit version of JDK v 1.6<\/strong> (You can get Higher version but they said it may not be supported .. But I guess it worked for me)<\/p>\n Once I downloaded JDK and Installed it… Make sure you “Run As Admin”<\/strong> for first time .. so Java.exe Path is Set in Config file for SQL Developer<\/p>\n If you are running on fresh machine you may need Visual C++ 2010 Runtime<\/strong> .. otherwise you may get MSVCRT100.dll is missing<\/strong> when you run SQL Developer.<\/p>\n Finally once everything is setup and good to go you can launch SQL Developer.<\/p>\n If it ever happens to you when you don’t know whats the password for SYS or SYSTSM then try below command … assuming you are Windows Admin.. and part of sysdba group (I think oracle automatically adds person who installs product under sysdba group… its like SUPER user)<\/p>\n 1. Open command prompt and type\u00a0 sqlplus \/nolog<\/p>\n 2. once you see SQL> prompt type connect \/ as sysdba<\/p>\n 3. once you connected.. type\u00a0 …. ALTER USER someusername IDENTIFIED BY somenewpassword;<\/p>\n If you see account locked error for some reason … e.g. tryimg default SCOTT account with password TIGER may give you error… Account is locked… then try below command<\/p>\n SQL>ALTER USER someusername\u00a0ACCOUNT UNLOCK;<\/p>\n That’s it for today …<\/p>\n Happy Coding!!!<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" This week I had fun with Oracle realm … I never though that it would be so much pain stepping out of MS world.. where everything happens at click of button… But any ways I though I would share few …<\/p>\nDon’t remember SYS or SYSTEM password ?<\/h2>\n
Account LOCKED ?<\/h2>\n