Oracle RAC Listener Configuration
Dec 6, 2010
i have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the
(FAILOVER=ON) (CONNECT_TIMEOUT=5) (RETRY_COUNT =3).
and to configure server side load balancing i have modified the service as follows:
execute (DBMS_SERVICE.MODIFY_SERVICE (service_name=>'service_name', clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);
now i have few questions:
1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node.
2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes.
3. does the listener have to be registered with the vip network address (where the clients usually use to connect).
View 2 Replies
ADVERTISEMENT
Jul 24, 2012
We have a listener with the password set to it. We are trying to configure that listener to the OEM grid. However, its not getting configured. The status shows as down.
However, when we try to set up without the password, we are able to configure it on the OEM console.
Need to understand, that if passwords are set to the listener; then won't that get configured over the OEM. or is there something where we are lacking.
View 4 Replies
View Related
Jan 6, 2010
We have an oracle server on windows. It was working fine till today but now it is giving an error. When i try to add a listener configuration using net configuration assistant, it terminates abruptly without givng the finish button. Why does this happen?
I am not able to open the link
[URL]......
It gives an error "Oops! This link appears to be broken"
How can we solve this?
View 3 Replies
View Related
Sep 5, 2012
i have added a new listner on new port on my window 7 system for oracle version 11.2.0.1 and registered some test databases to this new listner , then i am able to access my databases through the toad because i have changed port number in tns entry, but not able to login by sqlplus. is i am missing something? should i have to restart the system or restart the all databases?
View 1 Replies
View Related
Jul 29, 2011
I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.
View 7 Replies
View Related
May 29, 2013
I installed apex and configure the apex listener at port 80 by mistake couldn't pay attention to use port 8080. The installation is complete but the apex is running at URL.... but the login window is invisible on the page. I can just see the name on the tab "Application Express Login" . When i click on the error message at the bottom of the browser, the message says "apex is undefied" line 35.
When I run the server, I get a message "No free port within range 80. How can I change from port 80 to 8080? how to either un-install the listener or change the port 80 to 8080
View 3 Replies
View Related
Sep 10, 2013
I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?
View 5 Replies
View Related
Aug 11, 2010
ISSUE : I have to create ORACLE 10G R2 RAC. This cluster will host two databases pre-prod and prod. Both databases will be on different networks. pre-prod on 10.88.119 and prod on 10.88.118. I just have two hosts forming the this cluster.
How can i configure my hosts file and during clusterware installation what entries should i make for hosts and interfaces. Can this be done in 10g or will have to switch to 11g.
View 2 Replies
View Related
Jul 19, 2010
We are in the design phase of a project and wanting to implement a 4 node RAC with a DR site. However to get around some licensing costs, management are insisting that only 1 node be up accepting data at the DR site. In the event of a disaster, the remaining nodes will be switched on.
View 3 Replies
View Related
Oct 28, 2013
I newly joined Oracle 11g DB related project.That oracle environment own our customer and we have only limited time and access to that DB.
I could login that database by SQLPlus by sys user as sysdba but I do not know any DB configurations. How could I collect Oracle 11g DB configuration information from SQLPlus ?
View 0 Replies
View Related
May 21, 2013
Tried installing APEX 4.2 with Oracle EBS 12.1.3. I have installed APEX into the Oracle EBS database (11.2.0.3)
I am trying to install the APEX listener on the Web Tier however it starts the listener and gives the url as
[URL]........
Is there a way to set this with actual hostname of the server.
View 2 Replies
View Related
Feb 6, 2013
I have installed oracle 10g in D drive . The installation says it is successful, without asking the database name or the password . I have followed the steps given in the attached file .
However it is not asking the database name or password ( no configuration set up is appearing for the user to interact with the system ) . So, after installation I can not give the username and password .
View 4 Replies
View Related
Mar 27, 2013
I am configuring two node RAC on oracle virtual box. Did its mandatory to configure DNS on both nodes before Rac installation? Whats the purpose of DNS in RAC. And if its mandatory did i have to configure DNS on each node separately?
View 1 Replies
View Related
Jul 9, 2012
I have been reading a lot of documentation regarding oracle services and I have an ok understanding of how they work. However, I have a general question regarding configuring services using Oracle RAC. For instance, if I have a 2 node oracle 11GR2 RAC on a Linux Redhat server. I have an application that connects to a service I have created. I create the service as follows.
srvctl add service -d ORCL_RAC -s APP_SERVICE -r ORCL_RAC1,ORCL_RAC2
The tnsnames contains:
APP_OLTP =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
[code]...
My questions are as follows:
1) When I do a 'srvctl status service -d ORCL_RAC', should I see the service running on both nodes of the RAC? Or does it run only one node, then it will fail over to the other when needed?
2) If I have a RAC environment where I see two services created (RAC_SRV1 and RAC_SRV2). I see that RAC_SRV1 is only running on node1 and RAC_SRV2 is only running on node2. There are two applications sharing the same database, one application is using RAC_SRV1 and the other application is using RAC_SRV2. Am I correct in thinking that there is no failover available here? If node1 goes down, the application connecting to RAC_SRV1 will not be able to connect to node2 right?
3) In the case of the scenario in question 2 above, would it be best practise to simply create one service and have both applications connecting to the one service? Could I configure the one service to point connections from one application to node1 and connections from the other application to node2?
View 1 Replies
View Related
Jul 11, 2012
we are running Oracle database 11.2.0.3 on RHEL 6.1.
Should we join the above machine to an existing Windows 2003 (Active Directory) Domain? or Configure it as a standalone Server?.
View 9 Replies
View Related
Jul 10, 2008
when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca
java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..
View 2 Replies
View Related
Jun 29, 2012
I am trying to create a rac setup on oracle 10.2. through NFS cluster configuration .i succeeded with the installtion of cluster configuarion and installation of oracle software ,but when i am trying to create database ,
View 2 Replies
View Related
Jan 26, 2010
Data Base Configuration assistant for create new database not working in oracle 8.1.7 in windows server 2000 / server 2003 how can i create new database
View 1 Replies
View Related
Sep 18, 2008
The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh
When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:
[root@rac2host crs]# ./root.sh
WARNING: directory '/home/oracle/product' is not owned by root
WARNING: directory 'home/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
[code]....
Is this concerned with permissions on OCR, Voting Disk.
the ./cluvy shows the cluster is valid.
View 1 Replies
View Related
Feb 1, 2012
I m using Windows Vista Business 32 bit , Oracle 10.2.0.3
while running my setup so many time i got same error each and every time Error:12560 TNS Protocol Adapter error and it shows me i attached my screen shot with my thread , and remember i already installed earlier but at that time there was no error and successfully installed, i removed the total software before installing and i also removed my environment variable and after getting this Database Configuration Assistant failure there is no service is started regarding my database.. I also tried manually but there also i got some other problem if by Database Configuration Assistant it ll b solved then it ll be good for me.
View 9 Replies
View Related
Jan 31, 2013
While installing 11g oracle grid cluster software. I am getting below error.
[INS-40724] No locally defined network interface matches the SCAN VIP subnet.
i have given scan name as scan-cluster.invent
host-name virtual ip name
rac3 rac3-vip
rac5 rac5-vip
I am able to ping rac3 and rac5 from both nodes.
MY /etc/host file look like this.
192.168.2.133 rac3.invent.com rac3
192.168.2.132 rac3-priv.invent.com rac3-priv
192.168.122.1 rac3-vip.invent.com rac3-vip
192.168.2.136 rac5.invent.com rac5
[code]...
ssh connectivity everything works fine.
View 1 Replies
View Related
Mar 28, 2010
I've installed without problems Oracle 8.0.5 on WS 2003. After installation I've created 8 databases, with the utility Database Configuration Assistant (dbassist, executed by launch80.exe).
After that, the DBAssist doesn't run anymore.
I've tried EVERYTHING. And I have no success, Im stuck. And I need to create several databases.
View 1 Replies
View Related
Feb 15, 2013
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
View 0 Replies
View Related
Mar 11, 2010
I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.
also,everytime when i give lsnrctl>show current_listener it is showing "listener"
i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.
View 8 Replies
View Related
Jul 5, 2010
In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?
As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.
View 4 Replies
View Related
Aug 30, 2010
Recently, I've just restored my QAS database and filesystem from my backup tape. I have checked all the configuration files and oracle setting files and do not notice any problem.
However, when I tried to start my listener, it shows some error messages as below. As a result, I'm unable to start my SAP application.
Error:
-------
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
For you information, I'm able to start my Oracle instance. Please refer to below.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5620367360 bytes
Fixed Size 2064184 bytes
Variable Size 2818572488 bytes
Database Buffers 2785017856 bytes
Redo Buffers 14712832 bytes
Database mounted.
oraqas 3> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 12:57:25
Copyright � 1991, 2007, Oracle. All rights reserved.
Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-------------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 30-AUG-2010 12:57:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
View 6 Replies
View Related
Oct 29, 2010
how to change this path:
F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
to this path:
d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
in the service ?
View 2 Replies
View Related
Mar 8, 2011
We have installed Oracle 10G in windows 2003 server. Oracle is working fine when oracle services are running in local system account, when we change the option �Log On As� from local system account to an domain id the oracle listener stops automatically.
I tried the below mentioned options, We created a new listener it did not worked . we are able to connect the db through command prompt but not through SQL plus or TOADWhen we add the domain id to the local administrator group the oracle is working fine. But we cannot have the domain id in local administrator group since GPO will automatically remove the domain id from local administrator group.
View 2 Replies
View Related
May 19, 2010
Dose any shell script that would be able to set the oracle_home & the listeners based on the versions of software on the box?
View 1 Replies
View Related
Mar 16, 2011
I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.
-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1
[code]..
Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
[code]...
View 1 Replies
View Related
