No question at this time
DBA Top 10
1 M. Cadot 11600
2 B. Vroman 6400
3 A. Kavsek 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. Péran 1800
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48560
Total active users1401
Act. users last 24h3
Act. users last hour0
Registered user hits last week152
Registered user hits last month875
Go up

sqlplus hangs after entering username/pwd
Next thread: How to audit Noaudit statements - Traditional Auditng
Prev thread: Do you have a trick for me ;-)

Message Score Author Date
Dear All. on db server sqlplus hangs after enteri...... dattatraya walgude Sep 28, 2020, 10:45
Hi, Any logon triggers? Any ORA environment va...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse Sep 28, 2020, 10:57
Thanks Philip, no related logon trigger and no...... dattatraya walgude Sep 28, 2020, 11:21
Hi, Did you enter first a data for ORACLE_S...... Joël Péran Sep 28, 2020, 13:35
Yes try with @tns also but same problem. Db se...... dattatraya walgude Sep 28, 2020, 14:08
I can connect to other schema like scott and anoth...... dattatraya walgude Sep 28, 2020, 14:09
Hello, <<<i>ORA-01940: cannot drop a user that ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Sep 28, 2020, 19:02
Thanks Bruno, After db restart, first time logi...... dattatraya walgude Sep 29, 2020, 05:42
Hello, what about the other questions? (profile...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Sep 29, 2020, 10:51
Profile is default, <pre>LAST_CONN ...... dattatraya walgude Sep 29, 2020, 11:13

Follow up by mail Click here


Subject: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 28, 2020, 10:45, 61 days ago
Os info: linux
Oracle info: SE - Release 12.1.0.1.0
Message: Dear All.
on db server sqlplus hangs after entering username/pwd
it happens only with one specific account.


any clue on this ?

Alert log shows:
WARNING: inbound connection timed out (ORA-3136)

Regards
Dattatraya
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: Philip Wisse, Netherlands
Date: Sep 28, 2020, 10:57, 61 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

Any logon triggers?
Any ORA environment variables?
glogin.sql?

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 28, 2020, 11:21, 61 days ago
Message: Thanks Philip,

no related logon trigger and no changes in glogin.sql also.

Regards, Dattatraya
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: Joël Péran, France
Date: Sep 28, 2020, 13:35, 61 days ago
Message: Hi,

Did you enter first a data for ORACLE_SID ? Did you try with a tnsname (sqlplus user/passwd@mybase) ? Do you have a antivirus running ?
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 28, 2020, 14:08, 61 days ago
Message:
Yes try with @tns also but same problem.
Db server OS is Linux - 64Bit. No antivirus running.

Also try drop user with cascade option. ( After 10 Min. below error)

ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

There is no connected sessions. still giving error.



Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 28, 2020, 14:09, 61 days ago
Message: I can connect to other schema like scott and another schema,
Only one schema giving this error.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: Bruno Vroman, Belgium
Date: Sep 28, 2020, 19:02, 61 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello,

<<ORA-01940: cannot drop a user that is currently connected>>

- Do you see the user in V$SESSION?
- SELECT TO_CHAR( last_login, 'DD-MON-YYYY HH24:MI' ) last_conn, account_status, profile FROM dba_users WHERE username = 'THIS_ONE';
- What about stop and start of the database?

Do you know something "weird" about this user (has the user special privilege; has it been created in a special purpose?)
Or something that happened recently to the account (attempting a very special operation...)?


Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 29, 2020, 05:42, 61 days ago
Message: Thanks Bruno,

After db restart, first time login successfully , after that same problem.

XXXX_db12cstd1:/home/oracle/scripts> sqlplus USERNAME/PASS


SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 29 08:49:28 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Last Successful login time: Sun Sep 27 2020 18:19:57 +05:30

Connected to:
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

SQL>
SQL> exit
Disconnected from Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
XXXX_db12cstd1:/home/oracle/scripts> sqlplus USERNAME/PASS

SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 29 08:50:08 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Regards
Dattatraya
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: Bruno Vroman, Belgium
Date: Sep 29, 2020, 10:51, 60 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello,

what about the other questions? (profile of the user...) And double check the triggers...

But anyway a "quick fix" (that will leave the mystery open): stop database, start it, do NOT connect as this user but drop it cascade (at this time it should be OK and this is what you intended to do)

Best regards,

Bruno.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlplus hangs after entering username/pwd
Author: dattatraya walgude, India
Date: Sep 29, 2020, 11:13, 60 days ago
Message: Profile is default,

LAST_CONN                  ACCOUNT_STATUS                   PROFILE

-------------------------- -------------------------------- ----------
29-SEP-2020 08:49 OPEN DEFAULT


We check drop user after database restart , keep you posted...

Thanks
Dattatraya
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here