Re: Do not let me to login in sqlplus

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 24 Dec 2002 20:58:01 -0800
Message-ID: <3E093AD9.20B4AF6E_at_exesolutions.com>


skswati wrote:

> after successfull installation of oracle 8i enterprise on windows 2000
> server when i try to connect sqlplus it rejects the password note that
> it does not give any error during installation i tried scott/tiger
> system/manager but it do not let me connect to sqlplus
> can any body tellme installation steps of oracle enterprise edi and
> steps after installation (configration after installation)
> thanx
>
> --
> Posted via http://dbforums.com

No ORA-##### error message?

Anyway ... the first thing to do is go to the Oracle bin directory and type the following:

lsnrctl status

If the listener is started it will tell you for how long. If not you will get an error message you need to write down (in full).

Assuming it is running then log into Server manager

svrmgrl

then CONNECT INTERNAL at the server manager prompt

then type any reasonable SQL statement such as:

SELECT COUNT(*) FROM dba_tables;

Exit server manager with 'Exit'.

If you get any errors, once again, write the error number and message down (in full).

If the database is up and running (both listener and via server manager) then things get a bit more interesting. Let us know what you find.

Dan Morgan Received on Wed Dec 25 2002 - 05:58:01 CET

Original text of this message