I have been trying to find the problem for 2 days and think it's time to ask someone else... My "TEST" database was set up, configured and I was able to log into the OEM. Now I can't do that... I am getting "Invalid Option for Alter Session" when I type in any login that I normally used before. I have de-installed OEM and components, and tried to reconfigure and still no luck. I have looked at the sqlnet, tnsnames, listener, and init files thinking I would find a problem... It looks ok to me. I have one instance named orcl... I have gone into the svrmgr and done the connect Internal... and granted sysdba and sysoper to system... still can't log in or start the service.
Do you have an OEM repository created? Do you have the management server up and running. Do you have the intelligent agent running? You have to have loged in as the administrator/oracle owner to alter these privileges. The option of sysdba/sysoper gets assigned automatically.
I have reloaded the OEM & Components. I deleted the orcl instance and created a new orcl instance. I went through the Net 8 Configuration processes. But When I try to create the repository, it gives me that same error :
ORA-00604 Error occured at recursive SQL Level 1
ORA-02248 Invalid Option for Alter Session
So It will not LET me create A Repository.
If I look in "Services" the OEM is "stopping" & I cannot start either the HTTP or the Management Server components... I get this message:
"Could not start the OracleOraHOme817Management Server on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error....
The Oracle Agent is started... I am logging into the machine with Administrator privileges... ???
I can set instance orcl in svrmgr. I can connect to SQL through internal, but not with system... If I try to go into SQLPlus with system it gives me the same 2 error messages.
This leads me to believe somehow I have created a permissions/login problem. I have been working on this all day today. I have created a os system user that has Admin privileges and is a member of Admin as well as ORA_DBA groups.
I will continue with this tomorrow... as I have not been able to get into the OEM.
If the ServiceOrcl in "Services" says started... does that mean that orcl is started and accessible? How else can I test it?
If you are able to login to oracle as sys then you can be sure that the oracle had started.
To be able to login to oracle as system, if you are trying to use the oracle's system default password, then it would be "manager" and not "change_on_install". You can change the system user's password as
SVRMGR> connect internal
SVRMGR> alter user system identified by your_password;
would connect you in.
To set up the OEM repository, you choose oracle enterprise manager configuration assistant. Before starting with that, make sure that all your tnsnames.ora files have been configured properly. Use "sys" as the username to "logon to the database as a user with DBA privileges."
I have tried what you suggested. I cannot connect as sys. I have changed the system password - and gone through the sentax per your response. When I tried to connect as system, I got the SAME 2 errors pertaining to alter session.
I wish I were more knowledgeable of SQL - I use mostly the OEM because I am new and like to use the interface better than the command line.
It just keeps coming back to the "Alter Session" problem. Even if I go into DBA Studio, and click on the orcl db there - I get the same message before even getting a login window... same 2 messages.
Unless you think there is some value I can glean from this... or others in the forum.... I am ready to blow it all away and start over. I can't imagine what I have done to screw up the database like this. I have wasted a week messing with it.
What would be the SQL statements to change the "Alter Session" settings? Any suggestions?