Today I faced this problem and overcome this problem after few analysis. I want to share the problem with you. With dbca I started to create database template and suddenly I noticed an error on my screen saying,
ORA-01722: invalid number
Then it stopped the operation . I tried again and same result. I search through log file and saw something interesting,
select member from v$logfile where group#='Elapsed: 00:00:00.01'
*
ERROR at line 1:
ORA-01722: invalid number
While creating template it failed one of first statement. It found ‘Elapsed: 00:00:00.01′ instead of a valid group number. It was happened beacuse in the user profile there was a profile (login.sql) and timi was set on. After query return timing was outputted and that result was used!. A great bug in Oracle but it is not yet reported in metalink.
Later I changed login.sql file to set timi off and everything goes ok.
Related Documents
http://arjudba.blogspot.com/2008/10/how-to-clone-database-on-same-host-with.html
http://arjudba.blogspot.com/2008/07/create-data-dictionary-in-oracle.html
No comments:
Post a Comment