sqlplus / as sysdba is not working
apt-lnxtst-01:~ # /etc/init.d/nscd stop
Shutting down Name Service Cache Daemon done
sqlplus / as sysdba will hang , if nscd service is not running on your server
( if you are using ldap )
apt-lnxtst-01:~ # su - oracle
oracle@apt-lnxtst-01:~> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Apr 12 12:37:46 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
----------------this screen will stay like this --------------------------
--- hanged hanged hanged hanged hanged hanged hanged hanged hanged hanged hanged ----------
apt-lnxtst-01:/aptus/www/jtime76 # /etc/init.d/nscd start
Starting Name Service Cache Daemon done
now this will work
open a new terminal then
# su - oracle
oracle@apt-lnxtst-01:~> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Apr 12 12:41:57 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Search This Blog
Total Pageviews
Tuesday, 12 April 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
1 comment:
Sqlplus session still gets hanged even after starting nscd.
Could you please post some more info which will be helpful
Post a Comment