Problem:
Any connection through the database listener is extremely slow. It works fine, but it is not unusual for connection to take over a minute.
I try to start the listener as follows:
oracle@soa11gdev:/u01/app/oracle/product/11.2.0/db_1> lsnrctl startIt starts up after several minutes, instead of a few seconds.
Once it's up, I try to ping the listener as follows:
oracle@soa11gdev:/u01/app/oracle/product/11.2.0/db_1> tnsping orclThe response is over 60 seconds.
When I try to sqlplus into the database through the listener, it takes over 60 to 70 seconds:
oracle@soa11gdev:/u01/app/oracle/product/11.2.0/db_1> sqlplus system/manager@orclTrying to sqlplus to the database directly (i.e., bypassing the listener) is fine:
oracle@soa11gdev:/u01/app/oracle/product/11.2.0/db_1> sqlplus system/managerThe thing is, the listener works and is not misconfigured. But connecting is exceptionally slow.
Investigation:
Check your $ORACLE_HOME/network/admin/sqlnet.ora configuration file and ensure that the TNSNAMES is specified first as follows:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)In my case, the database was installed on Oracle Enterprise Linux 5.5.
My hostname was set to the fully qualified name of "oradev.ipnweb.com" and my /etc/hosts had the following entry:
192.168.1.55 oradev.ipnweb.com oradevSolution:
The problem is that /etc/resolv.conf had an incorrectly configured search domain.
Original /etc/resolv.conf:
nameserver 192.168.1.2Corrected /etc/resolv.conf:
search localdomain
nameserver 192.168.1.2Once this was corrected, problem was solved.
Applicable Versions:
- Oracle Database 11g (11.2.0) 32-bit and 64-bit
- Oracle Enterprise Linux 5.5 32-bit and 64-bit
good job
ReplyDeletemichael kors outlet online
ReplyDeletemichael kors handbags
nike free run flyknit
chi flat iron
sac longchamp
burberry handbags
yeezy boost 350 black
ghd hair straighteners
longchamp bag
buy red bottoms
michael kors outlet online
omega seamaster
dolce and gabbana outlet online
under armour shoes
michael kors outlet clearance
puma shoes
adidas supercolor
under armour outlet
coach outlet clearance
cheap jordans
nike air force
kate spade bags
fitflops shoes
ray ban outlet
ray bans
nike blazer
true religion jeans outlet
adidas nmd white
oakley sunglasses
hermes uk
hugo boss outlet online
oakley sunglasses
pandora charms uk
michael kors outlet
polo ralph lauren outlet
201672yuanyuan
Security testing is must. Everybody wants security at every level of his working. as explained above failures are happened but if we test time to time then it will improve. So it depend on us how much we are serious about this.
DeleteSecure Cooperative Communications With an Untrusted Relay A NOMA Inspired Jamming and Relaying Approach Project For CSE
Secure Detection of Image Manipulation by means of Random Feature Selection Project For CSE
Stealing Passwords by Observing Hands Movement Project For CSE
Stripped Functionality Logic Locking with Hamming Distance Based Restore Unit (SFLL hd)– Unlocked Project For CSE
Understanding the Related Key Security of Feistel Ciphers from a Provable Perspective Project For CSE
Universally Composable Key Bootstrapping and Secure Communication Protocols for the Energy Internet Project For CSE
vEPC sec Securing LTE Network Functions Virtualization on Public Cloud Project For CSE
true religion jeans
ReplyDeletecoach outlet
christian louboutin
cheap ray bans
christian louboutin sale
louboutin chaussures
pandora outlet
hermes handbags
tods shoes
moncler outlet
mt0713
In fact if you need to have multiple excel databases within your workbook simply put each excel database onto a separate worksheet.create mysql dashboard
ReplyDeletekobe byrant shoes
ReplyDeletemoncler
curry shoes
golden goose sneakers
supreme hoodie
stone island
hermes birkin
yeezy boost 700
moncler outlet
supreme clothing
Great reead thank you
ReplyDelete