Quest

How to disable FIPS

2012-02-02T12:40:00.002-05:00

When you set up a new web application on Windows 2008 server, I get FIPS error.

You can disable FIPS on registry, go the following path and set Enabled = 0

HKLM\System\CurrentControlSet\Control\Lsa\FIPSAlgorithmPolicy

Flex: Cannot upload larger files

2011-12-20T08:47:00.001-05:00

I had a very strange problem with my file upload in flex. While it was working for smaller files, it threw weird errors for large files ( files greater than 30MB or so)

I got "Error #2038: File I/O Error." some times, and then "SecurityError: Error #2000: No active security context." error.

After some wild google chase, figured out that the problem was coming from IIS Server and Flex is not reporting the error correctly.

By default, IIS rejects files larger than 4MB or so, In order to fix this I used to add the following.

<system.web>

</system.web>

but for IIS 6 or IIS 7, You also need a new section to allow large file uploads (100MB in my case)

<system.webServer>

</requestFiltering>

</security>

</system.webServer>

and this fixed it.

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]

2011-12-19T13:52:00.001-05:00

Launch SQL Plus from Oracle\bin folder ( not from Client folder)

SQL> conn sys/sys as sysdba
Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Database mounted.

SQL> recover database;
Media recovery complete.

SQL> alter database open;
Database altered.

SQL> conn scott/tiger@orcldb
Connected.

Your database is good to go now, You better take a backup of your system.

Plex Media Server: Unable to connect

2011-12-17T22:24:00.001-05:00

Installed Plex Media server on Windows 7 Ultimate, and I always got unable to connect to localhost.

To fix, I just replaced Localhost in the URL with the IP Address as shown below, and it started working

So, I changed URL from

http://localhost:32400/manage

to

http://127.0.1:32400/manage

ORA-12560: TNS:protocol adapter error

2011-12-15T15:23:00.000-05:00

ORA-12560: TNS:protocol adapter error

You get this error when the listeners port numbers dont match.

You have a port number (1521) specified in tnsnames.ora, There should be a correspondng listener running on the same port on the target database server. If the listener on the target database server is running on a different port, then you get this error.

ORA-12541: TNS:no listener

2011-12-15T15:12:00.004-05:00

OK, Almost every body who have worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12541: TNS:no listener" mean ?

This means, TNS Listener server is down on the target database server. Check if the listener is up and running.

If your database is running on a windows box, go to services on the database server and check the service is running.

ORA-12545: Connect failed because target host or object does not exist

2011-12-15T14:51:00.001-05:00

OK, Almost everbody who has worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12545: Connect failed because target host or object does not exist" mean ?

Say from SQLPlus, you are issuing the following command

SQL> Conn scott/tiger@orcldb;

SO, SQLPlus, looks for the entry "orcldb" in your client tnsnames.ora file.

In tnsnames.ora, you will find an entry something similar to this

orcldb=
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <db_machine_name or ip address>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db_name)
    )
)

so "ORA-12545: Connect failed because target host or object does not exist" means, either your db_machine_name/ip address is incorrect or your machine cannot connect to db_machinge_name/ip_address
for various reasons like network issues etc

ORA-12154: TNS:could not resolve the connect identifier specified

2011-12-15T14:45:00.002-05:00

OK, Almost everbody who has worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12154: TNS:could not resolve the connect identifier specified" mean ?

Say from SQLPlus, you are issuing the following command

SQL> Conn scott/tiger@orcldb;

SO, SQLPlus, looks for the entry "orcldb" in your client tnsnames.ora file.

If it cannot find orcldb in tnsnames.ora, then you get ORA-12154: TNS:could not resolve the connect identifier specified

Fix your tnsnames.ora, and you should be fine.

ORA-12638: Credential retrieval failed

2011-12-01T16:15:00.001-05:00

Toad threw this error today, but I was able to connect to the database using SqlPlus.

The problem is coming from your sqlnet.ora

Check if your SQLNET.AUTHENTICATION_SERVICES. It should be set to NONE instead of NTS

Old entry
SQLNET.AUTHENTICATION_SERVICES= (NTS)

Correct Entry
SQLNET.AUTHENTICATION_SERVICES= (NONE)

Flex: Disable button in Togglebuttonbar

2011-11-14T14:51:00.001-05:00

say, you defined your toggle button bar as below

<mx:ToggleButtonBar id="tbbModule" itemClick="tbbModule_Click(event)">
        <mx:Array>
        <mx:String>Home</mx:String>
        <mx:String>Module 1</mx:String>
        <mx:String>Module 2</mx:String>
        </mx:Array>
    </mx:ToggleButtonBar>

If you want to disable the first button, then

mx.controls.Button(tbbModule.getChildAt(0)).enabled =false;

Oracle: Regular expression to extract text from rtf string

2011-08-03T10:20:00.003-04:00

After few trial and errors, figured out a way to extract text from rtf string format.

with rtf as ( select
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}{\f1\fswiss\fcharset0 Arial;}{\f2\froman\fcharset0 Times New Roman;}}
{\colortbl ;\red0\green0\blue255;}
\viewkind4\uc1\pard\lang1033\f0\fs17 This is first line of rtf string with 01/02/1950 and some $10.20 with +ive sign
\par
\par e-mail second line rtf@rtf.com
\par \pard\sb100\sa100\cf1\lang1036\f1\fs24 Yes, Third line of rtf. \cf0\f2
\par \f1\fs20 some text \f2\fs24
\par \f1\fs20 123 456 abc 7890\f2\fs24
\par \pard\lang1033\f0\fs17
\par }' str from dual)
select str, regexp_replace(str, '({\\)(.*)(})|(\\[^ ]*)|(})') from rtf;

Here is the break down of Regular expression. It has 3 parts
({\\)(.*)(}) | (\\[^ ]*) | (})

Replace

1) Anything that starts with {\ followed by any any character(s) and ends with }

2) Any thing that starts with \ and not followed by a space

3) Replace the last }

Flex: Workspace in use or cannot be created

2011-07-22T09:49:00.000-04:00

I have seen this annoying message more often in Flex Builder 3. It looks like the locks are not properly released when you quit Flex Builder.

If you get this error, You have 2 options

Option 1

Go to Task Manager
Kill FlexBuilder.exe
Kill Javaaw.exe

Option 2
Restart your pc

Either option will resolve this for you.

Data pump: Import multiple dump files

2011-07-21T10:48:00.000-04:00

If the size of the dump file is large, usually they will be split into smaller chunks for easier ftp upload/download.

If you are trying to import a dump file that is split into many chunks, then you need to modify the DUMPFILE paratermeter to include %U

If the dump files are named EXP_PROD_1.dmp, EXP_PROD_2.dmp etc , then

DUMPFILE=EXP_PROD_%U.DMP

Dropbox: How to get shareable links

2011-07-19T23:12:00.002-04:00

I was trying to embed some of my pictures onto craigslist and couldn't get a shareable link.

To activate shareable link

1) log onto your dropbox account

2) Click on the link Enable Share

Merge dll into exe

2011-06-17T23:55:00.000-04:00

1) Download ILMerge
2) Install ILMerge
3) Go to command prompt and type the command

ilmerge.exe /target:winexe /out:combined_exename.exe orig_exe_name.exe orig_dll.dll

Say you have your program ( test.exe) and dll (someDllName.dll) built into c:\temp

"C:\Program Files\Microsoft\ILMerge\ilmerge.exe" /target:winexe /out:"C:\Temp\Combined.exe" "C:\Temp\Test.exe" "C:\Temp\somDllName.dll"

To make things easier, Copy the above 2 lines into a new file and name it combine.bat. Double click the batch file, and it should generate the output for you.

Location of Alert.log and trace files in Oracle 11g

2011-05-23T15:16:00.000-04:00

There are 2 options.

From SQLPlus

Show Parameter dump_dest

Using a Query

select * from v$diag_info

Hindu Trinitiy

2011-05-20T21:50:00.001-04:00

ஹிந்து மதத்தின் அடிப்படை கடவுள்கள் மொத்தம் முன்று. சுருக்கமாக மும்மூர்த்திகள்

பிரம்மா: இவரின் தொழில் படைப்பது, இதில் உலகம் முதல் உயிர் வாழும் அணைத்து ஜீவன்களும் அடக்கம்

விஷ்ணு: இவரின் தொழில் காப்பது.

சிவன் : இவரின் தொழில் அழிப்பது.

இதில் ஆச்சிரியம் என்னவென்றால், காக்கும் தொழிலும் , அழிக்கும் தொழிலையும் செய்யும் விஷ்ணுவையும், சிவனையும் வணங்கும் மக்கள், படைக்கும் தொழில் செய்யும் பிரம்மாவை வணங்குவது இல்லை

Types of Land defined in Tamil Literature

2011-05-20T21:32:00.005-04:00

முன்னுரை:

பள்ளி நாட்களில் விவரம் தெரிந்தோ தெரியாமலோ படித்த தமிழ் இலக்கியங்கள், செய்யுள்கள், ஹிந்து மத கதைகள் பற்றி ஒரு சிறிய தொகுப்பு.

Tamil literature classifies Land types into 5 types.

நம் தமிழ் இலக்கியத்தில் நிலம் ஐவகைகளாய் பகுக்கப்பட்டுள்ளது. அவை:

குறிஞ்சி : மலையும் மலை சார்ந்த பகுதிகளும்.
முல்லை: காடும் காடு சார்ந்த பகுதிகளும்.
மருதம்: வயலும் வயல் சார்ந்த பகுதிகளும்.
நெய்தல: கடலும் கடல் சார்ந்த பகுதிகளும்.
பாலை: நீரற்ற வற‌ண்ட பகுதி. உதாரணம் பாலைவனம்

Oracle: How to convert LONG to CLOB

2011-03-29T15:11:00.001-04:00

It is very simple to convert a LONG column to CLOB.

Create table test( col1 long);

Alter table test modify col1 clob;

That's it.

ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of column value

2011-03-01T11:30:00.000-05:00

SYS_CONNECT_BY_PATH is used in hierarchial queries. It returns the path of column value from a root node

example: SYS_CONNECT_BY_PATH(column_name, '/') where '/' is the seperator.

If the column_name contains the separator character, then you get the above error
"ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of column value"

In my example below, foldername had values like "Tree for Case/Document". Since the foldername has "/" which matches your seperator, you get the error.

select f.foldername, sys_connect_by_path(f.foldername,'/') dir
from folder f
connect by parentfolderkey = prior folderkey
start with casekey = 7457950

To remove the error, make sure that your seperator is unique, The error disappeared when I replaced the seperator "/" with "//"

select f.foldername, sys_connect_by_path(f.foldername,'//') dir
from folder f
connect by parentfolderkey = prior folderkey
start with casekey = 7457950

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]

2011-02-14T15:02:00.000-05:00

I have an Oracle 11g R2 database on a Vista box. I got this error twice, and in both occasions, it was due to Vista crashing (ran out of battery, blue screen)

Here are the steps I performed to resolve this error

Launch SQL Plus from Oracle\bin folder ( not from Client folder)

SQL> conn sys/sys as sysdba
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

SQL> alter database recover;
Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[136], [65730], [65738], [], [], [], [], [], [], []

SQL> shutdown immediate;
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00279: change 3997604 generated at 02/11/2011 21:08:59 needed for thread 1
ORA-00289: suggestion :
C:\APP\RMANNI\RECOVERY_AREA\ORCLDB11G\ARCHIVELOG\2011_02_14\O1_MF_1_136_%U_.ARC
ORA-00280: change 3997604 for thread 1 is in sequence #136

Since my database is not running in archive log mode, I couldn't find the file specified in the above error message. I proceeded with the following

SQL> alter database recover continue default;
alter database recover continue default
*
ERROR at line 1:
ORA-00308: cannot open archived log
'C:\APP\RMANNI\RECOVERY_AREA\ORCLDB11G\ARCHIVELOG\2011_02_14\O1_MF_1_136_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

SQL> alter database recover cancel;
Database altered.

If the above step errored out, then proceed with the lines shown below inbetween the dotted lines, if not

SQL> alter database open resetlogs;
Database altered.

SQL> Your database is good to go, You should now be able to connect

-----------If Alter database recover cancel Failed ------------------

SQL> alter database recover cancel;
alter database recover cancel
*
ERROR at line 1:
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'

SQL> recover database using backup controlfile until cancel;
ORA-00275: media recovery has already been started

SQL> shutdown immediate;
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Now, when you try to recover, Oracle will provide a suggestion,provide the path for your REDO log files. One of the log files will fix your database. I started with Redo03, but Redo01 fixed my database. You probably don't need to shutdown and restart the database for each Redo log flies.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1
ORA-00289: suggestion :
C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC
ORA-00280: change 2448238 for thread 1 is in sequence #67

Specify log: {=suggested | filename | AUTO | CANCEL}
C:\app\rmanni\oradata\ORCLDB\REDO03.LOG
ORA-00310: archived log contains sequence 66; sequence 67 required
ORA-00334: archived log: 'C:\APP\RMANNI\ORADATA\ORCLDB\REDO03.LOG'
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'

SQL> shutdown immediate;
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1
ORA-00289: suggestion :
C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC
ORA-00280: change 2448238 for thread 1 is in sequence #67

Specify log: {=suggested | filename | AUTO | CANCEL}
C:\app\rmanni\oradata\ORCLDB\REDO02.LOG
ORA-00310: archived log contains sequence 65; sequence 67 required
ORA-00334: archived log: 'C:\APP\RMANNI\ORADATA\ORCLDB\REDO02.LOG'
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\RMANNI\ORADATA\ORCLDB\SYSTEM01.DBF'

SQL> Shutdown immediate;
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2448238 generated at 11/16/2010 22:05:53 needed for thread 1
ORA-00289: suggestion :
C:\APP\RMANNI\FLASH_RECOVERY_AREA\ORCLDB\ARCHIVELOG\2011_02_14\O1_MF_1_67_%U_.ARC
ORA-00280: change 2448238 for thread 1 is in sequence #67

Specify log: {=suggested | filename | AUTO | CANCEL}
C:\app\rmanni\oradata\ORCLDB\REDO01.log
Log applied.
Media recovery complete.

SQL> alter database open resetlogs;
Database altered.

-----------If Alter database recover cancel Failed ------------------

Oracle: Disable Archive log mode

2010-12-22T22:49:00.000-05:00

Launch SQLPLUS and login as SYS

Determine if the database is setup in archive log mode

SQL> Select log_mode from v$database

SQL> archive log list;

Archive log list gives a little bit detailed information about your archive log setup. By default, when you enable archive log, all the archive log files are written into flash_recovery_area.Below command will show you the OS path

sql> show parameter recovery_file_dest

To Disable Archive log
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog
SQL> alter database open
SQL> archive log list

Your database is now running in NO archive log mode

Oracle: Enable Archive log mode

2010-12-22T22:41:00.000-05:00

Launch SQLPLUS and login as SYS

Determine if the database is setup in archive log mode

SQL> Select log_mode from v$database

SQL> archive log list;

Archive log list gives a little bit detailed information about your archive log setup. By default, when you enable archive log, all the archive log files are written into flash_recovery_area.Below command will show you the OS path

SQL> show parameter recovery_file_dest

To Enable Archive log
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog
SQL> alter database open
SQL> archive log list

Your database is now running in archive log mode

Oracle: Import 11g data dump into 10g

2010-12-09T09:52:00.001-05:00

You can use Oracle data dump to export data dump from 11g server, and import into 10g using the data Pump parameter called Version. When you use Version, Datapump exports all objects that are compatible for your target version

So, If your database is 11g and you want to export 11g and import into 10g

from 11g db cmd promt> expdp Test_schema_name/passs directory=datapump schemas=Test_Schema_Name Version=10.2.0.4.0

Once the export is done, you do the regular import from 10g server.

Oracle: Convert XMLType to Varchar2

2010-11-23T10:41:00.000-05:00

Use xmltype.getStringVal() or xmltype.getClobVal() based on the size.

declare
myxml_type xmltype;
mystr Varchar2(4000);
begin
mystr :=myxml_type.getStringVal();
end;
/

Explain Plan table in Toad

2010-11-22T14:58:00.000-05:00

There are 2 options

Use PLAN_TABLE that comes with the schema
Use TOAD_PLAN_TABLE (Created by Toad)

Option 1

Query user table for PLAN_TABLE

Select * from user_tables where table_name ='PLAN_TABLE'

Set this table in Toad Menu

View->Toad Options-> Select Oracle

on the right had side, you will see options for Explain Plan

Option 2

You can create TOAD_PLAN_TABLE, by running TOADPREP.SQL (Found in older version of Toads). This is no longer available in Toad 10

ORA-01172:recovery of thread 1 stuck at block xxxx of file x

2010-11-11T10:31:00.000-05:00

Lately, I've been plagued with all sorts of Oracle start up errors on my Vista box. I have Oracle 11gR2 installed, and it seems to crash everytime I force reboot my vista box

Yesterday I got,

ORA-01172:recovery of thread 1 stuck at block xxxx of file x

To solve

1) Open SqlPlus from Oracle Bin folder, login as sys/zzz as sysdba
2) Since the database is not open, you can only query on fixed tables/Views
3) Query on v$datafile for the file name in the error message

If the error is "ORA-01172:recovery of thread 1 stuck at block 1241 of file 3",

then Select name from v$datafile where file#=3

4) Recover datafile name_from_the_above_select
5) If file is recovered, then try
Alter database open

6) In my case, I got some weird ora-6000 [4194], So I did a shutdown and startup force, which resovled my issue

7) Shutdown immediate
8) Startup force

Ubuntu Wireless driver for Dell

2010-11-07T00:56:00.000-04:00

After installing Ubuntu, go to additional drivers and install Broadcam STA Wireless driver.

This driver enabled my Wireless card ( Dell Wireless 1510), and works great.

Moved blog address

2010-10-28T13:31:00.000-04:00

Please visit my new blog for updates

http://rmanni.blogspot.com

ORA-12528: TNS:Listener: All Appropriate instances are blocking new connections

2010-10-28T13:25:00.000-04:00

Go to the database server box
Navigate to the bin folder and launch SQLPLUS (Usually C:\app\rmanni\product\11.1.0\db_1\BIN )

Luanch sqlplus and connect to the database as SYS without using @TNSAlias

ex: conn sys/sys as sysdba

Once you are in, do a

Shutdown
Startup

You are good to go.

Oracle 11g Installation: File not found

2010-10-26T14:42:00.000-04:00

Oracle 11g Release 2 Installation files contains 2 zip files.

win32_11gR2_database_1of2.zip
win32_11gR2_database_2of2.zip

You need to unzip both the files into the same location. Unzipping the first one, will not unzip the second file.

Pretty lame, but you have to unzip both.

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

2010-10-21T16:53:00.000-04:00

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor is the most common and most frustrating error in Oracle

What it means is, In tnsnams.ora, the service_name parameter is in correct or not available

TNS_Service =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = machine_name)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Database_Name)
)
)

In my instance, I have Oracle hosted on a Windows box, and my OracleServiceDatabase_Name
was not started.

Once I started the Windows service , I was able to connect to the database

Start->Run->Services.msc

Locate the OracleServiceDatabase_Name, and right click and start the service.

CTRL ALT DEL on Remote Desktop

2010-08-19T15:29:00.001-04:00

If you remote into desktop, and the desktop locks out, CTRL ALT DEL, will only bring your machine's screen.

To send CTRL ATL DEL for Remote pc, use

CTRL ALT END

CTRL ALT DEL on Remote Desktop

2010-08-19T15:29:00.000-04:00

If you remote into desktop, and the desktop locks out, CTRL ALT DEL, will only bring your machine's screen.

To send CTRL ATL DEL for Remote pc, use

CTRL ALT END

Regular expression to split comma separated values

2010-07-19T15:16:00.000-04:00

with test as
(select '5/10/2007,36352737,,"first_name, last_name Jr.",211001,7204,-75.00' str from dual)
Select regexp_substr(str,'".*"|[^,]+', 1, level)
from test
connect by regexp_substr(str,'".*"|[^,]+', 1, level) is not null

Oracle: Spool to Excel from SQLPlus

2010-07-15T14:04:00.000-04:00

Spooling the output from SQLPlus to log file is often in unreadable format.

To Spool SQLPLus output to Excel (.xls) file, the trick is to turn On "MARKUP HTML"

SQL>set markup html on
SQL>set feedback off

SQL>spool c:\test.xls

SQL>select * from user_objects where rownum <= 20;
SQL>spool off

SQL>set markup html off

2 more reasons to be vegetarian

2010-07-12T23:51:00.001-04:00

Lara Dutta for Peta

GPS

2010-07-04T22:32:00.001-04:00

Oracle: Forgot SYS and SYSTEM password

2010-07-01T11:17:00.000-04:00

If you forget or lost both SYS and SYSTEM password, you can reset them without logging in to the database.

Here is a cool utility to reset SYS and SYSTEM password, if you ever loose or forget the passwords for these account.

This is tested in Windows box only ( orapwd should work in Unix too)
---------------------------------------------------------------------

1) Go to services ( start -> Run->Services.msc)
2) Stop all Oracle services.
3) Find PWDxxxx.ora file. It is usually located in the Oracle\product\10.x\db_x\database. xxxx stands for your Oracle SID. For example, if you database is called ORCL, then the file will be PWDorcl.ora
4) Back up the existing file (just rename the file)
5) Generate new PWDxxxx.ora file using orapwd utility.
6) Go to command prompt, type
ORAPWD file=path_to_the_PWDxxx.ora_file password=zzzz
zzzz will the new password for both SYS and SYSTEM account
7) Now you will see a new PWDxxx.ora file generated.
8) Restart your Oracle service
9) You should be able to connect to the database with the new password.

ORA-04028: cannot generate diana for object

2010-05-18T18:20:00.000-04:00

ORA-04028: cannot generate diana for object object_name

Goes away if you recreate the object in question

I got this error when compiling a package. The error said "Cannot generate Diana for a particular view".

There was nothing wrong with view, and select * from view_name ran fine with no errors.

I dropped and recreated the view, the Diana message went away.

Oracle: Regular expression to remove html tags

2010-05-12T15:48:00.000-04:00

There are two ways to strip HTML tags from a string

1) Try to extract everything between end html tag(>)and next starting html tag (<)

2) First approach becomes complicated when you have nested tags. So the solution is to replace everything that is between (<) and (>)

SQL below replaces all the tags with space.

Select Regexp_Replace('<>source string<>bold<> with html tags<>', '<[^>]+>','') from dual

*Note: just put some tags between <> to test, google is not displaying the tags properly. The inner tags (before and after bold ) simulate nested tags.

Bollywood Models

2010-05-09T00:02:00.002-04:00

Bhairavi Gowswami

Kaveri Jha

Neetu Chandra

Oracle: How to replace non printable characters in a string

2010-05-05T13:14:00.000-04:00

You can replace non printable characters in a string using regexp_replace

select regexp_replace('Test'||chr(10)||chr(13)||chr(1)||' String ', '([^[:print:]])',' ') from dual

If you want to retain the the new line characters like chr(10) and chr(13) then

Select regexp_replace('Test'||chr(10)||chr(13)||chr(1)||' String ','['||chr(1)||'-'||chr(9)||']|['||chr(11)||'-'||chr(12)||']|['||chr(14)||'-'||chr(31)||']',' ') from dual

Above sql is removing chr from 1-9, 11-12 and 14-31

Here is SQL to identify printable, non printable, control characters

select level,CHR(level),
decode(chr(level), regexp_substr(chr(level), '[[:graph:]]'), '*') is_graph, --printable character
decode(chr(level), regexp_substr(chr(level), '[[:blank:]]'), '*') is_blank,
decode(chr(level), regexp_substr(chr(level), '[[:alnum:]]'), '*') is_alnum, --Any alphanumeric character, [A-Za-z0-9]
decode(chr(level), regexp_substr(chr(level), '[[:alpha:]]'), '*') is_alpha, -- Any letter, [A-Za-z]
decode(chr(level), regexp_substr(chr(level), '[[:digit:]]'), '*') is_digit, -- Any digit, [0-9]
decode(chr(level), regexp_substr(chr(level), '[[:cntrl:]]'), '*') is_cntrl, --Any character not part of the character classes: [:upper:], [:lower:], [:alpha:], [:digit:], [:punct:], [:graph:], [:print:], [:xdigit:]
decode(chr(level), regexp_substr(chr(level), '[[:lower:]]'), '*') is_lower, -- Any lowercase letter, [a-z]
decode(chr(level), regexp_substr(chr(level), '[[:upper:]]'), '*') is_upper, --Any uppercase letter, [A-Z]
decode(chr(level), regexp_substr(chr(level), '[[:print:]]'), '*') is_print, --Any printable character
decode(chr(level), regexp_substr(chr(level), '[[:punct:]]'), '*') is_punct, --Any punctuation character: START ! ' # S % & ' ( ) * + , - . / : ; < = > ? @ [ / ] ^ _ { | } ~ END
decode(chr(level), regexp_substr(chr(level), '[[:space:]]'), '*') is_space, --A tab, new line, vertical tab, form feed, carriage return, or space
decode(chr(level), regexp_substr(chr(level), '[[:xdigit:]]'), '*') is_xdigit --Any hexadecimal digit, [0-9A-Fa-f]
from dual
where level between 0 and 255
connect by level <= 256

Anushka

2010-05-02T11:30:00.001-04:00

Vedas

2010-04-30T00:09:00.001-04:00

Vedas are holy books of Hinduism, written in Sanskrit sometime between 1500 and 500BC

There are 4 Vedas (Sacred Texts)

Rig Veda : Knowledge of Praise. It contains Hymns(verses) praising gods
Sama Veda : Knowledge of Sacred Songs(chants). It contains Hymns recited as religious services
Yajur Veda : Knowledge of Rites(Sacrifices).Its divided into 2 parts, Black Yajurveda Taittiriy & White Yajurveda Vajasaneyi
Athara Veda :

More to come...

Vedas

2010-04-30T00:09:00.000-04:00

Vedas are holy books of Hinduism, written in Sanskrit sometime between 1500 and 500BC

There are 4 Vedas (Sacred Texts)

Rig Veda : Knowledge of Praise. It contains Hymns(verses) praising gods
Sama Veda : Knowledge of Sacred Songs(chants). It contains Hymns recited as religious services
Yajur Veda : Knowledge of Rites(Sacrifices).Its divided into 2 parts, Black Yajurveda Taittiriy & White Yajurveda Vajasaneyi
Athara Veda :

More to come...

2010-04-29T23:49:00.001-04:00

கடவுள் இல்லை என்பவனை நம்பலாம்....
கடவுள் இருக்கு என்பவனையும் நம்பலாம் ..
ஆனால் நான் தான் கடவுள் என்று சொல்பவனை என்றும் நம்பவே கூடாது

PLS-00306 WRONG number or types of arguments in call to XMLAGG

2010-04-29T17:55:00.000-04:00

This a bug in Oracle. This error is thrown when you use ORDER BY clause with XMLAGG in PL/SQL.

Work Around: Remove the ORDER BY Clause

Funny part is, the SQL will work fine in SQLPLUS, but when you use in PL/SQL it will throws the above error.

Versions confirmed as being affected: 9.2.0.2 to 9.2.0.6

This bug is fixed from 9.2.0.7 onwards

Meenakshi Amman Temple

2010-04-02T10:58:00.001-04:00

Thanks to http://www.view360.in/, you can see 360 degree view of several places.

Click here --> Madurai Meenakshi Amman Temple

Click for more

Dell: AC Power Adapter Type Cannot Be Determined

2010-03-30T11:04:00.001-04:00

Well, My New XPS 13 started to act strange, It wont charge when I plug in the power adapter and would display "

AC Power Adapter Type Cannot Be Determined"

After struggling for hours, found the issue.

If you look at the power cable that plugs into your laptop, you should see a small pin (male pin) inside. This pin was broke in my case, and hence my battery wont charge and Dell displays a strange message.

I bought a cheap replacement power cable from ebay ( $10-$15) and problem is gone.

Dell: AC Power Adapter Type Cannot Be Determined

2010-03-30T11:04:00.000-04:00

Well, My New XPS 13 started to act strange, It wont charge when I plug in the power adapter and would display "

AC Power Adapter Type Cannot Be Determined"

ORA-38104: Columns referenced in the ON Clause cannot be updated

2010-03-16T10:52:00.000-04:00

When you use Merge statement, you cannot update the columns reference in the ON Clause.

Not many know that, Merge supports "WHERE Clause".

Add a Where Clause to your Update statement under "When Matched"

Merge Into ...
Using ()
When Matched then
Update ...
Where ...
When Not Matched then
......

ORA-28056: Writing audit records to Windows Event Log failed

2010-03-10T09:07:00.001-05:00

I started getting this error after installing Oracle llg database.

Here are couple of options to fix it.

Open Event Viewer: Click Start, click Control Panel,click Administrative Tools,
and then double-click Event Viewer.

1) Clear Application log. Right click on Application, Select clear all events

2) Or, Increase the Application log size. Right click on Application, Select properties, Increase Maximum log size.

3) Or, Change Max log size Over write options. Select "Overwrite events as needed"

Shruti Hassan : South Indian Style

2010-03-09T12:30:00.001-05:00

Aishwarya Rai Loreal Photo shoot

2010-03-06T15:59:00.001-05:00

ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

2010-03-05T14:14:00.001-05:00

Can't figure out why your SELECT statement is throwing 'OGC_X' error ?

1) Most probably, your SELECT has a table with an alias "x"
2) Your oracle is version is lower than 11g
3) You probably mistyped column name

Solution
Prior to Oracle 11g, Oracle by default comes with a synonym 'X' defined for "OGC_X".

1) In your SELECT, if you mistype the column name from the table aliased as "x", Oracle tries to use the Synonym object "OGC_X", and hence you get the error.

Following SQL works
select * from dual x where x.dummy = 'X'

Now change, x.dummy to x.fummy (wrong column name), you will the error

select * from dual x where x.fummy = 'X'

In summary, if your table alias matches any synonym in your database and you typed the column name of the aliased table wrong, you get the error "ORA-06553: PLS-306: wrong number or types of arguments in call to ..."

Nandana Sen

2010-01-28T22:54:00.001-05:00

Indian Dress: Saree

2010-01-26T15:43:00.000-05:00

Celina

2010-01-21T18:10:00.001-05:00

Ultra Edit option missing in right click Context Menu

2010-01-06T21:54:00.001-05:00

If you don't see Ultra Edit in your context menu

Open UltraEdit, Click Menu Advanced->Configuration->File Associations -> Check Intergrate with Explorer as check box

Happy New Year

2009-12-29T10:54:00.001-05:00

Gwalior Fort, Madhya Pradesh

2009-12-16T19:54:00.000-05:00

Darasuram Ayravatheswarar temple, Kumbhakonam Tamil Nadu

2009-12-08T11:17:00.001-05:00

Ellora Maharashtra

2009-12-05T21:13:00.001-05:00

Ellora Maharashtra

2009-12-05T21:13:00.000-05:00

Shilpa Shetty

2009-11-10T16:53:00.000-05:00

SQL to Concat Rows into a list.

2009-11-09T10:00:00.001-05:00

Create table emp ( deptno int, ename varchar2(20));

SET DEFINE OFF;
Insert into EMP (DEPTNO, ENAME) Values (10, 'Mike');
Insert into EMP (DEPTNO, ENAME) Values (10, 'Nick');
Insert into EMP (DEPTNO, ENAME) Values (10, 'Carol');
Insert into EMP (DEPTNO, ENAME) Values (20, 'Jack');
Insert into EMP (DEPTNO, ENAME) Values (20, 'Joe');
Insert into EMP (DEPTNO, ENAME) Values (20, 'Janis');
Insert into EMP (DEPTNO, ENAME) Values (20, 'Chris');
Insert into EMP (DEPTNO, ENAME) Values (30, 'Adam');
COMMIT;

Select deptno,substr(max(sys_connect_by_path(ename,';')),2) ename_list
from (
Select deptno, ename, row_number() over(partition by deptno order by ename) r
from emp )
start with r = 1
connect by prior deptno = deptno
and prior r+1 = r
group by deptno

Though the sql looks complex, If you analyze the sql, there is
1) Row_number() which generates a running sequential number per deptno.
2) Connect by Deptno and rownumber
3) Get the max of the list using sys_connect_by_path and group by
4) Substr to remove the first delimiter.

How to convert flac to Wav

2009-11-08T12:55:00.001-05:00

Install Flac.exe

Open Command Prompt, Navigate to Flac.exe ( Usually c:\Program files\Flac)

flac -d "c:\Temp\Your_Song.flac"

Your_Song.wav will be generated in the same folder

தமிழ் கவிதை: சொந்த மண்ணில்

2009-11-07T18:01:00.001-05:00

How to move tablespace from one folder to another

2009-11-04T16:07:00.001-05:00

This method only works for User created tablespaces. It does not require to shutdown your database.

If you need to move SYSTEM tablespaces, refer to link

In my example, I have 2 tablespaces named contm_data and contm_indx. They were created in Datapump folder by mistake. I had to move them one folder up.

Log in as SYS

Alter tablesapce contm_data offline;
Alter tablesapce contm_indx offline;

Manually copy/move the data files from old location ('E:\Oracle\OraData\PRODDB\DATAPUMP) to new location ('E:\Oracle\OraData\PRODDB)

alter tablespace contm_data rename datafile 'E:\Oracle\OraData\PRODDB\DATAPUMP\CONTM_DATA.DBF' to 'E:\Oracle\OraData\PRODDB\CONTM_DATA.DBF';

alter tablespace contm_indx rename datafile 'E:\Oracle\OraData\PRODDB\DATAPUMP\CONTM_INDX.DBF' to 'E:\Oracle\OraData\PRODDB\CONTM_INDX.DBF';

Alter tablesapce contm_data online;
Alter tablesapce contm_indx online;

Sharing TNSNames.Ora

2009-11-03T16:29:00.001-05:00

If you have multiple oracle client installations (9i, 10g, 11i) on your box and don't want to configure tnsnames.ora for each oracle home, you can use tnsname sharing.

By sharing, you maintain 1 tnsnames.ora file and point all other tnsnames.ora (from all other home)
to the main file. Use ifile parameter to point to another location

example:

tnsnames.ora from 11i client will just have the following line. In this example it points to 10g client.

ifile=C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

Shilpa Shetty

2009-11-03T00:21:00.000-05:00

Koena Mitra

2009-11-03T00:20:00.000-05:00

How to find patches installed on Oracle

2009-10-29T23:41:00.001-04:00

Launch command prompt

1) Navigate to Oracle Home Directory

Your Command prompt should look like

c:\app\machine_name\product\11.x.x.\db_1> for 11g

c:\oracle\product\10.x.x\db_1> for 10g.

2) Now set Oracle_HOME to the Oracle homes path, In my case for 10g

c:\oracle\product\10.x.x\db_1> SET ORACLE_HOME= c:\oracle\product\10.x.x\db_1

3) Navigate to Opatch directory

c:\oracle\product\10.x.x\db_1> cd opatch

c:\oracle\product\10.x.x\db_1\opatch>

4) type opatch lsinventory

c:\oracle\product\10.x.x\db_1\opatch>opatch lsinventory

You will get a report on the patches installed.

how to export all filenames in a folder to a text file

2009-10-18T23:35:00.000-04:00

Well, I found a very simple solution to this.

Launch Windows command prompt, Navigate to the root folder ( say c:\temp)

C:\Temp> dir /s /b > filenames.txt

/s -> includes all subdirectories

/b -> will inlcude only file name ( no attributes, date created etc)

Lara Dutta

2009-10-17T00:30:00.000-04:00

In the movie BLUE

Sheryln Chopra

2009-10-17T00:25:00.000-04:00

Mugdha Godse

2009-10-17T00:21:00.000-04:00

Oracle: Sql to find table and column comments

2009-10-14T11:19:00.001-04:00

Select t.table_name,tc.comments table_comments,c.column_name,data_type,cc.comments column_comments
from user_tables t, user_tab_columns c,user_tab_comments tc,user_col_comments cc
where t.table_name = c.table_name
and t.table_name = tc.table_name(+)
and c.table_name = cc.table_name (+)
and c.column_name = cc.column_name (+)
order by table_name,column_id

enq: TM - contention

2009-10-09T13:57:00.001-04:00

It took me a while to resolve this issue on my database. Every single resource on the Net pointed to "missing indexes on foreign key columns", but I found it was due to another session locking my database.

The following query gave me a list of blocking sessions. Once I killed those sessions,
"enq: TM - contention" went away.

Select v.sid,s.blocking_session, s.event, v.type,v.lmode,v.request,o.object_name, o.object_type
from v$lock v ,dba_objects o, v$session s
where v.id1 = o.object_id
and v.sid = s.sid
and owner ="Put_your_Owner_Name_Here"

enq: TM - contention

2009-10-09T13:57:00.000-04:00

How to clean your monitor

2009-10-07T15:24:00.000-04:00

ORA-39149: cannot link privileged user to non-privileged user

2009-10-05T11:01:00.001-04:00

When you use Network_link parameter to import a database dump, you will get the error
"ORA-39149: cannot link privileged user to non-privileged user", if the EXP_FULL_DATABASE privilege is missing on the source schema.

Log in as SYS/System and grant the following privilege.

Grant EXP_FULL_DATABASE TO schema_owner;

Script to enable all Constraints

2009-09-29T10:18:00.000-04:00

declare
Cursor cCons is select table_name,constraint_name
from user_constraints
where status = 'DISABLED';
--order by decode(constraint_type,'R','A',constraint_type);
type t is table of cCons%rowtype index by binary_integer;
all_constraints t;

nLimit int := 100;
begin

open cCons;
loop
Fetch cCons Bulk Collect into all_constraints limit nLimit;

for i in 1..all_constraints.count loop
begin
execute immediate 'Alter table '||all_constraints(i).table_name||' modify constraint '|| all_constraints(i).constraint_name ||' enable validate';
--Exception
-- WHEN Others then
-- null; -- to ignore globalmedi_intermedia system generated constriants
end;
end loop;

exit when all_constraints.count < nLimit;
end loop;
Close cCons;

end;
/

Script to Enable All Triggers

2009-09-29T10:17:00.000-04:00

Declare
Cursor cTriggers is Select table_name from user_tables;
type t is table of cTriggers%rowtype index by binary_integer;
all_triggers t;
nLimit int := 100;
begin

Open cTriggers;
loop
Fetch cTriggers Bulk Collect into all_triggers limit nLimit;

for i in 1..all_triggers.count loop
Execute Immediate ' Alter table '||all_triggers(i).table_name||' enable all triggers';
end loop;

Exit when all_triggers.count < nLimit;
end loop;
Close cTriggers;
end;
/

Script to disable All Constraints

2009-09-29T10:14:00.000-04:00

declare
Cursor cCons is select table_name,constraint_name
from user_constraints
where status = 'ENABLED'
order by decode(constraint_type,'R','A',constraint_type);
type t is table of cCons%rowtype index by binary_integer;
all_constraints t;

nLimit int := 100;
begin

open cCons;
loop
Fetch cCons Bulk Collect into all_constraints limit nLimit;

for i in 1..all_constraints.count loop
begin
execute immediate 'Alter table '||all_constraints(i).table_name||' disable constraint '|| all_constraints(i).constraint_name;
Exception
WHEN Others then
null; -- to ignore any system generated constriants for BLOB/CLOB columns
end;
end loop;

exit when all_constraints.count < nLimit;
end loop;
Close cCons;

end;
/

Script to disable All Triggers

2009-09-29T10:12:00.000-04:00

Declare
Cursor cTriggers is Select table_name from user_tables;
type t is table of cTriggers%rowtype index by binary_integer;
all_triggers t;
nLimit int := 100;
begin

Open cTriggers;
loop
Fetch cTriggers Bulk Collect into all_triggers limit nLimit;

for i in 1..all_triggers.count loop
Execute Immediate ' Alter table '||all_triggers(i).table_name||' disable all triggers';
end loop;

Exit when all_triggers.count < nLimit;
end loop;
Close cTriggers;
end;
/

2009-09-22T10:24:00.001-04:00

2009-09-22T10:24:00.000-04:00

Amruta Patki

2009-09-22T10:14:00.001-04:00

Amruta Patki

2009-09-22T10:14:00.000-04:00

Nisha Kothari

2009-09-22T10:11:00.000-04:00

Gauhar Khan

2009-09-20T18:04:00.001-04:00

New face

Gauhar Khan

2009-09-20T18:04:00.000-04:00

New face

Udita Goswami

2009-09-20T18:01:00.000-04:00

Shilpa & Shamita Shetty

2009-09-20T17:51:00.000-04:00

Nisha Kothari

2009-09-20T17:45:00.001-04:00

Nisha Kothari

2009-09-20T17:45:00.000-04:00

Indian Dress: Sarees

2009-09-20T09:25:00.000-04:00

Windows: Task Manager won't open

2009-09-19T00:46:00.000-04:00

You may have virus/Malware installed on your computer.

Click Start- > Run -> TaskMgr.exe

It it doesn't open

Start ->Run->Regedit

Navigate to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\taskmgr.exe

Remove the value for the Field Debugger.