Thursday, March 4, 2010

ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER

When trying to startup the Oracle Database 11g , Its return following message.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'

Solution:
=========
In Oracle 11g

Just go to pfile (\d01\oracle11G\admin\db11g\pfile).
then comment the LOCAL_LISTENER parameter like #LOCAL_LISTENER

Then start the Database with pfile.
Like:=

SQL> startup pfile=C:\oracle11G\app\era-1\admin\db11g\pfile\init.ora.11312009193622 ;

and then

SQL> create spfile from pfile='C:\oracle11G\app\era-1\admin\db11g\pfile\init.ora.11312009193622' ;

Tuesday, March 2, 2010

ALL DIFFERENCES FROM TWO TABLE

CREATE TABLE T11
(
N1 NUMBER NULL,
N2 NUMBER NULL,
V1 VARCHAR2(215 BYTE) NULL
)
/


Insert into T11 (N1, N2, V1)
Values (1, 1, 'HALIM');

Insert into T11 (N1, N2, V1)
Values (0, 0, 'x');

Insert into T11 (N1, N2, V1)
Values (0, 0, 'x ');

COMMIT;



CREATE TABLE T22
(
N1 NUMBER NULL,
N2 NUMBER NULL,
V1 VARCHAR2(215 BYTE) NULL
)
/


Insert into T22 (N1, N2, V1)
Values (1, 1, 'HALIM');

Insert into T22 (N1, N2, V1)
Values (2, 2, 'x');

Insert into T22 (N1, N2, V1)
Values (3, 3, 'rubel');


COMMIT;


---ALL DIFFERENCES FROM TWO TABLE

Select * from
(
select 'HTEST.T11' "Row Source", a.* from
(
select /*+ FULL(Tbl1) PARALLEL(Tbl1, 4) */
N1, N2, V1
from HTEST.T11 Tbl1
minus
select /*+ FULL(Tbl2) PARALLEL(Tbl2, 4) */
N1, N2, V1
from HTEST.T22 Tbl2
) A
union all
select 'HTEST.T2', b.* from
(
select /*+ FULL(Tbl2) PARALLEL(Tbl2, 4) */
N1, N2, V1
from HTEST.T22 Tbl2
minus
select /*+ FULL(Tbl1) PARALLEL(Tbl1, 4) */
N1, N2, V1
from HTEST.T11 Tbl1
) B
)
Order by 1