Project and Portfolio Management Practitioners Forum
cancel

INSTALL SP6-ERROR ORACLE

SOLVED
Go to solution
Highlighted
John_Alex
Regular 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
Trusted Contributor.

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
Regular 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
Super Contributor.
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
Regular 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