The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

INSTALL SP6-ERROR ORACLE

SOLVED
Go to solution
Highlighted
John_Alex
Occasional Contributor

INSTALL SP6-ERROR ORACLE

Good morning

I have a problem installing the patch sp6 to PPM 7.5

Now the error is:
ORA-01858 a non-numeric character was found where a numeric was expected

Please help me!!

Thanks
4 REPLIES
Manas Bagde
Super Collector

Re: INSTALL SP6-ERROR ORACLE

To deploy the service pack you just need to stop the ppm server then need to run below script from \bin directory.

sh ./kDeploy.sh -i SP6

After running above script, system will ask PPM admin user name and passwords (i think it will also ask ppm base schema user and and password).

Let me know whether you are following the same?

Regards,
Manas
John_Alex
Occasional Contributor

Re: INSTALL SP6-ERROR ORACLE

Good Morning

Thanks for your reply.

the PPM service is stopped and I use the command:

sh ./kDeploy.sh -i SP6

Then, I get into the DB password.
The installation begins, after a moment shows:

ORA-01858 a non-numeric character was found where a numeric was expected

and doesn't complete the installation

I have looking for the code ORA-01858 in the web and mentioned about problems with the date format.

I do not understand. Because currently I haven't entered any information or data.

thanks for the help you can give me.
Daniel Galvez
Collector
Solution

Re: INSTALL SP6-ERROR ORACLE

John,

Take a look for your regional settings... your server has to be configured with united states and also your bata base.

Regarads,
Daniel
John_Alex
Occasional Contributor

Re: INSTALL SP6-ERROR ORACLE

Daniel thank you very much, your answers have been very successful.

I followed your instructions and the problem was solved.

Thanks
//Add this to "OnDomLoad" event