Showing posts with label Oracle Net. Show all posts
Showing posts with label Oracle Net. Show all posts
Tuesday, July 9, 2024

Stupid mistake that causes TNS-12533: TNS:illegal ADDRESS parameters during tns names resolution

›
Consider the following tnsnames.ora file: cdb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1.oric.no)(PORT = 1521)) ...
Wednesday, June 5, 2024

Some Oracle Net related terms and what they mean

›
The terms used in Oracle Networking can be very similar and somewhat confusing. Here is an attempt to explain some of them. What is a ne...
Friday, May 17, 2024

Easy Connect syntax

›
Basic syntax: sqlplus uid/pwd@//servername.domain.com:port_number/service_name If you do not specify port, 1521 is assumed. Example con...
Thursday, March 7, 2024

How to solve TNS-01194: The listener command did not arrive in a secure transport

›
On one of my servers running Oracle 19c with a container database and a PDB, I had trouble getting the services to automatically register t...
Wednesday, January 31, 2024

How come I cannot logon to my instance as sysdba, when the ORACLE_SID variable is set correctly?

›
Here's a reminder if you use a symbolic link for your ORACLE_HOME variable: You will not be able to attach to your instance using OS a...
Thursday, November 23, 2023

How to use strace to figure out what files are being accessed by a shell script

›
I had a situation where an ebs-supplied script adstrtal.sh would not start - it kept throwing error ORA-12541: TNS:no listener Although ...

Solution to ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

›
I had a situation where the error ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA was thrown when connecting to ...
Thursday, January 19, 2023

What is the ifile directive sometimes used in tnsnames.ora?

›
My customer is using Oracle E-Business Suite, and during a so-called "autoconfig", some files in the Oracle RDBMS home on the dat...
Friday, December 9, 2022

What does the UR = A in tnsnames.ora mean?

›
I recently had to connect remotely as sysdba to remote instances when I created Physical Standby Databases using RMAN. There were some som...
Wednesday, May 22, 2019

Deprecated security parameter in Oracle 12c: SEC_CASE_SENSITIVE_LOGON

›
Oracle states: "The use of the Oracle instance initialization parameter SEC_CASE_SENSITIVE_LOGON is deprecated in favor of setting t...
Wednesday, January 2, 2019

How to setup Oracle Network Integrity

›
Encryption will protect your data from being read in clear text, when in transition. However, data can still be tampered with and arrive ...
Thursday, October 18, 2018

What is the meaning of the "10G 11G 12C" value in DBA_USERS.PASSWORD_VERSIONS?

›
Since I wrote my post What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS? , Oracle 12c added yet another v...
5 comments:
Thursday, August 9, 2018

How to connect to a PDB using jdbc

›
Before you connect to a PDB using jdbc, make sure you have added the following to your database server's $TNS_ADMIN/listener.ora file: ...
Friday, April 13, 2018

A solution for ORA-28040

›
When connecting to Oracle 12c databases you may get ERROR: ORA-28040: No matching authentication protocol upon login. The error is de...
Thursday, February 4, 2016

How to create and start a service with dbms_service

›
Create the service. The first parameter name is the service name, can be up to 64 characters long. The second parameter is the network na...
3 comments:
Thursday, May 21, 2015

Valid formats for JDBC URLs

›
Format for JDBC URL with SID: •jdbc:oracle:thin:@host:1521:sid •jdbc:oracle:thin:user/password@host:1521:sid Format for JDBC URL with S...
Tuesday, March 24, 2015

How to use the nmap tool for Oracle networking troubleshooting

›
The Network exploration tool and security / port skanner (nmap) came in handy as I was checking the prerequisites for a Golden Gate installa...
Friday, January 23, 2015

What is the difference between a BEQUEATH connection and an IPC connection?

›
A bequeath connection runs on your local host bypasses the listener the protocol creates the server process for you directly An IPC (I...
1 comment:
Friday, May 23, 2014

How to set up a standard listener on port 1521

›
Recently I have seen cases where customers have defined multiple listeners in the $TNS_ADMIN/listener.ora file, but nontheless have started ...