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?
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?
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.
I’m currently using oracle xe c18. I can login using
sqlplus / AS SYSDBA as oracle user. However, the command does not work for other users. It always shows an error
ORA-01017: invalid username/password; logon denied. I already give SUID and GUID to all installation files. What’s the problem?
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.
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.
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?
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
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.
I’m developing a PL/SQL solution in Oracle Database Enterprise Edition 126.96.36.199. 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
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?