Hot answers tagged

10

So, with thanks to @YasirArsanukaev for the time he put in, I have found a solution which works, but which I can't really explain. Riffing on the LOCAL_LISTENER thought, I was reading this other answer where it said: The database uses the LOCAL_LISTENER parameter to identify the listener it should register with. By default that is null, which ...


9

Bit late to the party on this one... The database should register with the listener automatically, making the SID_LIST entries redundant, and this seems to be happening with your 192.168.111.111 environment. If the listener is started after the database it can take a while for it to register, and there may be situations where it doesn't do so at all. You ...


4

It's signalling a 'ORA-214' during instance startup, which is really bad. $ oerr ORA 214 00214, 00000, "control file '%s' version %s inconsistent with file '%s' version %s" // *Cause: An inconsistent set of control files, datafiles/logfiles, and redo // files was used. // *Action: Use a consistant set of control files, datafiles/logfiles, and redo ...


4

Run: lsnrctl status LISTENERNAME ... where LISTENERNAME is the name of the listener that is listening on port 1531. You can get this name from your $ORACLE_HOME/network/admin/listener.ora file. For example: LISTENER1531 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1531)) ...


4

@mbonaci sqlplus / as sysdba then issue command startup; to start the database Also on Linux with this error, you can check first if Oracle background processes are up with ps aux | grep pmon. Pmon is process monitor, or check some other background process. If they are not running then the database is not running.


3

Try this: COTT3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = COTT3) ) ) If that doesn't work, replace "SERVICE_NAME" with "SID". Put this in $ORACLE_HOME/network/admin/listener.ora: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = ...


3

First, thanks for the response. I'm working on a Mac, and the instant client doesn't include the tnsping utility. I had tried to login, from the remote computer, and that is where I got the TNS:no listener error. Logging in on the server is fine. I had tried the telnet test before, but as I did not have telnet installed and running on the server, that ...


3

The description for the message you're seeing is: Cause: Most of the listener administrative commands are only intended to be issued by privileged users, for example DBAs or system administrators. If the listener password is not set, then the listener only accepts administrative requests from LSNRCTL running with the same OS credentials, or ...


2

This is the default behaviour. As long as you don't have the default service in your tns_aliasses that are in use it should not be a problem.


2

dbstart will only start databases that have the third parameter in the oratab file set to Y. Check the value in that file. You also don't need to pass the ORACLE_HOME as an argument; not sure if you actually meant to pass the SID, but anyway, the home is taken from the oratab too. The script itself says that it should only be executed as part of the system ...


2

My sequence of steps for troubleshooting Is the listener resolvable? C:\>tnsping MYDB (Confirms: the database listener is running on serverside) Is there a firewall issue? C:\>telnet hostname 1521 Can I login? C:\>sqlplus system/pass@MYDB or C:\>sqlplus system/pass@hostname:1521/MYDB (Confirms: The database is open) Finally, chances of having ...


2

To me it looks like you did not start the listener but it is started. Your problem seems to be the tcp connection and not the ipc. So the listener is running, you can not reach it using tcp. Test this using telnet gaurav 1521 If the telnet does not give a connection, a firewall is blocking you. Stop/edit the firewall.


2

I do not have any clear explanation for this problem solution. However I used SID instead of service name in connection string and it worked. Edit: A service name is more flexible than a SID would be. A database can dynamically register with a listener using one or more service names. In fact, more than one database can register with a listener using the ...


2

I don't have an answer to your entire question (though I gave an answer to a similar question today http://dba.stackexchange.com/a/137844/36812) but you mentioned that using ApplicationIntent=ReadOnly doesn't work properly. Have you set up read only routing URLs? Because it's not done out of the box and if you don't do it then these settings and that flag ...


2

I found this. It basically says: For Windows goto command prompt and type lsnrctl and hit enter LSNRCTL> SET LOG_DIRECTORY X:/oracle/admin/ LSNRCTL> SET LOG_FILE XXXX.log For linux or unix connect as oracle user and then type lsnrctl and hit enter LSNRCTL> SET LOG_DIRECTORY /XXX/oracle/admin LSNRCTL> SET LOG_FILE XXXx.log ...


2

The way I try to explain it to people is that the listener leverages the Windows Failover Cluster for its functionality; you cannot create the listener without the cluster already existing as the cluster itself creates the listener. As such, it is Active Directory (AD) that hosts it and the nodes that use the cluster can use any services that cluster has, in ...


2

There is no way to complete this with just SQL Server and the interfaces it exposes. In order to do this you'll either need an appliance between the clients and SQL Server (the users connect to the appliance endpoint and the appliance does the redirection) or you can implement your own through a cname and some type of configurable load balancer like an F5. ...


1

ADRCI deletes the XML files, but not the plain text logs, which is a nuisance. An easy but dirty solution would be overwriting the file with empty content, e.g: $ cat /dev/null > listener.log Deleting the file while the listener is running and logging is enabled may not lead to the expected result because of the file handling implementation on ...


1

Ste, what you are wanting is a point and click solution or a setting somewhere. Unfortunately, none of these currently exist in "off the shelf" form. It would be realllly nice if Microsoft included this in the connection settings for a Registered Server so it could be saved, but alas they do not. This leaves you with one of two options: Write Something ...


1

11g Oracle recommends that we configure the EXTPROC by altering the extproc.ora file rather than configure the listener for Oracle 11g. The extproc.ora file is located in the ORACLE_HOME\hs\admin directory.


1

Here's an answer from an Oracle Employee on Oracle Community: "The problem is when the default page size is set to A4, which translates into points with decimals when rendering the PDF. Please, change the Units to Points, and round up your page width and height." Reference: https://community.oracle.com/message/1793888


1

The listener is an independent entity, can run from a different Oracle Home or even another machine. All the database knows about it is its address.


1

TNS Ping does not care about service or SID, all it checks is the availability of the listener, so this does not mean your connection string is correct. Connecting through SQL*Plus successfully however confirms it. Your tnsnames.ora uses SERVICE_NAME in CONNECT_DATA, but your JDBC URL uses the SID syntax. SID and service name are different concepts, and ...


1

Use the parameter NAMES.DEFAULT_DOMAIN to set the domain from which the client most often looks up names resolution requests. When this parameter is set, the default domain name is automatically appended to any unqualified net service name or service name. For example, if the default domain is set to us.acme.com, the connect string CONNECT scott/tiger@sales ...


1

On Unix: Oracle is multi-process database. It does not use threads (on the contrary to other databases). Some of the processes are background ones (Oracle internal) the other ones are user sessions processes. They all communicate via IPC (messages, shared ram). When user opens a TCP connection to listener, the listener process forks and then executes(exec) ...


1

There doesn't appear to be a problem. The listener is a process that generally runs on the database server, not on the client machine. Doing a client-only install will not install a listener. If you want to have a listener on your machine, you'd need to do a database install (though you can do a software-only install rather than actually creating a ...


1

The documentation explains how to go about configuring listener tracing, but in summary: Add: TRACE_FILE_<LISTENERNAME>=listener.log TRACE_DIRECTORY_<LISTERNAME>=/path_to_your_log_directory TRACE_LEVEL_<LISTENERNAME>=user You can up the TRACE_LEVEL to admin or support if you need more information, but be aware that they generate ...


1

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) You have the localhost ip in the listener.ora (127.0.0.1), change this or add another line with the NIC ip.


1

There are a few problems. given the fact that you specified local_listener, you want your database instance to register to a non default listener for which the tnsalias should be LISTENER_OTRS the tnsalias LISTENER_OTRS is missing the tnsalias otrs is misformed (it has multiple addresses but not the ADDRESS_LIST parameter (in this case, the last piece ...


1

As Phil Says I replaced hostname with Actual IP but the connection prblem was for (PROGRAM = extproc) In listener.ora file, Removing it solved the issue. To let external procedures work these changes should be done: Adding new SID entry in SID_LIST_LISTENER SID_LIST with SID_NAME = SID in tnsnames.ora at EXTPROC_CONNECTION_DATA and PROGRAM = extproc ...



Only top voted, non community-wiki answers of a minimum length are eligible