Questions tagged [oracle-net-services]

Oracle Net Services is Oracle's networking framework. The most important component is Oracle Net (previously SQL*Net) which provides transaparent connectivity between the database and clients, or between databases (through database links).

10 questions
4
votes
2 answers

Is transfer via database link in Oracle 10g compressed ? Is it possible?

I'm transferring data from one base to another via database links (using INSERT INTO SELECT ...). I want to know if data transferred through the link is compressed or can be compressed to avoid too much network use. I have very little bandwidth, and…
Fredv
  • 552
  • 1
  • 8
  • 22
2
votes
0 answers

AWS Oracle RDS - Multiple port configuration

First of all apologies if my question is too silly. We have an AWS Oracle RDS which is listening on 1521 for plain text authentication and it is working fine. But we are trying to add an additional port (2484) for TCPS/SSL. We have enabled both tcp…
Sabbir Hassan
  • 175
  • 14
2
votes
1 answer

Oracle Database installation stuck at 'Starting Oracle Net Configuration Assistant'

I am installing Oracle database 12c (12.1.0.2.0 - Enterprise Edition ) in windows 10 and it stuck at "starting 'Oracle Net Configuration Assistant' " at step 8 of 9 (83%) for than 4 hours. Please suggest any solution to fix this problem. Here are…
2
votes
1 answer

Does Oracle compress/minimise some repeating data in query result during transferring through network?

Possible Duplicate: Oracle 10g : Is transfer via database link compressed ? is it possible? I have a huge SQL query with a lot of fields in it. Most of data in this result are duplicates of each selves. Here is part of SQL result for your…
kseen
  • 359
  • 8
  • 56
  • 104
0
votes
1 answer

How to fetch data from netsuite REST api with filter as lastModifiedDate in UTC format?

Submitting a query like q=lastModifiedDate ON_OR_AFTER "15/01/2021" works as expected, but a query like q=lastModifiedDate ON_OR_AFTER "2021-01-15T11:11:00Z" gives the 400 error
mohit singla
  • 151
  • 1
  • 1
  • 7
0
votes
1 answer

How to use expire_time parameter with the Node.js node-oracledb?

Sample Code try { const oracledb = require('oracledb'); const express = require('express'); const app = express(); // Memorized Connections var allDBSessions = {}; app.get('/', (req, res) => { const dbConfig = { …
Rabeesh
  • 31
  • 9
0
votes
1 answer

What happens if I setup only network encryption or network integrity in oracle net manager?

I am doing some POCs related to the oracle's network security and integrity feature. My sample program works just fine and returns me a valid connection even though I change the configuration to support either encryption or integrity. ``` …
0
votes
0 answers

Oracle 12C Database default Listener

I Have installed Oracle 12c r2 database software only on RHEL7 ( AWS EC2 instance). Then I created a database DB1 using DBCA. At the end of DBCA when it prompted for the listener I let it create the default 'LISTENER', Started the listener and the…
RKA
  • 221
  • 3
  • 14
0
votes
1 answer

oracle protocol adapter error.

cannot connect to the database. Tried all possible ways of restarting the listener,checking on the firewall of port 1521, Restarting the ORACLE SERVICE but the error still persists. For the first time after restarting the TNS listener tnsping …
0
votes
3 answers

TNS-12541 :TNS :no listener

I am newbie in oracle dba so need help that could meet my mind. I have installed my oracle 11gr2 database on virtual machine with OS OEL 5.7 and want to connect my this remote database with toad32bit. So i do follow some useful links and downloaded…
user3135152
  • 43
  • 2
  • 2
  • 5