- Community Home
- >
- Networking
- >
- IMC
- >
- Re: IMC5.2 RHEL6.1 x64 Oracle Database Connecting ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-07-2013 11:51 AM - edited тАО03-07-2013 11:54 AM
тАО03-07-2013 11:51 AM - edited тАО03-07-2013 11:54 AM
I have an Oracle 11g R2 database Linux x64 based and cannot install IMC 5.2 as the "Checking Database Connectivity" screen rise the error "Connecting to the database failed" don't matter if tried through envcheck.sh or the install.sh.
I had activated the java tracing and got the error "java.sql.SQLSyntaxErrorException: ORA-01031 insufficient privileges".
I'm able to connect to the database, but the customer security policy does not permit that the user account on applications be the SYS or have all SYS privileges, there is a guide or table of what privileges are required or the only supported way to install is have all SYS privileges to database user account ?
TIA,
Felicio Santos.
PS: Sorry for any error of my "brazilian english".
Solved! Go to Solution.
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-07-2013 01:30 PM
тАО03-07-2013 01:30 PM
Re: IMC5.2 RHEL6.1 x64 Oracle Database Connecting Failed
I haven't set up IMC with Oracle, but I have done it a few times with SQL Server.
I'm guessing that the Oracle approach is similar to SQL Server, where IMC wants to set up and configure all the individual databases and users it needs.
What we generally do is give full access to IMC when it goes through the initial setup, and then drop the privileges on that account. For normal operation it doesn't need that access, as each db has a new, dedicated account associated with it.
When you deploy new modules, or upgrades, you will need to add those privileges back.
Unfortunately there is no easy way to manually set up the databases - you have to do it through IMC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2013 01:06 PM