Re: Additional problems
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)
- from the shell: emctl status dbconsole or simply http://host:7777/em
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