Getting Error While Connecting To One Node
May 23, 2013
I have recently installed ORACLE 11gr2 rac. After installation i am not able to connect to one node i am getting the below error
<msg time='2013-05-23T10:25:24.660+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DPDCNSFDB1'
host_addr='172.18.132.51'>
<txt>TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 32: Broken pipe
My Tns connects to only one node.And i tried to connect using the virtual IP but not able to connect. TNS poing works fine.
View 1 Replies
ADVERTISEMENT
Oct 23, 2012
I am trying to connect rman target / from windows
Microsoft Windows [Version 5.2.3790]
� Copyright 1985-2003 Microsoft Corp.
C:\>set ORACLE_SID=PRODDB
C:\>set ORACLE_HOME=C:\oracle\product\10.2.0
C:\>rman target /
Message file RMAN<lang>.msb not found
Verify that ORACLE_HOME is set properly
C:\>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
View 2 Replies
View Related
Dec 26, 2012
The users are getting an error when connecting to the DB. I'm also not able to connect thru sqlplus . I get the message
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 26 14:39:55 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-01075: you are currently logged on
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes o bytes of shared memory ("","","","")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim hea
I need to restart the DB.
View 5 Replies
View Related
Sep 22, 2010
I have been trying to connect to an remote oracle db from c# .Net . I believe I have the proper code (Cos when the user id and password strings were omitted , it threw an error of invalid user Id and password).
Once this was properly provided , the connection is now throwing "TNS Error : No Listener " error . The same remote DB is perfectly connecting through TOAD and it is from the tnsnames.ora file of the local file that i got the connection string from . Hence , I don't thing its a problems with that as well.
View 7 Replies
View Related
Mar 13, 2013
after connecting to database using username and password , i get below error message connection is established and able to work asusal,
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
select 'Welcome to database: ' || name from v$database
*
ERROR at line 1:
ORA-00942: table or view does not exist
View 8 Replies
View Related
Mar 8, 2011
I am trying to connect to a remote database (Oracle) using my Windows terminal and I am successfully able to connect. But when I try to open a SQL File is gives the following error:
SQL > @int1.sql
SP2-0310: unable to open file
I found out that this error occurs when the file name or the path is invalid. But since I am having a remote access I really don't know the location. What can be done to remove this error?
View 1 Replies
View Related
Dec 5, 2012
I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.
PL/SQL developer
Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g
I am getting the below error
ORA-12154: TNS could not resolve the connect identifier specified
View 1 Replies
View Related
Mar 25, 2007
I have a problem on my PC when I try to connect Oracle-db with Designer .It,s Show this message
ORA-12541 :TNS:no Listener
View 2 Replies
View Related
Apr 19, 2011
During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.
rman target sys/srk786@orcli
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 19 09:59:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCLI (DBID=3754068166)
RMAN> connect auxiliary sys/srk786@stnd
[code]....
View 1 Replies
View Related
Jul 11, 2013
I am using OCI and instant_client (11.2.0.3.0) in my C++ program (on Windows 7) to connect remotely to 11G database. While doing a connection using server name as well as servername:port/service_name as connection strings, I am getting error of ORA-12504 TNS:listener was not given the SERVICE_NAME in CONNECT_DATA. According to instant client FAQ & white paper at [URL]..., no tnsnames.ora is required for instant client. Then why could I be getting this error? I ensured that only the instant client directory is in Path environment variable. There was a ODBC driver installed on this same host.
View 3 Replies
View Related
Aug 18, 2011
An Unexpected error window like popup is raised when starting Oracle SQL developer.Here I have attached the screenshot of the error.What does the error mean. How to resolve.Below is the error message shown if I click the REPORT button
FeedbackAn unexpected error has occured provide some information that would allow the developer to reproduce the problem
oracle.dbtools.raptor.utils.AbstractFolderedXml:Aug 16, 2011 8:36:56 PM oracle.dbtools.raptor.utils.AbstractFolderedXml newNode
FINE: Unknown Node:1:null................
View 3 Replies
View Related
Jan 26, 2013
I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
[code]..
View 2 Replies
View Related
Jun 15, 2012
current environment
Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI
on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2
we shutdown vmorarac1 to clone it to vmorarac5
on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211
mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5
152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip
[Code]....
Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2
152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip
hostname change in /etc/sysconfig/network
On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1
addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing
View 3 Replies
View Related
Aug 16, 2013
I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?
I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?
View 2 Replies
View Related
Jan 24, 2011
We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?
View 3 Replies
View Related
Jul 18, 2013
I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below
[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName Type Target State Host------------------------------------------------------------------------------------ora.rhel5.gsd application ONLINE ONLINE rhel5ora.rhel5.ons application ONLINE ONLINE rhel5ora.rhel5.vip application ONLINE ONLINE rhel5ora.rhel52.gsd application ONLINE ONLINE rhel52ora.rhel52.ons application ONLINE ONLINE rhel52ora.rhel52.vip application ONLINE ONLINE rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n
[code]....
View 0 Replies
View Related
Sep 13, 2012
I would like get more details about single node RAC.. What is single Node RAC?..
1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...
is there any advantage using single node rac(other than online upgrade to full RAC).
View 3 Replies
View Related
Feb 3, 2012
I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:
-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails
The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:
alert_ASM.log
NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4
[code]...
View 3 Replies
View Related
May 18, 2010
I got ORA-12528 while i was connecting sys as sysdba from remote machine to theinstance which is started in nomount mode. Although tnsping for that instance is working.
View 2 Replies
View Related
Dec 5, 2011
I'm trying to make a connection to sql server from an ORACLE 8.0.4 (I know, it's ancient) but can't seem to get it to work. I've read a lot of articles on the internet regarding the Heterogeneous Services but just can't get it to work on my system. Therefor I tried an example on connecting to an Excel workbook I found on another forum [URL] but that gives me the same problem as with connecting to sql server.
Here is what I've got:
initFRUIT.ora
CODEHS_FDS_CONNECT_INFO = SPONGE
HS_FDS_TRACE_LEVEL = OFF
LISTENER.ORA
CODESTARTUP_WAIT_TIME_LISTENER = 0
[code]....
One thing I noticed is that I do not have an hsodbc.exe file in my \bin, should it be there?
(I also tried Tgmsql80 in stead of hsodbc as program in Listener, resulting in an extended time of testing the connectivity but with the same result)
Is there any way I can test parts of the connection to limit the location of the problem? (e.g. does the listener get to the TNS)
View 2 Replies
View Related
Jul 31, 2004
sample code to connect to Oracle table using VB6.0, as well as code to populate the table and to access a particular record in the table.
Asuming userID is 'MyID' and Password is 'MyPass', Server Database is 'Mydata'.
View 2 Replies
View Related
Feb 29, 2012
I am making a form in which i could intigrate with scanner to capture image and stored it database. I also want to use OCR too. I am making document management System. I want to know how can i directly get connected with with scanner image to save it at runtime.
View 1 Replies
View Related
Dec 8, 2010
I am building the Oracle on RHEL 5(on Virtual machine with fixed disk space). I could install, after configuring and tried to connect to the database using "sqlplus system" on the command prompt(logged in as root), I get the following error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
View 2 Replies
View Related
Dec 6, 2010
My Oracle user which i created 5-6 months ago is not getting today when i tried to connect.But sys is getting connected.Also i queried dba_users in which my user was present. Also i did Alter user to change its password successfully., but it is not connecting.
View 19 Replies
View Related
Jan 4, 2011
When I attempt to connect to the DB as SYS, SYSTEM using sqldeveloper I get:
ORA-01017:invalid username/password; logon denied
Now I am certain the username and password are correct, I think it has something to do with remote login of SYS account. Are DBA accounts not allowed to connect via network? I get the same error when I try to sqlpython wrapper which I believe uses TCP
[oracle@oracle ~]$ sqlpython sys as sysdba
which: no gedit in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
which: no kate in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
Password:
Connection failure.
Opens the DB connection. Some sample valid connection strings:
[code]....
View 2 Replies
View Related
Jul 13, 2010
I am working with an asp.net/vb.net application whose users have oracle accounts to connect to the application.The database is set up to allow three failed login attempts. When connecting directly to the database, the sys.user$ lcount field increments on unsuccessful login attempts, and resets to 0 on successful login attepts. This is what I expect should happen.
However, when logging in through the application, using:
objConnection = New OracleConnection(m_strConnectionString)
objConnection.Open()
the lcount field sporatically increments on unsuccessful login attempts (sometimes it does, sometimes it doesn't), and never resets to 0 on successful login attempts. I would have expected it to behave as it does when connecting directly to the database.
Why does the lcount field not reset on a successful login through the application? How can I make it increment on each unsuccessful login attempt and reset on each successful login attempt?
View 1 Replies
View Related
Jul 5, 2010
I decided to uninstall oracle 10g, and APEX 4.0.
I then reinstalled oracle 10g express and downloaded APEX 3.2..
However, wen its time to upgrade to APEX3.2 via the command prompt... the previous version of APEX 4.0 (11.1.0.6.0) is being read.
how to reset this to the original value 10.2.0.10 (10g express edition) ?
View 1 Replies
View Related
Feb 28, 2012
Is there any way to control the timeout before connecting via dblink. the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,
So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.
the database version is 10gr2.
View 5 Replies
View Related
Mar 13, 2013
I am in a bit confusion about the user when we are logging in to sqlplus /as sysdba. what the user is when we are into sqlplus with sqlplus /as sysdba.
View 3 Replies
View Related
Jul 7, 2013
I am trying to learn Oracle and trying to use Visual Basic 7 to connect to an Oracle database, upload a text file to an empty table and then update a second Oracle table based on the info in the first table. I know you can do this with SQL*Loader, but how about VB? I did some research and found this posting: Re: Using Bulk insert or SQL Loader in VB6 I borrowed the code from there and altered it for my application (see below).
Dim con As New ADODB.ConnectionDim rst As New ADODB.RecordsetDim rst2 As New ADODB.RecordsetDim rst3 As New ADODB.Recordset con.ConnectionString = "Provider=OracleDB;User ID=john;Password=doe;Data Source=TestDB;"con.Open 'open the text filerst.Open "C:OracleTestCombinedCombined.txt" 'rst2 is an empty recordset because TempTable is empty at this time.rst2.Open "select * from TempTable", con, adOpenDynamic, adLockOptimistic 'adding rows into TempTable.Do Until rst.EOFrst2.AddNew Array("PACKET", "DATERET"), Array(rst.Fields("PACKET"), rst.Fields("DATERET"))rst.MoveNextLoop rst.Closerst2.Closecon.Close
My second question is this - say I had a second Oracle table in the same DB called "MasterTable", with the same two fields as "TempTable" (PACKET and DATERET). I want to update the DATERET field in "MasterTable" with the DATERET field in "TempTable" ONLY when the "PACKET" field matches in both tables.
View 5 Replies
View Related
