This content has been marked as final. Show 4 replies
Ok I think the problem is with the installation itself.I havent checked the spool file of ilma_install.
I found following errors in spool file
ORA-01017: invalid username/password; logon denied
Does anybody tried to execute this script on 11g ?
I have installed this correctly on my 11g Linux instance and it all works correctly.
To access the ILM Assistant I use this URL:
and login with either the user ILM or ILM_DEMO. The ILM_DEMO was created during the installation process and I manually added ILM afterwards following the steps in the documentation. One thing you need to watch out for is the passwords in 11g are now case sensitive and the error message you will get is:ORA-01741: illegal zero-length identifier
Hope this helps
Thanks for you immediate response.Well in my case the following script does not execute successfully.
Here is the output of @ilma_install.sql pune@11 users none.
ORA-12154: TNS:could not resolve the connect identifier specified
There are two wats to install the ILM toolkit:
1) Directly on the server where your instance is located. In this case you do not need to provide a TNS connection name. Therefore, you would execute the script as follows:
2) Remotely from a client. In this case you do need to provide a connection string to your remote database instance. Therefore, you would execute the script as follows:
in this scenario the connection details are derived from your TNSNAMES.ORA file. If you have multiple Oracle products installed you have multiple copies of this file and it can be difficult to track down which file is being used. To point to a specific TNSNAMES.ORA I normally set three parameters:
ORACLE_HOME - points to your 11g Client installation directory
PATH - point this to the Oracle home containing SQLPlus, usually this is ORACLE_HOME/bin
TNS_ADMIN = ORACLE_HOME/network/admin
then make sure the TNSNAMES.ORA contains a reference to your identifier "11". You can test the connection by using the TNSPING utility that is part of the 11g client installation. The format for your instance would be:
this will tell you if you can connect to your instance. If there are any issues check the connection via the Net Configuration Assistant, or you can edit the TNSNAMES.ORA file directly via Notepad.
Hope this helps