-
I was installing OBIEE, and after going through the various processes. I have installed a database, Jdk, Web logic, BI, with no errors and now to configure OBIEE it shows me this error in the log.[......
-
i am using obiee 12c in production and Active Directory ldap server entegrated for authentication. almost all users are able to login analytics but few of these users cannot login. the following error ......
-
My database is an XE 18. My user has create user and I can create an user in SQL Plus, using this :ALTER SESSION SET "_ORACLE_SCRIPT" = true;CREATE USER auxiliar IDENTIFIED BY auxiliar2020 ......
-
My case is that:In Oracle DB, I have table (say table_a) with 2 columns only col_a and col_bThe number of columns is small, but with many rowscol_a is the primary keyNow, I need to add a new col (......
-
Hello,I am working in Service Bus (OSB) in jdeveloper 12c. When I configure the business service i want to give 2 end-point URIs. i will recieve request and need to sent in two url....
-
My instance of OSB is attempting to process a message from a JMS queue that doesn't exist - I believe this has already been processed and removed, but my current concern is the multiple failures each ......
-
I am trying to create the following table in Oracle.CREATE TABLE CUSTOMER(CUST_ID INT(10),CUST_NAME VARCHAR2(50),CUST_SEX CHAR(2),CUST_STATE VARCHAR2(50),CUST_COUNTRY VARCHAR2(50));I ......
-
CalendarCREATE TABLE CALENDAR( CalendarKey int NOT NULL PRIMARY KEY, Date DATE DEFAULT (SYSDATE), DayofWeek VARCHAR2(50) NOT NULL, DayofMonth VARCHAR2(50) NOT NULL, DayofYear ......
-
After starting the Node Manager when I'm going to start the startWeblogic.sh this happens and the server failed to start. (username, password is correct)Starting WLS with line:/home/app/oracle/java/......
-
I'm pulling some Oracle data into SQL Server using SSIS. The date/time value looks like this: 1601384402 .To convert it to something useful, I found this code somewhere:To_Char( To_Date( '01.01.......
-
I'm new to Kafka and I'm trying to connect with my Oracle DB, but none of the tutorials I found on the Internet works for me.For now I have working Kafka and Zookeeper, and my docker-compose file ......
-
I'm working on Oracle DB.Archive storage up to TB levels per day. I need to fix this.How to detect the expressions (dml + ddl) that cause the most change in the database?You can check with this ......
-
I am trying to read xml clob file with multiple namespaces. I am just literally out of ideas, spent few hours on this.My test case looks like:declare test_msg clob;begin test_msg := to_clob( ......
-
I write the following code in PL/SQL and it works:declare type deliveryStat_o IS record ( warehouseName varchar2(20), shipMode char(30), thirty_days number, sixty_days number, ......
-
As you know in TOAD, we can see where a table is used (in package or in view).But when i try to see where my table is used it is showing the error :ORA-01436: CONNECT BY loop in user data.Other ......