During the installaiton of CA IM v14.0 when i try to connect to Database, i keep getting "Unable to connect to Database with given information" and installation does not continue
Below are the env details
OS : RHEL 6.4
Database: oracle 12c
Service name: orcl.valcorp.com
Note: i am able to connect to DB using sql developer and Database is installed on the same system. so there no connectivity issues.
Validated the credentials they are all fine.
1) Does having periods in Service name is causing the installer to fail to connect to DB?
2) Where do the installation log files get generated? I checked the /tmp could not find any log files
3) If having periods in service name is an issue, any documented steps to modify service name. please share
What user are you attempting to connect to the database with for Identity Manager? Certain users will not work such as SYS. You need to use a different user with the correct permissions in order to connect to the database through the installer.
I created users (imobjectstoredb)with Connect,resource & create table permissions.
I don’t think this is a permission issue.
This issue is resolved after giving dba privileges to user.
grant dba to imobjectstoredb;
Due have added any parameters in sqlnet.ora file or done anything else or else it was just resolved by giving dba privileges .I am also facing the same issue and when i have started the IM installer in Debug mode it gives me "ORA-28040 no matching authentication protocol" error .Thanks Mohd Lari