I installed Oracle database 11g on Windows Server 2008 R2 Standard edition OS.
But I am not able to access the Oracle database from other machine through Oracle client.
Getting error like "ORA-12541: TNS:no listener".
But am able to connect to the database on the same machine. The listner is also running.
I am able to ping the machine but not able to tnsping the db due to the above error
Earlier It was mentioned that this is a firewall blocking the ports.
If I disable the firewall in the services also am getting the same problem. And to the machine itself I am not able to connect (take remote desktop).
Is there any otherway for this issue for the oracle client connectivity?
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…