Grouper Users - Open Discussion List

[Eileen Roach <>]

I got it!

I had to modify the connect string to include the service_name.  For some reason, the SID does not work with our database.  In either case, I added the service_name in the connect_data section:

(CONNECT_DATA=(SERVICE_NAME=dev)

This is from the same machine.  It's interesting that it worked for the UI and not the gsh. 

Thanks for your help!

Sincerely,

Eileen 

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 Eileen Roach
 Programmer/Analyst, Identity Management Group
 California Polytechnic State University, San Luis Obispo
 Phone: (805)756-6214  
 E-mail: 

On 4/17/2011 7:54 PM, Chris Hyzer wrote:

I use Oracle with a similar connect string and it works fine…

 

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.school.edu)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=server2.school.edu)(PORT=1521)))(CONNECT_DATA=(SID=mysid)))

 

Do you have the same oracle jdbc driver on both?  Do you want to try to upgrade it to the latest?

 

Are you trying from the same machine (ui and gsh)? 

 

If you are using the same driver, with the same config string, from the same machine, and the difference is UI vs GSH, then there shouldn’t be a difference since those do a similar thing.  J

 

You probably know this, but the thing to google is “Io exception: NL Exception was generated”, there are a bunch of results, though I didn’t see any that help in this case J

 

Let me know if you make progress or not and maybe I can help more J

 

Thanks,

Chris

 

From: [] On Behalf Of Eileen Roach
Sent: Thursday, April 14, 2011 3:00 PM
To:
Subject: [grouper-users] Grouper API with Oracle RAC - hibernate.connection.url

 

We're having a problem configuring the value for the hibernate.connection.url for our Oracle 10g RAC database.  We can't get the grouper shell (gsh) to work with the RAC TNSNames value.  Grouper and the UI work, just not the shell.  Here's the error we get when starting the shell:

[mwadmin@s-grouper bin]# ./gsh.sh
Using GROUPER_HOME: /build/grouper/bin/..
Using GROUPER_CONF: /build/grouper/bin/../conf
Using JAVA: /deploy/Tools/jdk1.6.0_24/bin/java
using MEMORY: 64m-512m
Grouper starting up: version: 1.6.3, build date: 2011/01/03 01:44:08, env: CPDEV SANDBOX
grouper.properties read from: /build/grouper/conf/grouper.properties
Grouper current directory is: /build/grouper/bin
log4j.properties read from:   /build/grouper/conf/log4j.properties
Grouper is logging to file:   /build/grouper/bin/../logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
grouper.hibernate.properties: /build/grouper/conf/grouper.hibernate.properties
grouper.hibernate.properties: sbgroups@
sources.xml read from:        /build/grouper/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml jdbc source id:   cp-ent-users: GrouperJdbcConnectionProvider
sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
Grouper error: Error connecting to the database with credentials from grouper.hibernate.properties, url: , driver: oracle.jdbc.OracleDriver, user: sbgroups, java.sql.SQLException: Io exception: NL Exception was generated
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:363)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:468)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:839)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkDatabase(GrouperCheckConfig.java:705)
        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGrouperDb(GrouperCheckConfig.java:613)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:78)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

Couldnt startup grouper: null
java.lang.NullPointerException
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:83)
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:107)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.retrievePlatform(GrouperDdlUtils.java:207)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:334)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:261)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:83)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Exception in thread "main" java.lang.NullPointerException
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:83)
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:107)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.retrievePlatform(GrouperDdlUtils.java:207)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:334)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:261)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:83)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

I can get the shell to work if I specify just one node of the RAC database (hibernate.connection.url = "), but then neither Grouper nor the shell will work if node 1 is down. 

Any ideas?

Thanks,

Eileen

-- 

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 Eileen Roach

 Programmer/Analyst, Identity Management Group

 California Polytechnic State University, San Luis Obispo

 Phone: (805)756-6214  

 E-mail: