Above error seen while trying to install TSIM 10.7. Note that the installation log will not mention "insufficient privileges" at all, but there were a number of incidental Oracle errors, such as: "ORA_BPPM_022;ORACLE_CONNECTION_FAILED" "Failed to run the Oracle Install Schema Scripts" "ORA_BPPM_001;ORACLE_CONNECTION_FAILED" "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" |
If the error is seen while installing TSIM, uninstall TrueSight which will remove the schema: SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 29 00:25:25 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @create_pnet_user_with_grants.sql Please Enter the username..Ex. proact <Default proact>: Please Enter the password..Ex. proact <Default proact>: Enter value for 1: proact Enter value for 1: proact Please Enter the tablespace Name <Default proact>:PNET_TS Working on main user proact User proact already exists. Please Enter the report username..Ex. report <Default report>: Please Enter the report password..Ex. report <Default report>: Enter value for 1: report Enter value for 1: report Please Enter the tablespace Name <Default report>:PNET_TS Working on report user report Report User report already exists. Mandatory grants section started. ... .. . Mandatory grants section finished
Optional grants section started. ... .. . Optional grants section finished CREATE PROFILE proact_PROFILE LIMIT PASSWORD_LIFE_TIME UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED * ERROR at line 1: ORA-02379: profile PROACT_PROFILE already exists
Following roles assigned to proact are missing. ..... Following privileges are missing to role ..... Following roles are not granted. ..... Following privileges are missing. .....
Following default tablespaces are missing. .....
Please save the log created create_pnet_user_with_grants.log to a safe location. SQL> @OracleSchemaPreInstallCheck.sql Enter value for 1: proact Enter value for 2: report Enter value for 3: 10.7 .... Oracle specific log generation started ............. .... Oracle specific log generation completed ............. Please verify the oracle_specific_PreInstall_log.html generated in the same directory and correct missing parameters SQL> quit |