Server Administration :: Error In Log File - Address Of Specified Listener Name Incorrect
Feb 4, 2011
I am having issue with configuring listner name on Oracle Server.My default listener is working,But I have stopped the default listener and tried to create another listener is differnt port,but no success,It always says The address of the specifed listener name is incorrect.Below is the listener.ora file
I installed 11.1.0.6. on Linux RedHat 5.5. Then upgraded to 11.1.0.7. However when I issue sqlplus /nolog and do select banner from v$version it shows 11.1.0.6. Although the install and upgrade were successful. I wonder why it does not show 11.1.0.7. I upgraded using the installer and not dbua could this be the reason why?
dbms_metadata is giving me code that will create more datafiles than the original, and furthermore won't run: firstly, because two files are named with a null string, and secondly because it includes RESIZE commands which won't work because they nominate OMF file names. Or is dbms_metadata unreliable?
I need to increase the size of shared pool for that i need to change the size of parameter sga_target and sga_max_size these are static parameter so that I need to change in spfile first then start instance then these parameter will get change. But when I create pfile from spfile it gives error:
ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3
trying to get oracle-xe-universal_10.2.0.1-1.0_i386.deb rolling on Debian/6.0.1a which coincidentally is on another server, not on my desktop, so I obviously can't reach the web frontend at 127.0.0.1:8080. And I couldn't trick it with a simple TCP proxy on the server:
nc -l -p 80 127.0.0.1 8080 and then on the client: telnet 192.168.0.252 80 bailed out with an error invalid connection to [192.168.0.252] from (UNKNOWN) [192.168.0.1] 35798
So, is there a way to change the listening IP address, or to allow IPs other than the local host to connect? I've tried some googling around,.
I was surprised when I shutdown our production dB. I got this error:
$ . oraenv ORACLE_SID = [abcd] ? SQL> shutdown ORA-01116: error in opening database file 26 ORA-01110: data file 26: '/VOL03/oradata/qxyz/data/qxyz_data01.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 SQL> shutdown abort ORACLE instance shut down.
2 days ago i rename this file QXYZ_DATA01.dbf from it's original name of QXYZ01.dbf without knowing that I was in the 'abcd' instance. When I backup a controlfile I noticed that it was part of the 'abcd' data files, so I just delete it (from OS level).
Is there any risk involved in the 'abcd' instance? How do I get rid of that file 'qxyz_data01.dbf' in the 'abcd' instance.
We are running Oracle 11.1.0.6 on CentOS Linux at our local network. Two dozen users work from client's network to access this database. There are firewall and switches between the local network and client network. Everything run smoothly for last two years until about 10 days ago, something changed. The client on the client's network can still connect to this database, but they can not run large queries. Their client connection hangs and time out. I can see TNS-12535: TNS:operation timed out and TNS-00505: Operation timed out in the alertlog file. They even had problem to load stored procedures and views onto TOAD from your PC. All the user on the local network can work on this database normally.
We consulted network team and firewall team, none of them said they make any changes recently and have no firewall rule or others to block the traffic.
I have a strong feel that this is a network related problem. But don't know how to provide solid evidence to make network people/firewall people to buy it.
You can connect to the database but can't run query on large table/view?
I have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.
I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report
From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....
in listener.ora, if i use localhost, or computer name, then everything is ok, but when i try to use ip address, then I got a error ORA-12541: TNS:no listener
the only change is use the ipaddress of the server 10.183.7.89 instead of localhost, and if I change the ip address to the computer name, then its also working well.
The server is running on visual box, i don't know if the vistual machine cause this problem, I just want to confirm: I can use the ip address directly right?
With just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?
I have a problem some user modified the objects and now objects became invalid .How to trace the ip address and operating system username and service ip who modified the objects?
Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.
i have a software...i installed it and configured it to the database now i copied the listener file from a working server to this both have same name and configuration and databases with same port number.
but when i try to log in it throws a error
ORA-12154 TNS COULD NOT RESOLVE THE CONNECT IDRNTIFIER SPECIFIED
I checked my listener tns.ora files and all are correct but still i cant connect.
1. Install patch 6613550 (./rootpre.sh) 2. Install 10.2.0.1 for AIX 64-bit 3. Install 10.2.0.5 Patch Set 4. Create Database 5. Created/Setup LISTENER and TNSNAMES (test connection successful)
After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:
TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner
What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start) The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)
BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:
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.
To one of my server i can see listener log are on normal location i.e. $ORACLE_HOME/network/log and on other server listener log is DIAG home. how to move listener log from ORACLE_HOME to DIAG_HOME.
oracle > lsnrctl status LISTENER LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:20:14 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for HPUX: Version 11.2.0.2.0 - Production Start Date 03-MAY-2012 08:09:57 Uptime 57 days 0 hr. 10 min. 16 sec [code]...
I am upgrading a DB using catupgrd.sql, and one of the prerequisites is to shut down the listener. Now, I have multiple database instances registered with this listener, and I don't want the other ones to become unavailable while I do the upgrade. Is there any way to do this for a particular instance only?
LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production Start Date 09-NOV-2012 19:55:06 Uptime 0 days 0 hr. 24 min. 26 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:oracleproduct11.2.0dbhome_1 etworkadminlistener.ora Listener Log File c:oraclediag nslsnrTESTQ51listeneralertlog.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NDCORCKSDQ51.global.loc)(PORT=1521))) Services Summary... Service "testdb" has 1 instance(s). Instance "ksdtest", status READY, has 1 handler(s) for this service... Service "testdbXDB" has 1 instance(s). Instance "testdb", status READY, has 1 handler(s) for this service... The command completed successfully
i am trying to rename the logfile "c:oraclediag nslsnrTESTQ51listeneralertlog.xml" to "c:oraclediag nslsnrTESTQ51listeneralert estdb.log"
so far i tried
LSNRCTL> set log_file testdb.log Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-01251: Cannot set trace/log directory under ADR LSNRCTL>
On last Saturday we encountered error 'TNS-12519: TNS:no appropriate service handler found" in our listener log for some moment of time let say around 5mins and later it got all right itself.
I need to display the parameter and status of DB for listener and Read Only.
I know those value could be get from command line , but could we get the values of Listener and Read only by SQL/PlSQL? So I can get it through the query of DB.
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 12 11:07:15 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ORA-12518: TNS:listener could not hand off client connection
Below is alertlog entry
Completed: alter database open Thu Apr 04 17:06:19 2013 db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this
i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i received errors
SQL> alter tablespace APPLSYSD READ ONLY; alter tablespace APPLSYSD READ ONLY * ERROR at line 1: ORA-01230: cannot make read only - file 636 is offline ORA-01111: name for data file 636 is unknown - rename to correct file ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636' i have not this file on the OS
