This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Mar 21, 2013 5:27 AM by EdStevens RSS

Listener configuration and other questions

998276 Newbie
Currently Being Moderated
I have installed 2 database instances on the same database and under the same database home.
The instances use the same listener. If i try to start enterprise manager in browser for both instances,
the Enterprise Manager starts just for the last installed instance. I have edited the listener.ora file an
added one more Description with another port number like folowing:

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1522))
)



to the following content:

LISTENER_APPDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

now the file looks like following:


LISTENER_APPDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
     (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1522))
)
)

ADR_BASE_LISTENER_APPDB = D:\app\oracle2

SID_LIST_LISTENER_APPDB =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\oracle2\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle2\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

i have also changed the port of one of the instances in the tnsnames.ora file from 1521 to 1522.
Now it is possible to start Enterprise Manager for both instances. But after i connect to one of the
instances with the Enterprise Manager the other instance logs of. Is it ok so??? Will i have problems
with this configuration?? Should i do something different??

Second question: After i have installed an instance, during the installation some patches where
automaticaly installed. After that i have installed another instance. Do i have to patch this instance too???
Are the patches installed for the whole DBMS or just for one instance???

*Third question: If i have 2 instances how can i set the parameter btree_bitmap_plans for only*
one of the instances ??? I have found the following code to do this:

ALTER SYSTEM SET "_b_tree_bitmap_plans"=false SCOPE=SPFILE;

but for wich instance the parameter will be set for both or just for one? Do i have to choose
one of the instances?? How can i do that??

Edited by: 995273 on 21.03.2013 02:49
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points