Not able to logins as ssysdba [message #567587] |
Wed, 03 October 2012 07:41 |
|
sathish16787
Messages: 56 Registered: September 2011 Location: mumbai
|
Member |
|
|
when we try connect to db it hangs
sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Oct 4 08:20:57 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
|
|
|
|
|
|
|
Re: Not able to login as sysdba [message #567607 is a reply to message #567603] |
Wed, 03 October 2012 08:16 |
|
sathish16787
Messages: 56 Registered: September 2011 Location: mumbai
|
Member |
|
|
Wed Oct 3 17:19:21 2012
Beginning log switch checkpoint up to RBA [0xb3f1.2.10], SCN: 0x0938.508d2c16
Thread 1 advanced to log sequence 46065
Current log# 2 seq# 46065 mem# 0: /u01/vis/visdemodata/log2.dbf
Wed Oct 3 17:28:26 2012
Completed checkpoint up to RBA [0xb3f1.2.10], SCN: 0x0938.508d2c16
Wed Oct 3 17:28:38 2012
Beginning log switch checkpoint up to RBA [0xb3f2.2.10], SCN: 0x0938.508d8769
Thread 1 advanced to log sequence 46066
Current log# 3 seq# 46066 mem# 0: /u01/vis/visdemodata/log1.dbf
Wed Oct 3 17:35:00 2012
Beginning log switch checkpoint up to RBA [0xb3f3.2.10], SCN: 0x0938.508e140c
Thread 1 advanced to log sequence 46067
Current log# 1 seq# 46067 mem# 0: /u01/vis/visdemodata/log3.dbf
Wed Oct 3 17:35:06 2012
Completed checkpoint up to RBA [0xb3f2.2.10], SCN: 0x0938.508d8769
Wed Oct 3 17:35:50 2012
Beginning log switch checkpoint up to RBA [0xb3f4.2.10], SCN: 0x0938.508e1d18
Thread 1 advanced to log sequence 46068
Current log# 2 seq# 46068 mem# 0: /u01/vis/visdemodata/log2.dbf
Wed Oct 3 17:35:50 2012
Completed checkpoint up to RBA [0xb3f3.2.10], SCN: 0x0938.508e140c
Wed Oct 3 17:50:53 2012
Completed checkpoint up to RBA [0xb3f4.2.10], SCN: 0x0938.508e1d18
Wed Oct 3 17:50:54 2012
Beginning log switch checkpoint up to RBA [0xb3f5.2.10], SCN: 0x0938.508fde9e
Thread 1 advanced to log sequence 46069
Current log# 3 seq# 46069 mem# 0: /u01/vis/visdemodata/log1.dbf
Wed Oct 3 17:52:09 2012
Beginning log switch checkpoint up to RBA [0xb3f6.2.10], SCN: 0x0938.508fffdb
Thread 1 advanced to log sequence 46070
Current log# 1 seq# 46070 mem# 0: /u01/vis/visdemodata/log3.dbf
Wed Oct 3 17:52:12 2012
Completed checkpoint up to RBA [0xb3f5.2.10], SCN: 0x0938.508fde9e
Wed Oct 3 17:52:53 2012
Completed checkpoint up to RBA [0xb3f6.2.10], SCN: 0x0938.508fffdb
Wed Oct 3 17:53:12 2012
Beginning log switch checkpoint up to RBA [0xb3f7.2.10], SCN: 0x0938.50900e32
Thread 1 advanced to log sequence 46071
Current log# 2 seq# 46071 mem# 0: /u01/vis/visdemodata/log2.dbf
Wed Oct 3 18:13:49 2012
Completed checkpoint up to RBA [0xb3f7.2.10], SCN: 0x0938.50900e32
|
|
|
|
|
|
|
|
|
|
Re: Not able to login as sysdba [message #567649 is a reply to message #567617] |
Thu, 04 October 2012 00:04 |
|
sathish16787
Messages: 56 Registered: September 2011 Location: mumbai
|
Member |
|
|
Issue fixed
ps -ef | grep ora
oracle 21438 1 0 Oct04 ? 00:00:00 oracleXXXX (LOCAL=NO)
since 2 months process is running. we killed all the process .Now we are able to login .
Thanks ..........
|
|
|