How to configure Oracle traffic director for full site failover to have high availability?

I have two server system, each server having both apache tomcat server(deployed web app) and oracle 11g database server. The database on the two server is synchronised by oracle data gaurd for high availibility. tomcat Web servers is running individually on each server system with no load balancing. One server acts as primary server and other server acts as redundant server.

Usually for any failure on primary server, I have to manually change the IP/Domain name to access the other server.

I have came across Oracle Traffic director which may solve my isssue to switch any client request to redundant server in case of failure of primary server. Since I am new to oracle traffic director, can any one guide me to configure otd for full site failover?

How to reproduce “resource busy and acquire with NOWAIT specified or timeout expired ” error on local machine in oracle

I am running oracle database and I am getting error as "resource busy and acquire with NOWAIT specified or timeout expired " and because of this error i am getting some other exceptions. on my local machine I am not getting this "resource busy …" error. basically I want to reproduce this error on my local machine . is there any way to reproduce this error manually on my local machine?

Oracle 19c express manager not loading, listener will not register https port after exec dbms_xdb_config.gethttpsport()

We just set up a new oracle 19c install on a VM Windows Server 2020. I have been struggling trying to get the Express Manager working. At the end of the installation Oracle notified me that I can access the Express Manager at https://%localhost%:5500/em But upon visiting the website in chrome the connection is refused. I disabled the firewall and receive the same message. I went through the oracle documentation and ensured that dbms_xdb_config.gethttpsport() outputs 5500.

After running lsnrctl status I noticed that under listeners I am missing port 5500. I searched other users with the same issue they all have an entry for port 5500 like the following.

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=HOSTNAME.domain)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE\admin\ecoomdb\xdb_wallet))(Presentation=HTTP)(Session=RAW))     Services Summary...  

According to Oracle documentation when I run the command dbms_xdb_config.gethttpsport(5500) the listener should register the port. But after running the command muliple times this is not happening.

Oracle DB Clone and New IP

We clone our production to PTE (Production Test) once in a while and sanitize the data. As far as I’m aware, the DBA runs the clone command from PTE, this goes over 1Gb firewall and can take quite some time.

PTE is a VM, could I add a new NIC on the Production VLAN to the PTE host so it would copy bypassing the firewall? (Bypassing gives them 10Gb network). Any issues just adding a NIC to PTE without affecting the Oracle install, I don’t want anyone to connect on that temporary IP, just trying to speed things up.

Rewrite existing procedure without merge as Oracle 12.1 doesn’t support it

I have a procedure where data is pushed into table using merge logic used as part of it. The procedure takes string passed at runtime and splits it into rows.

I need to change the merge part using any other method other than merge, maybe cursor for loop as Oracle 12.1 does not support merge and similar take input string and insert/update accordingly in the destination table. inside procedure and we cannot get it upgraded due to constraints.

So everything in proc would be same just that it would be without merge.

The details are inside the fiddle with table and sample data.

https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=34a88972aa53cf60b1199f9f277285f4

Can a Battle Oracle take the Marshall dedication?

When an Oracle chooses the Battle mystery, they become trained in all martial weapons belonging to a chosen weapon group (e.g. Sword, Axe).

A requirement of the Marshall dedication is that the character is ‘trained in martial weapons’.

Is the Oracle therefore eligible to take the dedication, or would they first need to take the Weapon Proficiency general feat?

Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB

We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate.

  • We are using Oracle 12.c in our environment.
  • Clients are connecting using the jdbc thin driver

I am an Oracle noob and i am not able to understand the documentation here

Will it work if i create 2 listeners; one with SSL_CLIENT_AUTHENTICATION=TRUE and another with SSL_CLIENT_AUTHENTICATION=FALSE

Is it possible to attach oracle database file after clean install

I had an Oracle 10g instance on my Win2008R2 server. Unfortunately, the server crashed and we had to re-install the operating system on C: drive. The oracle files are on other drives except than C.

The other drives (except C) are restored from disk backups. I don’t have dump file, I only have oracle data files such as USERS01.DBF and the oracle control files.

Now I am trying to find a way to install oracle again on the server but I am just wondering about how I can attach the current .DBF files to the new oracle instance? Is this possible? If so, how can I attach the current .DBF files to Oracle?

Currently there is no "OracleService" on services.msc and no listener as well. But previos oracle was installed on F drive so I still have the oracle binaries and data files on F drive.

Really appreciate if you can provide any information on this.

How can I call a SQL Server stored procedure from Oracle and retrieve a scalar return value?

I’m developing a PL/SQL solution in Oracle Database Enterprise Edition 12.1.0.2. I’m calling stored procedures in Microsoft SQL Server 2014.

I am using DG4ODBC with the DBMS_HS_PASSTHROUGH package to call those stored procedures.

For stored procedures that return a tabular result set, I am able to use PARSE, FETCH_ROW, and GET_VALUE to retrieve the values. (My solution uses hard parsing, but it works for the volume we’re expecting. I’m open to tips if you know how I can use binds, but that’s not my question.)

DECLARE    sql_server_cursor_     BINARY_INTEGER;    sql_server_statement_  VARCHAR2(32767);    fetched_value_col1_    whatever_type_from_col1;    fetched_value_col2_    whatever_type_from_col2; BEGIN    sql_server_statement_ := 'EXEC "myDatabase"."dbo"."myProcedure" @p_one = N''' || sanitize__(my_argument_) || ''';';    sql_server_cursor_ := dbms_hs_passthrough.open_cursor@sql_server_link_;    dbms_hs_passthrough.parse@sql_server_link_(sql_server_cursor_, sql_server_statement_);    WHILE dbms_hs_passthrough.fetch_row@sql_server_link_(sql_server_cursor_) > 0    LOOP       dbms_hs_passthrough.get_value@sql_server_link_(sql_server_cursor_,  1, fetched_value_col1_);       dbms_hs_passthrough.get_value@sql_server_link_(sql_server_cursor_,  2, fetched_value_col2_);       dbms_output.put_line('fetched_value_col1_  ' || fetched_value_col1_);       dbms_output.put_line('fetched_value_col2_  ' || fetched_value_col2_);    END LOOP;    dbms_hs_passthrough.close_cursor@sql_server_link_(sql_server_cursor_); END; / 

I have a stored procedure in SQL Server that returns a scalar integer.

DECLARE @return_value int; EXEC @return_value = "myDatabase"."dbo"."myProcedure" @p_one = N'HelloWorld', @p_two = 42; SELECT @return_value; 

From Oracle, how would I call this procedure and retrieve that scalar value?