oracle 11g dump file 导入 oracle 12c 后 表或者视图不存在

[lygccc]

oracle 11g dump file 导入 oracle 12c 后,
从客户端用Sqlplus能够正常访问和操作,用普通用户和system用户利用jdbc去连接的话,报 表或者视图不存在的错误.
各位有没有遇到过,要怎样解决.谢谢!很急!

[惜分飞]

信息太少，无法诊断

[lygccc]

谢谢,下面是错误的log,可能是什么问题? 02 22 09:58:08 org.seasar.framework.container.factory.SingletonS2ContainerFactory [INFO ] Running on [ENV]product, [DEPLOY MODE]Cool Deploy 02 22 09:58:08 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN org.seasar.chronos.core.impl.SchedulerImpl#start() 02 22 09:58:08 org.seasar.chronos.core.impl.AbstractScheduler [DEBUG] スケジューラ を 開始します． 02 22 09:58:08 org.seasar.chronos.core.impl.AbstractScheduler [DEBUG] スケジューラ を 開始しました． 02 22 09:58:08 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] END org.seasar.chronos.core.impl.SchedulerImpl#start() : null 02 22 09:58:45 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN jp.dpdm.mhir.action.admin.IndexAction#index() 02 22 09:58:45 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションを開始しました。tx=[FormatId=4360, GlobalId=1456102725751/0, BranchId=] 02 22 09:58:45 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションをロールバックしました。tx=[FormatId=4360, GlobalId=1456102725751/0, BranchId=] 02 22 09:58:45 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] END jp.dpdm.mhir.action.admin.IndexAction#index() Throwable:jp.dpdm.mhir.util.NotLoginException 02 22 09:58:45 jp.dpdm.mhir.util.AdminExceptionFilter [DEBUG] NotLoginExceptionが発生しました。 02 22 09:58:48 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN jp.dpdm.mhir.action.admin.IndexAction#index() 02 22 09:58:48 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションを開始しました。tx=[FormatId=4360, GlobalId=1456102725751/1, BranchId=] 02 22 09:58:48 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションをロールバックしました。tx=[FormatId=4360, GlobalId=1456102725751/1, BranchId=] 02 22 09:58:48 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] END jp.dpdm.mhir.action.admin.IndexAction#index() Throwable:jp.dpdm.mhir.util.NotLoginException 02 22 09:58:48 jp.dpdm.mhir.util.AdminExceptionFilter [DEBUG] NotLoginExceptionが発生しました。 02 22 09:59:28 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN jp.dpdm.mhir.action.LoginAction#index() 02 22 09:59:28 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションを開始しました。tx=[FormatId=4360, GlobalId=1456102725751/2, BranchId=] 02 22 09:59:28 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションをコミットしました。tx=[FormatId=4360, GlobalId=1456102725751/2, BranchId=] 02 22 09:59:28 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] END jp.dpdm.mhir.action.LoginAction#index() : login.jsp 02 22 10:00:29 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN jp.dpdm.mhir.action.LoginAction#login() 02 22 10:00:29 org.seasar.extension.jta.TransactionImpl [DEBUG] トランザクションを開始しました。tx=[FormatId=4360, GlobalId=1456102725751/3, BranchId=] 02 22 10:00:29 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] BEGIN jp.dpdm.mhir.service.UserService#getUser(MhirKanri) 02 22 10:00:29 org.seasar.extension.jdbc.query.AutoSelectImpl [DEBUG] select T1_.ID as C1_, T1_.NAME as C2_, T1_.EMAIL as C3_, T1_.EMP_ID as C4_, T1_.ENC_PASSWD as C5_, T1_.ROLE_KANTOKU as C6_, T1_.ROLE_KANRI as C7_, T1_.ROLE_SOUSA as C8_, T1_.ROLE_SHOUNIN as C9_, T1_.ROLE_KOJINJOUHOU as C10_, T1_.ROLE_SANSHOU as C11_, T1_.PW_UPDATE_DATE as C12_, T1_.LAST_LOGIN_DATE as C13_, T1_.STATUS as C14_, T1_.VERSION_NO as C15_, T1_.UPDATE_DATE as C16_, T1_.CREATE_DATE as C17_ from IR_USER T1_ where (T1_.EMP_ID = 'MhirKanri') 02 22 10:00:32 org.seasar.extension.dbcp.impl.ConnectionPoolImpl [DEBUG] 物理的なコネクションを取得しました 02 22 10:00:32 org.seasar.extension.dbcp.impl.ConnectionPoolImpl [DEBUG] 論理的なコネクションを取得しました。tx=[FormatId=4360, GlobalId=1456102725751/3, BranchId=] 02 22 10:00:32 org.seasar.extension.dbcp.impl.ConnectionWrapperImpl [DEBUG] 物理的なコネクションを閉じました 02 22 10:00:32 org.seasar.framework.aop.interceptors.TraceInterceptor [DEBUG] END jp.dpdm.mhir.service.UserService#getUser(MhirKanri) Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[select T1_.ID as C1_, T1_.NAME as C2_, T1_.EMAIL as C3_, T1_.EMP_ID as C4_, T1_.ENC_PASSWD as C5_, T1_.ROLE_KANTOKU as C6_, T1_.ROLE_KANRI as C7_, T1_.ROLE_SOUSA as C8_, T1_.ROLE_SHOUNIN as C9_, T1_.ROLE_KOJINJOUHOU as C10_, T1_.ROLE_SANSHOU as C11_, T1_.PW_UPDATE_DATE as C12_, T1_.LAST_LOGIN_DATE as C13_, T1_.STATUS as C14_, T1_.VERSION_NO as C15_, T1_.UPDATE_DATE as C16_, T1_.CREATE_DATE as C17_ from IR_USER T1_ where (T1_.EMP_ID = ?)], Message=[[ESSR0072]SQLで例外(SQL=[select T1_.ID as C1_, T1_.NAME as C2_, T1_.EMAIL as C3_, T1_.EMP_ID as C4_, T1_.ENC_PASSWD as C5_, T1_.ROLE_KANTOKU as C6_, T1_.ROLE_KANRI as C7_, T1_.ROLE_SOUSA as C8_, T1_.ROLE_SHOUNIN as C9_, T1_.ROLE_KOJINJOUHOU as C10_, T1_.ROLE_SANSHOU as C11_, T1_.PW_UPDATE_DATE as C12_, T1_.LAST_LOGIN_DATE as C13_, T1_.STATUS as C14_, T1_.VERSION_NO as C15_, T1_.UPDATE_DATE as C16_, T1_.CREATE_DATE as C17_ from IR_USER T1_ where (T1_.EMP_ID = ?)], Message=[表またはビュー 'IR_USER' は存在しません。], ErrorCode=-1, SQLState=42X05)が発生しました : [SQLで例外(Message=[表またはビュー 'IR_USER' は存在しません。], ErrorCode=-1, SQLState=42X05)が発生しました。], [表またはビュー 'IR_USER' は存在しません。], [表またはビュー 'IR_USER' は存在しません。], ErrorCode=-1, SQLState=42X05)が発生しました 02 22 10:00:32 org.seasar.extension.jta.TransactionImpl [ERROR] [ESSR0017]例外が発生しました。理由はjava.sql.SQLException: Connection closed org.seasar.framework.exception.SXAException: [ESSR0017]例外が発生しました。理由はjava.sql.SQLException: Connection closed at org.seasar.extension.dbcp.impl.DBXAResourceImpl.doRollback(DBXAResourceImpl.java:87) at org.seasar.extension.jta.xa.AbstractXAResource.rollback(AbstractXAResource.java:267) at org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:136) at org.seasar.extension.jta.XAResourceWrapper.rollback(XAResourceWrapper.java:76) at org.seasar.extension.jta.TransactionImpl.rollbackResources(TransactionImpl.java:416) at org.seasar.extension.jta.TransactionImpl.rollback(TransactionImpl.java:390) at org.seasar.extension.jta.AbstractTransactionManagerImpl.rollback(AbstractTransactionManagerImpl.java:106) at org.seasar.extension.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:64) at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.end(JTATransactionManagerAdapter.java:175) at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:68) at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50) at jp.dpdm.mhir.action.LoginAction$$EnhancedByS2AOP$$65880400$$MethodInvocation$$login1.proceed(MethodInvocationClassGenerator.java) at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73) at jp.dpdm.mhir.action.LoginAction$$EnhancedByS2AOP$$65880400$$MethodInvocation$$login1.proceed(MethodInvocationClassGenerator.java) at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79) at jp.dpdm.mhir.action.LoginAction$$EnhancedByS2AOP$$65880400$$MethodInvocation$$login1.proceed(MethodInvocationClassGenerator.java) at jp.dpdm.mhir.action.LoginAction$$EnhancedByS2AOP$$65880400.login(LoginAction$$EnhancedByS2AOP$$65880400.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96) at org.seasar.struts.action.ActionWrapper.execute(ActionWrapper.java:139) at org.seasar.struts.action.ActionWrapper.execute(ActionWrapper.java:87) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.seasar.struts.action.S2RequestProcessor.process(S2RequestProcessor.java:132) ............... at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:354) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:260) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:188) at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:191) at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:168) at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:189) at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119) at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:288) at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:206) at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:136) at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:114) at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77) at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:838) at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:113) at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:115) at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:55) at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:135) at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564) at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Connection closed at com.sun.gjc.spi.base.ConnectionHolder.checkValidity(ConnectionHolder.java:766) at com.sun.gjc.spi.base.ConnectionHolder.rollback(ConnectionHolder.java:665) at org.seasar.extension.dbcp.impl.DBXAResourceImpl.doRollback(DBXAResourceImpl.java:84) ... 88 more