Tag Archives: listener

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

I was practicing in virtual machines a hardware/OS upgrade for an Oracle 10G RAC and when I was starting up the database I got this error: SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00119: invalid specification for system … Continue reading

Posted in High-Availability, Linux/Unix, Oracle Server | Tagged , , , , , , | 8 Comments

Configure the transparent gateway to access a second SQL server database.

In a previous post I explained the parameters that I used when connecting Oracle to SQL Server, now I have received another request from the developers, they need to access tables from another database in the same server. These are … Continue reading

Posted in Oracle Server, Schema | Tagged , , , , , , , , , , , , | Leave a comment