Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Not able to configure reporsitory and create a project in Oracle SQL Developer 19.1 Data Mining opti

While configuring Oracle SQL Developer 19.1 and Oracle 18c for data Mining I am facing a small difficulty which stopping me from making further progress.
After adding dmuser(I have set dmuser correctly as per instructions in manual) and right click to create project. I will be getting below screen to log in with SYS user
[This database does not have the Data Miner repository installed.
Would you like to install the repository?
You will be prompted to authenticate as a database administrator to perform this task.]
When I click on Yes then It will ask for keying SYS password. When I provide correct password for SYS user
ORA-01017: invalid username/password; logon denied
I am not sure in spite of giving correct user why it is showing invalid username. I need some guidance on this how to proceed or if I am making any mistake.
Answers
-
Have the same issue, although I do not have SYS password for my ADW database, I tried to specify ADMIN/<MYADMINPASSWORD> and got the same ORA-01017.
Besides that, I tried to install Data Mining repo on my local 19c database using SQL Developer 20.2, in this case, it accepted SYS password but showed an error message that my database does not have Text and XMLDB installed. In fact, using some related instructions about checking the status of Text and XMLDB, I found both installed.
-
Invoking installation from the command line on behalf ADMIN database user
SQL> @installodmr data temp
produces the following error
ORA-20000: Oracle XMLDB feature required by Data Miner is not installed.
Please install the Oracle XMLDB feature, or see your database administrator for assistance.
ORA-06512: at line 35
Indeed, the script checks
DECLARE
CURSOR c_comps IS
SELECT COMP_ID, STATUS FROM DBA_REGISTRY WHERE COMP_ID IN ('XDB','CONTEXT');
v_comp DBA_REGISTRY.COMP_ID%TYPE := '';
v_status DBA_REGISTRY.STATUS%TYPE := '';
v_xdb BOOLEAN := FALSE;
v_text BOOLEAN := FALSE;
BEGIN
OPEN c_comps;
LOOP
FETCH c_comps INTO v_comp, v_status;
EXIT WHEN c_comps%NOTFOUND;
IF( v_comp = 'XDB' AND v_status = 'VALID') THEN
v_xdb := TRUE;
ELSIF ( v_comp = 'CONTEXT' AND v_status = 'VALID') THEN
v_text := TRUE;
END IF;
END LOOP;
My ADW shows "CONTEXT" only
-
My local database has STATUS='UPGRADED' for the 'XDB' and 'CONTEXT', so after changing sqldeveloper/dataminer/scripts/checkEnvironment.sql correspondently, the repository has been installed (from the command line) and seems intact, at least I can create a new project in the Data Miner window and go forward exploring.
-
Oracle Data Miner tool in SQL Dev doesn't work with ADW