Re: Additional problems

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Mon, 13 Sep 2004 00:55:57 +0100
Message-ID: <newscache$fxcy3i$8kl$1_at_newsfront4.netvisao.pt>


Hi,
Is this a windows install ??
I didn't had any trouble like yours...

The tnsnames and listener from 9i is not a problem. It still the same.

If you want to install the java console (like in 9i) it's available on the companion CD (or client CD - i don't remember now).

To get things working you need :

  • the database started up -> check by connecting in sqlplus with sys/<password> as sysdba. Select status from v$isntance - if it's open then ok
  • the listener (optional) -> from the shell try: lnsrctl status
  • the dbconsole (to use EM database control - web based)

to connect to dbconsole use system or sys account (don't forget to use as sysdba if connecting with sys)

bye
pedro

William F. O'Neill wrote:
> Some additional problems have arisen. If I try to connect thru SQLPLUS, I
> get error #12500, and sometimes error # 12154. Again, am not a DBA. Just
> trying to get started with Oracle 10g. Have used Oracle 9i successfully at
> home with no problem. Am attempting to use Oracle 10g in standalone(not
> network enviornment).
> I noticed that the installation did not create a Listener.ora or a
> TNSNAMES.ora file, so I moved the old ones from Oracle 9i to the new home
> dir in Oracle10g. Could this be what's causing me the problems. If I use
> the web to attempt to get to EM, I keep getting an error message about
> incorrect password, and yet I did change the password at installation.
> Can't tell what the difference is between OS & HOST. Can anyone help me
> here? Finally, is going thru the web now the only way to use EM. I used to
> like the EM in Oracle 9i.....
>
> "William F. O'Neill" <wfoneill_at_bellsouth.net> wrote in message
> news:7CN%c.31243$Np2.23580_at_bignews4.bellsouth.net...
>

>>Have just upgraded my home installation of Oracle 10g.  Was using 9i.  The 
>>installation seemed to go fine, but with all the documentation, I'm having 
>>a hard time getting the Enterprise Manager to work.  With 9i, I had a 
>>shortcut like c:\oracle\ora90\bin\oemapp.bat console.  Can't find anything 
>>in the reams of documentation on how to start EM in Oracle 10g.  Any help 
>>please...Also, I am getting an error msg: Oracle_Sid needs to be defined. 
>>here do I do this.  Am not a DBA, and this version of Oracle is in 
>>standalone mode(not on a network).  Would appreciate any assistance here. 
>>Thank you....
>>

>
>
>
Received on Mon Sep 13 2004 - 01:55:57 CEST

Original text of this message