Configured 2 Listeners Through Netca In Different Ports
Mar 15, 2011
I have 2 databases( A and B).. which shares common ORACLE_HOME.i configured 2 listeners through netca in different ports and both listener names are different...
But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa.and when i tnsping , i am able to see port 1521 default port for database A.
when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B? from where listener picks the default information???
>> when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..
Yes, among MANY other things.
CODE#*************************************************************
# Create an alias for every $ORACLE_SID on the UNIX server
#*************************************************************
for DB in `cat /var/opt/oracle/oratab|\
grep -v \#|grep -v \*|cut -d":" -f1`
[code]....
"ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
View 4 Replies
ADVERTISEMENT
Mar 14, 2011
I have 2 databases( A and .. which shares common ORACLE_HOME....
i configured 2 listeners through netca in different ports....
and both listener names are different...
But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa...and when i tnsping , i am able to see port 1521 default port for database A.
when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B?
View 1 Replies
View Related
Mar 11, 2013
i have created a database a make listener configuration and tns with netca.with netca configuration i used port 1525 then i need to change my database port with 1521 so i just moved to my listener.ora and tnsnames.ora and changed port setting to 1521 but after that also my database listening to both the locations.1521 and 1525..if i check connection with sql developer it says connect.how's it possible
View 3 Replies
View Related
Jan 24, 2005
I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.
View 12 Replies
View Related
Jul 20, 2012
We have a change in IT Dept in our organisation and we have been asked us about the impact of the following changes
1. Change in listener Port
2. Change in value of send and Recieve buffer in listener.ora
3. Change in Archive Size from 40M to 20M
View 2 Replies
View Related
Dec 6, 2011
can i start multiple listeners in one oracle database ?
View 7 Replies
View Related
Dec 30, 2003
I can't seem to get TNS Listener to install using a responsefile in Oracle 9i... I've been using the netca.rsp file that comes included on disc one of the Oracle 9i Release 2 cds. I've tried calling netca.rsp from inside a custom install response file template...
# Oracle Net Configuration Assistant
[oracle.networking.netca_9.2.0.1.0]
#-----------------------------------------------------------------------------
# Name : OPTIONAL_CONFIG_TOOLS
[Code].....
but when I check the services in Administrative settings the listener has not been created...I'm using OraInst as my staging directory.
I've also tried using the "Using Configuration Assistants in Non-Interactive Mode" section at:
URL
I also tried adding:
[Session]
TOPLEVEL_COMPONENT={"oracle.net.ca","9.2"}
to the netca.rsp file, since it wasn't there by default...
I've also tried going to my staging directory from the command prompt and running E:OraInst> launch.exe -silent -responseFile netca.rsp where launch.exe is a copy from launch.exe generated in oracleora92in
View 4 Replies
View Related
Jun 13, 2013
Oracle Database 11.2.0.3.0 64bitI have followed most steps of this link and I came to a stop at the point where I use the Network Configuration Assistant.I have selected the following
1) Directory Usage Configuration>
2) Microsoft Active Directory>
3) Operation (2nd): Select the directory server you want to use, and configure the directory server for Oracle usage.>
4) Input my AD hostname>
5) Then it displays a message that "The directory contains an older version of the required Oracle Schema. Directory usage configuration cannot continue without the correct Oracle Schema. If you have authorization to create the directory schema then you can upgrade the Oracle Schema now. Would you like to upgrade the Oracle Schema? I have selected: Yes, I want to upgrade... and thereafter I get the errors:
The Assistant is unable to create or upgrade the Oracle Schema for the following reason:
ConfigException: Could not upgrade the Oracle Schema: oracle.net.config.ConfigException: TNS-004409 Directory Service Errorcaused by: oracle.net.config.DirectoryServiceException: TNS - 04431: DirectoryService: no entries foundcaused by: oracle.net.ldap.NNFLException.You may need to upgrade the directory schema from a specific computer which directly supports your directory type.
Command Line Error Response
ConfigException: Could not check for the Oracle Schema: oracle.net.config.Config
Exception: TNS-04409: Directory service error caused by: oracle.net.config.DirectoryServiceException: TNS-04431: DirectorySe
rvice: no entries found caused by: oracle.net.ldap.NNFLException
View 4 Replies
View Related
Sep 17, 2013
solving the error below?
[oracle@localhost Desktop]$ netca
Oracle Net Services Configuration:
# An unexpected error has been detected by HotSpot Virtual Machine:
# SIGSEGV (0xb) at pc=0xa23ae762, pid=7422, tid=3075933888
# Java VM: Java HotSpot™ Server VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C [libclntsh.so.11.1+0x429762] snlinGetAddrInfo+0x1b2
An error report file with more information is saved as hs_err_pid7422.log
#If you would like to submit a bug report, {URL}...
/u01/app/oracle/product/11.2.0/db_1/bin/netca: line 178: 7422 Aborted (core dumped) $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $*
View 1 Replies
View Related
Jul 24, 2013
The OUI threw the subject error during installation of Grid Infrastructure 12.1.0.1 on OEL 6.4 with Job Role Separation. This occurred after successfully running root.sh when the OUI started the NETCA task . The solution was very simple: go to /u01/app/12.1.0 and "chmod g+w grid". At that point I was able to click "retry" and it worked perfectly. There were no other errors or issues during the entire installation. Just passing it along.
View 0 Replies
View Related
May 1, 2010
I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.
Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"
webutil configuration steps on R12 or the error solution,
View 1 Replies
View Related
Nov 24, 2011
We have configured formsweb with webutil. When we run the application and try to use webutil file operations the file open dialogue box is coming, but when we press ok, it is showing error. and we have found that error is
Quote:
WUC-15 [FileFunctions.fopen()] Unexpected error, Exception: java.lang.NullPointerException
View 2 Replies
View Related
Jul 24, 2013
I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?
View 7 Replies
View Related
May 16, 2011
I have configured oracle listener at Non-Default port 1526.
Is it mandatory to mention LOCAL_LISTENER parameter at pfile?
LOCAL_LISTENER='listenerr_alias'
View 2 Replies
View Related
Jan 26, 2011
Say Database Buffer Cache configured as 2M and my updates may use 4m size,will it throw an error message or update will happen perfectly without any issues?
View 2 Replies
View Related
Feb 22, 2011
i am have a problem with Oracle user equivalence. long time ago, we have created Two node RAC. that time, we configured Oracle user equivalence.
today when i am trying to install Oracle Agents on this RAC pair, installation was failed due to Oracle user equivalence. not sure how it happened, and i was confused too.
if i configure Oracle user equivalence again, will it cause any problem to my RAC setup?
is there any way to find, when was the Oracle user equivalence was changed/ ssh keys got changed?
View 2 Replies
View Related
Feb 25, 2013
I am trying to use the Apex listener 2.0 (instead of HTTP server). I installed and went thru the configuration of the listener, but I must be missing something. When I do the java -jar apex.war to start it up in standalone mode, I get the configuration properties etc., but when I open up my browser and try to bring up APEX with http://localhost:8080/apex/ I get a 500 - Internal Server error with the info below.
***********ERROR*********** init: # headers=43 declare nm owa.vc_arr := ?; vl owa.vc_arr := ?; begin owa.init_cgi_env( ?, nm, vl ); htp.init; htp.HTBUF_LEN := 63; ? := sys_context('USERENV','SID'); end; SID:880 CALL: begin apex; commit; end; BINDS PAGE CALL: declare nlns number := 999999; l_clob CLOB; lines htp.htbuf_arr; l_buff varchar2(32767); l_clob_init boolean:= false; l_file varchar2(5); l_doc_info varchar2(1000); begin OWA.GET_PAGE(lines, nlns); if (nlns > 1) then for i in 1..nlns loop if ( length(lines(i)) > 0 ) then if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then if (NOT l_clob_init) then dbms_lob.createtemporary(l_clob, TRUE); dbms_lob.open(l_clob, dbms_lob.lob_readwrite); l_clob_init:=true; end if; dbms_lob.writeappend(l_clob,length(l_buff),l_buff); l_buff := lines(i); else l_buff := l_buff || lines(i); end if; end if; end loop; end if; if (l_clob_init) then
[code]....
View 4 Replies
View Related
Oct 5, 2010
In statspack I find a lot of wait events "ARCH wait on SENDREQ". The database is configured with the LGWR ASYNC attribute. In the documentation I can read that the "ARCH wait"-events may happen in case the database is configured with the ARCH attribute.How is it possible I get these "ARCH wait"-envents and do these wait events have any effect on the "on line" performance of the database? Is it possible that a user that saves data in the database has to wait for thest "ARCH wait"-events?
View 1 Replies
View Related
Nov 27, 2012
I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My question is, if I need to restore Backup of last 15 days then I can ?.
View 4 Replies
View Related
Feb 20, 2012
I am familiar with tool Netca. However there is one more utility exist for the same functionatlty which is netmgrI checked with many DBAs for the exact difference, however I did not get the best answer from them. I also have checked in google but not exactly got the difference. list the exact difference between those 2 tools (netca, netmgr)
View 1 Replies
View Related
Nov 14, 2013
How can find the number of standby databases configured for primary database from os level
View 9 Replies
View Related
Nov 17, 2012
We have configured tivoli and getting the below error while execute rman backup.
> rman target / catalog rman/*****@CATLOGDB
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 17 13:35:03 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: AMTMXPRD (DBID=534215973)
connected to recovery catalog database
[code]....
View 6 Replies
View Related
Aug 21, 2013
We just upgraded from Application Express 4.0.2.00.07 to Application Express 4.2.2.00.11. We are using one common application to authenticate and redirect to other applications.
We use the following code:
wwv_flow_custom_auth_std.login( P_UNAME => :P101_USERNAME, P_PASSWORD => :P101_PASSWORD, P_SESSION_ID => v('APP_SESSION'), P_FLOW_PAGE => '2000:1' );
We start to get the following authentication error after the upgrade. There is no authentication configured for this application.
ORA-1403: no data found This is the same code we used from htmldb 2.x through Apex 4.0.2.00.07.
View 0 Replies
View Related