пятница, 13 декабря 2013 г.

Создание БД (Oracle)

create-db.log:
13.12.13 19:06:45.633,main,DEBUG,DBConnectionPool,Closing of all free database connections
13.12.13 19:06:45.635,main,ERROR,CreateAzkInstance,
java.lang.RuntimeException: Exception creating database
at com.bssys.tools.sqlexecuter.CreateDatabase.create_database(CreateDatabase.java:127)
at com.bssys.tools.sqlexecuter.CreateDatabase.create_database(CreateDatabase.java:146)
at com.bssys.tools.sqlexecuter.Executer$7.process(Executer.java:126)
at com.bssys.tools.AbstractMain.process(AbstractMain.java:157)
at com.bssys.tools.sqlexecuter.Executer.process(Executer.java:246)
at com.bssys.tools.AbstractMain._process(AbstractMain.java:336)
at com.bssys.tools.AbstractMain.run(AbstractMain.java:374)
at com.bssys.tools.server.CreateInstance.createInstance(CreateInstance.java:97)
at com.bssys.tools.server.CreateInstance$1.process(CreateInstance.java:32)
at com.bssys.tools.AbstractMain.process(AbstractMain.java:157)
at com.bssys.tools.AbstractMain._process(AbstractMain.java:336)
at com.bssys.tools.AbstractMain._main(AbstractMain.java:453)
at com.bssys.tools.server.CreateAzkInstance.main(CreateAzkInstance.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.bssys.loader.MainRunner.run(MainRunner.java:18)
at com.bssys.loader.Runner.(Runner.java:30)
at com.bssys.loader.MainRunner.(MainRunner.java:14)
at com.bssys.loader.MainRunner.main(MainRunner.java:22)
Caused by: com.bssys.db.jdbc.DBSQLException: ORA-01031: привилегий недостаточно

at com.bssys.db.jdbc.SQLConnection.validate(SQLConnection.java:391)
at com.bssys.db.jdbc.SQLStatement.afterExecute(SQLStatement.java:27)
at com.bssys.db.jdbc.base.SQLStatementBase.execute(SQLStatementBase.java:57)
at com.bssys.tools.sqlexecuter.CreateDatabase.create_database(CreateDatabase.java:118)
... 20 more
Caused by: java.sql.SQLException: ORA-01031: привилегий недостаточно

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
at com.bssys.db.jdbc.base.SQLStatementBase.execute(SQLStatementBase.java:54)
... 21 more
------------------------------------------------------
Чтобы разрешить ситуацию нужно:
grant select on sys.v_$transaction to system with grant option;

Комментариев нет:

Архив