Implementing COST settings on single instance DB

#############################################

  Implementing COST settings on single instance DB 

##############################################

1. Try downloading the patch 12880299 for the concerned OS. Apply the patch if required.(Note: For some Environment you don't even need this patch)

LISTENER_SAJID =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))=====>Make Changes related to your Environment
      (ADDRESS = (PROTOCOL = TCP)(HOST = sajid.seo.se.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SECURE_REGISTER_LISTENER_SAJID = (IPC)====>Add this line to you LISTENER.ORA file and do set the listener name as per your listener.

2. Bounce the Listener to make the changes effective.


3. Set your bach profiles for database and Change the Local listener parameter as below.

13:39:48 oracle@SAJID $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 16 13:39:53 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@SAJID>show parameter local_listener;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string
SYS@SAJID>alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))' scope = both;

System altered.

4. Confirm the settings are right.

SYS@SAJID>show parameter local_listener;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS=(PROTOCO
                                             L=IPC)(KEY=REGISTER)))


Note:  Please do follow Oracle Doc ID: 1453883.1