Re: Error in starting Oracle agent and ORA:01031 on SQLPLUS

Cherrish Vaidiyan wrote:
>
>
> SIR,
> I REQUEST YOUR PARDON FOR THOSE MY LINES.IT WAS BECAUSE I WAS I NEED
> OF IT BADLY.ORACLE DB IS WORKING PERFECTLY.AS I HAVE INSTALLED
> FOLLOWING THE INSTRUCTION GIVEN IN THE OREILLY WEB SITE. ORACLE WAS
> WORKING WELL AND GOOD WHEN I HAD TO CHANGE MY SYSTEM'S HARD DISK TO A
> BIGGER 60GB HDD. SINCE I CAN INSTALL ORACLE BY JUST COPYING THE
> ORACLE FOLDER IN LINUX. I DID THAT. I CREATED THE GROUP AND USER TO
> RUN ORACLE. I SET THE KERNEL PARAMETERS.I STARTED WORKING ON IT. THEN
> DUE TO YEAR END I DIDNT USE MY PC FOR A WEEK. NOW WHEN I START ORACLE
> AGENT I GET ERROR. THE SECOND ERROR I HAD MENTIONED EARLIER WAS THAT I
> COULDNT LOGIN AS SYS,SYSTEM OR ANY OTHER USER. I WAS GETTING ERROR
> ORA-01031 INSUFFICIENT PRIVILEGES.
> I CORRECTED IT BY DELETING THE EXISTING PASSWORD FILE AND RECREATED
> IT. NOW I CAN LOGIN AS SYS WITH SYSDBA PRIVILEGE. I CAN USE DB I HAD
> USED BEFORE...
You have an incorrect install. This may be due to an incomplete or incorrect copy. Oracle does not ONLY place it's information in the $ORACLE_HOME directory.

You do not seem to understand Oracle architecture. Doing so would ease your tension significantly.

>
> MY TENSION NOW IS WHAT ALL PROCESSES WILL BE AFFECTED BY ORACLE
> AGENT.?
> CAN I CORRECT THE ERROR BY ANY MEANS....? OR SHOULD I NEED TO
> UNINTSALL ORACLE AND INSTALL IT AGAIN?
YES. YOU SHOULD INSTALL AGAIN. YOU HAVE A SERIOUS PROBLEM WITH YOUR ENVIRONMENT. IT WOULD TAKE TOO LONG TO DEBUG YOUR ENVIRONMENT OVER THIS MEDIA. NOTE THAT THE AGENT IS ONLY USED FOR ENTERPRISE MANAGER INTERACTION AND WILL ONLY CAUSE YOU PROBLEMS WHEN YOU ARE TRYING TO DO SOMETHING THROUGH THE OEM.
>
> EXPECTING REPLY,
> CHERRISH VAIDIYAN
Please do not EXPECT anything from volunteers.

Please do not use UPPERCASE ONLY. That is generally interpreted as shouting and is considered very rude. Continuing to do so will decrease the chances that you will get the help you wish. Received on Fri Jan 02 2004 - 16:04:01 CET