Updating tnsnames ora is 22 too young to join online dating
I added the problem Service Name, then in Windows "Services" control panel, I did a "Restart" on the Oracle listener service. i had also faced same problem and spent 3 days to dig it out.This happens because of your wrong TNS service entry.ORA-01031: insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege.This error also occurs if attempting to install a database without the necessary operating system privileges.It took me a day of research, but I found the simplest solution, at least in my case (Oracle 11.2 on Windows 2008 R2) and wanted to share.The error, if looked at directly, indicates that the listener does not recognize the service name. In The "SID_LIST" is just that, a list of SIDs and service names paired up in a format you can copy or lookup. EZCONNECT eliminates the need for service name lookups in files when connecting to an Oracle database across a TCP/IP network.In fact, no naming or directory system is required when using this method as it provides out-of-the-box connectivity. The default is the host of the database server computer.
After your suggestion I checked the services and tried to start it manually also but it is not starting.
First check whether you are able to connect to standby database from primary database using sql sqlplus [email protected] as sysdba ( orastand is standby database) , if you are not able to connect then it is problem with service.