Pessoal,
Estou tentando executar uma migração do Liferay 6.0.6 para 6.1.1, estou usando o banco de dados (ORACLE) e aparace a seguinte mensagem:
115/11/2012 23:41:14 org.apache.catalina.startup.Catalina initDirs
2SEVERE: Cannot find specified temporary folder at C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp
315/11/2012 23:41:14 org.apache.catalina.core.AprLifecycleListener init
4INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\jre1.6.0_20\win\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;C:/Arquivos de programas/Java/jre6/lib/i386;C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\MySQL\MySQL Server 5.0\bin;C:\eclipse;
515/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
6INFO: Initializing ProtocolHandler ["http-bio-8080"]
715/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
8INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
915/11/2012 23:41:14 org.apache.catalina.startup.Catalina load
10INFO: Initialization processed in 917 ms
1115/11/2012 23:41:15 org.apache.catalina.core.StandardService startInternal
12INFO: Starting service Catalina
1315/11/2012 23:41:15 org.apache.catalina.core.StandardEngine startInternal
14INFO: Starting Servlet Engine: Apache Tomcat/7.0.27
1515/11/2012 23:41:15 org.apache.catalina.startup.HostConfig deployDescriptor
16INFO: Deploying configuration descriptor C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\conf\Catalina\localhost\ROOT.xml
17Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
18Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
19Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-ide.properties
20Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-developer.properties
21Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-setup-wizard.properties
22Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-ext.properties
2315/11/2012 23:41:18 org.apache.catalina.core.ApplicationContext log
24INFO: Initializing Spring root WebApplicationContext
2523:41:26,690 INFO [pool-2-thread-1][DialectDetector:71] Determine dialect for Oracle 10
2623:41:26,721 INFO [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
27Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / July 31, 2012)
2823:42:00,659 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
2923:42:00,971 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
3023:42:00,987 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
3123:42:07,393 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
3223:42:08,580 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
3323:42:10,268 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
3423:42:10,393 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
3523:42:15,315 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
3623:42:15,596 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
3723:42:17,299 INFO [pool-2-thread-1][Table:174] Starting backup of DLFileVersion to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-DLFileVersion-1353022937299
3823:42:17,330 INFO [pool-2-thread-1][Table:208] Finished backup of DLFileVersion to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-DLFileVersion-1353022937299 in 31 ms
3923:42:17,502 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
4023:42:17,518 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
4123:42:17,518 INFO [pool-2-thread-1][Table:174] Starting backup of Group_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Group_-1353022937518
4223:42:17,549 INFO [pool-2-thread-1][Table:208] Finished backup of Group_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Group_-1353022937518 in 31 ms
4323:42:18,002 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
4423:42:21,377 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal
4523:42:21,487 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
4623:42:26,737 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock
4723:42:26,737 INFO [pool-2-thread-1][Table:174] Starting backup of Lock_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Lock_-1353022946737
4823:42:26,737 INFO [pool-2-thread-1][Table:208] Finished backup of Lock_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Lock_-1353022946737 in 0 ms
4923:42:26,862 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
5023:43:06,455 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation
5123:43:06,487 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission
5223:43:07,377 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences
5323:43:12,002 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties
5423:43:12,315 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission
5523:43:12,330 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes
5623:43:12,362 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial
5723:43:12,721 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription
5823:43:12,737 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost
5923:43:12,784 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow
6023:43:12,799 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset
6123:43:12,862 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1
6223:43:12,862 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeSchema
6323:43:12,987 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeDocumentLibrary
6423:43:13,002 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayout
6523:43:13,018 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet
6623:43:13,018 INFO [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSetBranch
6723:43:13,424 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
6823:43:13,424 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
6923:43:13,424 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
7023:43:13,440 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
7123:43:13,455 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
7223:43:14,237 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
73
74com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
75
76 at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
77 at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
78 at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
79 at javax.servlet.GenericServlet.init(GenericServlet.java:160)
80 at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
81 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
82 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
83 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
84 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
85 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
86 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
87 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
88 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
89 at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
90 at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
91 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
92 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
93 at java.util.concurrent.FutureTask.run(FutureTask.java:138)
94 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
95 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
96 at java.lang.Thread.run(Thread.java:619)
97Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
98
99 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
100 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
101 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
102 at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
103 at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
104 at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
105 at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
106 at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
107 at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
108 ... 20 more
109Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
110
111 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
112 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
113 at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
114 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
115 ... 28 more
116Caused by: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
117
118 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
119 at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
120 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
121 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
122 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
123 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
124 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
125 at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
126 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
127 at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
128 at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
129 at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
130 at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
131 at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
132 at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
133 at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
134 at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
135 at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
136 at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
137 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
138 ... 31 more
139Stopping the server due to unexpected startup errors
Alguém pode me ajudar.
Obrigado,
Marcelo Melo