Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Show error about 'ORA-08181: specified number is not a valid system change number' when using 'scn_t

Quanwen ZhaoAug 29 2017 — edited Oct 1 2017

Hello,

My oracle environment is DataGuard 11.2.0.1.0 on physical standby,when i use SQL query below,

SYS@standby> col current_scn for 9999999999999999

SYS@standby> select scn_to_timestamp(current_scn) from v$database;

select scn_to_timestamp(current_scn) from v$database

       *

ERROR at line 1:

ORA-08181: specified number is not a valid system change number

ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1

and if not using function 'scn_to_timestamp' is OK,

SYS@standby> select current_scn from v$database;

            CURRENT_SCN

-----------------------

            12204021200

Why is it ? Please give me some suggestions,thanks!

Best Regards

Quanwen Zhao
This post has been answered by Quanwen Zhao on Sep 7 2017
Jump to Answer

Comments

843841
http://tomcat.apache.org/tomcat-5.5-doc/appdev/deployment.html

1: web-inf needs to capitalized as WEB-INF

2: The compiled class file for MyServlet should be under WEB-INF/classes/servlets

3: The web.xml reference to the MyServlet class file should be:

<servlet-class>servlets.MyServlet</servlet-class>
843841
yes I have the web-inf capitalized. But I believe that in the
web.xml we can use the slash syntax 
<servlet-class>servlets/MyServlet</servlet-class>
I have use it in the past with success.
Nevertheless thank you for your answer but you haven't replied to the basic one?
It is allowed to place web-inf inside another folder right?such as folder web?
843841
Well did you read the tomcat documentation on web application directory structure in the link?
843841
Yes I've read it and all I am saying is that in previous applications I used the slash syntax and I think it worked.But that is not my problem here.All I am asking is why when I removed the web folder and the root folder below webapps was WEB-INF then the application worked.What was I doing wrong(if it was just the slashes it would not work in any case).
843841
http://www.roguewave.com/support/docs/leif/leif/html/servletug/7-7.html#771

http://www.coreservlets.com/Apache-Tomcat-Tutorial/

http://www.onjava.com/pub/a/onjava/2001/03/15/tomcat.html

http://www.tek271.com/articles/deploying_servlets_on_tomcat.html

http://www.onjava.com/pub/a/onjava/2001/04/19/tomcat.html?page=4

Every example listed uses a period delimited class name. Not one mentions being able to use a slash deliminted class name.
843841
Ok I do not disagree but my initial question was if it is ok to use a folder where WEB-INF is stored.Because in my example when I enclosed folder WEB-INF in folder web I had the forementioned problem when I removed folder web and the folder WEB-INF was in the root of the folder webapps of Tomcat things were ok.And so I am asking why this was happening??Forget about the slalshes I accept that slashes is the correct way for web.xml.
843841
The WEB-INF folder has to directly under the web application root directory. Any other WEB-INF folders will be ignored.
843841
Ok thank you very much for your help.
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 5 2017
Added on Aug 29 2017
#data-guard, #performance-availability
10 comments
17,254 views