jimmymac
Reputable Poster
We are on E1 9.0, tools 9.1.4.7. I have seen a previous post regarding this issue but it did not help so I am giving it another shot.
I did a fresh E1 fat client install on a new laptop about 6 months ago. This week, when I tried to start my fat client, I received an Unable to Connect to E1Local message and in the jde.log it shows E1Local password expired.
Using a couple of documents from Oracle on this topic, it states to modify the SQLNET AUTHENTICATION SERVICES to NTS, restart E1Local database. Then it states to enter SQLPLus from a command line with admin privileges. It shows to key in 'sqlplus / as sysdba', which should then give you a prompt SQL>.
However, we are getting an error 'ORA-12560: TNSrotocol adapter error' followed by a 'Enter user-name:' prompt.
If we were to get the SQL prompt, we then can run the steps to reset the profile password, but we are stuck with not being able to get into SQLPLUS.
Any ideas what to try or where to start looking. I am the administrator on this machine and when I start up cmd.exe I am choosing run as administrator. Not sure what else I am missing.
Thanks.
I did a fresh E1 fat client install on a new laptop about 6 months ago. This week, when I tried to start my fat client, I received an Unable to Connect to E1Local message and in the jde.log it shows E1Local password expired.
Using a couple of documents from Oracle on this topic, it states to modify the SQLNET AUTHENTICATION SERVICES to NTS, restart E1Local database. Then it states to enter SQLPLus from a command line with admin privileges. It shows to key in 'sqlplus / as sysdba', which should then give you a prompt SQL>.
However, we are getting an error 'ORA-12560: TNSrotocol adapter error' followed by a 'Enter user-name:' prompt.
If we were to get the SQL prompt, we then can run the steps to reset the profile password, but we are stuck with not being able to get into SQLPLUS.
Any ideas what to try or where to start looking. I am the administrator on this machine and when I start up cmd.exe I am choosing run as administrator. Not sure what else I am missing.
Thanks.