Re: Message 51 not found; product=RDBMS; facility=ORADIM in OraDim.log ?

Garp wrote:
> Unfortunately it seems that the following command of the script is not
> properply executed
>
> oradim -new -sid %ORACLE_SID%
>
> if not errorlevel 1 goto service_ok
> goto exit
> :service_ok

You don't indicate what 'not properly executed' means. Do you have ORACLE_SID defined and set as a system environment variable? Is 'oradim' in your PATH (eg, c:\oracle\ora81\bin). Do you have multiple oracle homes from installing various oracle software?

> sqlplus "/ as sysdba" @CreateDB_%ORACLE_SID%.sql >>%INSTALL_LOG%
>
> fails also and I can see that the connect fails in the script log
> ERROR:
> ORA-12154: TNS:could not resolve service name

Since it asked you for the username, I'm assuming you are not in the NT Administrator's group (which you need to be if you want to connect as SYSDBA without supplying a username/password - as indicated by '/' alone). The ORA-12154 means you don't have something setup correctly in your tnsnames.ora file.

> I assume that it tries to connect to the db but this is not up and
> running because the oradim aborted (no service - no db). I am right in
> this conclusion?

I think the command parser got confused at this point and thought the stuff following the '@' was a database alias. I'd be surprised if you had a db alias entry in your tnsnames for 'CreateDB_SID.sql'.

> The question for me is what cases the Message 51 not found (in general
> where can I look up error messages) and how can I solve it?

Windows doesn't have the 'oerr' utility - a quick, sometimes helpful, way to see what a particular error message is. If you have a unix box somewhere you can type 'oerr ora 12154' to find out what that error means (sort of).

You can also install the entire doc set on your pc from the install CD. Then you can look up errors any time in the Error Messages manual. Received on Wed Oct 09 2002 - 15:11:31 CDT