ORA-12547 / TNS / Lost Contact / Access Oracle Database 11.2.0.3
Dec 7, 2012
I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.
ID ORACLE
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t
The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.This user belongs to dba.But when trying to access Oracle via sqlplus gives this error:
-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
However, if you connect using a network descriptor works correctly.
SQLPLUS DAVINCI/xxxx@tns_alias
So there must be a problem with access to local resources.This user has the same profile file variable (. Bash_profile)
View 6 Replies
ADVERTISEMENT
Mar 29, 2011
I have successfully installed Oracle R12 on my machine but after rebooting I can not start.
This is what I did
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
[code]....
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
View 18 Replies
View Related
May 4, 2013
Yesterday everethig was fine and I were able to connect / as sysdba
When í try it today sqlplus freez and I have to kill that session from other terminal.
When I try to connect as normal user, I am getting this error.
normal user
[oracle@oracle admin]$ sqlplus surad@evidence
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 15:46:44 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 0 Serial number: 0
---
sysdba
[oracle@oracle admin]$ sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:01:09 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> connect / as sysdba
--> There are waiting .... solution is to kill that session.
----
[oracle@oracle admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:04:06 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
--> There are waiting .... solution is to kill that session.
View 17 Replies
View Related
Aug 15, 2013
Since our upgrade from 10.2.0.4 to 11.2.0.3, we are experiencing occaisional overnight job failures throwing the ORA-03135 Connection lost contact errors. It doesn't happen often, but every once in a while. Even so, it is bugging me because I can't find anything wrong!
We have a dual server setup, with one IA64 HPUX 11.31 server hosting the database, and a second IA64 HP-UX 11.31 running all of the application code. I'm seeing errors in the Alert log that is pointing me to a specific cjq0 trace file, and the contents of that trace file are pretty much as follows:
*** 2013-08-15 02:05:45.541
Waited for process J001 to initialize for 107 seconds
*** 2013-08-15 02:05:45.544
Process diagnostic dump for J001, OS id=19302
-------------------------------------------------------------------------------
os thread scheduling delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 02:05:45 ]
NOTE: scheduling delay has not been sampled for 0.312200 secs 0.000000 secs from [ 02:05:41 - 02:05:46 ], 5 sec avg
0.000000 secs from [ 02:04:46 - 02:05:46 ], 1 min avg
0.000031 secs from [ 02:00:45 - 02:05:46 ], 5 min avg
loadavg : 0.31 0.17 0.09
[code]....
There were jobs that completed successfully just prior to this failure, and subsequent jobs ran successfully as well. I'm stumped - not sure what's going on here. I have reviewed a lot of posts relative to the ORA-03135, and followed as many of the recommendations as I can, but I'm still seeing this errors periodically. Their frequency has not changed since I started applying these changes, so I know I haven't stumbled on the cause as yet.
View 1 Replies
View Related
Dec 28, 2012
I am using a database link from between oracle 10g enterprise & oracle 10g express edition on window based system.
We are getting below given error at one client system and others clients system is working fine..
ORA-02068: following server error from dblink name
ORA-03135: connection lost contact table name <tablename>
View 9 Replies
View Related
Oct 11, 2010
My application is using "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and Oracle 11g client v11.1.0.6.0.My application server runs continuously and checks for new requests. But problem occurs when I do not send any request to my server for 40-45 minutes i.e. server is idle or doing nothing except checking new incoming requests for those 40-45 minutes. After that if I try to connect my server by sending some request, it shows following error message and my server crashes:
Message String: ORA-03135: connection lost contact
Process ID: 7586034
Session ID: 61
View 9 Replies
View Related
Mar 2, 2011
I have a question in Recovering the database.
E.g. Backup has done yesterday and today evening all files are lost (control, redologs, archive, etc.)
We are in 24/7 environment then how we need to recover the database?
View 4 Replies
View Related
Sep 13, 2012
i was worked on oracle 11g.1, oracle data miner 11.1.0.4, sql developer 3.
unfortunately, after finishing my tables and models ,the hard disk damaged and was replaced with other.the oracle setup was not on system partition,it was on D:/ and i had windows backup for C, D partition. i restored oracle partition D which contains old oracle files and i installed oracle again but on partition F.
now....how can i restore tables and modules?
View 3 Replies
View Related
Feb 21, 2012
I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.
I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.
View 1 Replies
View Related
Dec 18, 2012
i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.
i need to access this DB from OS root user. what should i do.
View 7 Replies
View Related
Nov 29, 2012
let me know the procedure to connect to Oracle Database from Ms-Access.
We are using Windows as Operating System.
View 1 Replies
View Related
Mar 18, 2011
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
View 1 Replies
View Related
Oct 12, 2012
How to access Active directory(Microsoft 2003) with oracle database 11g.
View 1 Replies
View Related
May 12, 2010
behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.
i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.
View 4 Replies
View Related
Aug 24, 2012
I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies
View Related
Nov 17, 2011
I have created two types and a list of the first type:
create type type1;
/
create type type1_list as table of ref type1;
/
create type type2;
/
I have now just created the two types as follows:
create type type1 as object(
id# number
);
/
create type type2 as object(
attribute1 type1_list,
MEMBER FUNCTION function1 RETURN NUMBER
);
/
Ok, I've created the tables (I don't know if it's necessary to point out my problem)
CREATE TABLE type1_table OF type1;
/
CREATE TABLE type2_table OF type2
NESTED TABLE attribute1 STORE AS nested_type1_list_table;
/
And what I wanted to do now is to implement the member function1 and check something of the attributes of type1 in the list of attribute1... And that's where my question occurs, how does it work, I can't figure it out. I tried something like this:
Quote:
create or replace
TYPE BODY type2 AS
MEMBER FUNCTION function1 RETURN NUMBER AS
[Code]....
But I don't get the right way, it doesn't work
View 4 Replies
View Related
Dec 13, 2010
We are migrating a proc application as described below.
Old Env: UNIX
Old DB: Oracle 8i
New Env: Linux
New DB: Oracle 11g
New modules are successfully compiled in Linux environment. But we are facing issues in writing the output of VARCHAR datatype to a file.
find below the extract of code.
EXEC SQL BEGIN DECLARE SECTION;
varchar mcolmnvarchar[4];
EXEC SQL END DECLARE SECTION;
EXEC SQL DECLARE crs CURSOR FOR
SELECT NVL(colmn,' ') FROM table1
memset(mcolmnvarchar.arr,'�',4); //Was added for only Linux migration. Not present in unix env.
EXEC SQL FETCH c1 INTO :mcolmnvarchar;
cout << "Data at Stage one"<< mcolmnvarchar << endl;
mcolmnvarchar.arr[mcolmnvarchar.len]='�';
cout << "Data at Stage two"<< mcolmnvarchar << endl;
fprintf(fptr,"%-4s",mcolmnvarchar.arr);
Above code works absolutely fine in Unix env with Oracle 8i. But with Linux env & Oracle 11g it is not working. No compilation or run time errors. Data at Stage one prints the output of database properly. But after null terminator code, Data at Stage two statement prints without any value. Value is lost after null terminator code.
View 7 Replies
View Related
Jun 3, 2011
I'm trying to write a query where I grab the first contact created of an account. I've tried everything but I can't get this to work.
Here is the normal query we used to get the contacts from an account:
select
con.row_id,
con.created,
con.fst_name,
con.last_name,
con.email_addr
from s_contact con
join s_org_ext org
on org.row_id = con.pr_dept_ou_id
I've tried different variation of aggregate functions, but its not working.
View 5 Replies
View Related
Sep 23, 2013
how to write below query in pl/sql cursor. The help table has two associated tables, help_txt and help_id, which will have strings of data concatenated into one sales contact record. There are multiple lines of text per comment and multiple lines of resolution text at 40 characters per line. The key to the help_text table (id, date,seqno) is the main key to the help_txt table and help_id t table with a sequence added to each table
The formatted string will contain some text and variables with the comment lines (1-10 or more) concatenated first, followed by the resolution lines (1-10 or more). There will be multiple comment and multiple resolution lines. The Cust_Cmnt_Txt lines and the Resolved_Desc lines should be concatenated and formatted in the following string (% marks the variable string) :
'help taken ' %help.Taken_Dte 'received from the following source: ' %help.id. 'Remark Text: ' %help_text (where help_txt_Seq = 1) %help_text (where help_text_seq = 2-10 or more) 'Resolution: ' %help_id_Res_Txt.Resolved_Desc (where help_ID_Txt_Seq = 1) %help_ID_Res_Txt.Resolved_Desc (where help_id_Txt_Seq = 2-10 or more)
View 8 Replies
View Related
Oct 17, 2012
I have one question regarding database access. I have one database server on which 3 databases are running. I want to restrict each database access for particular group only , so if anyone outside of this group try to access the database then they can not access the database.
Question is end user never login to Database server and access the database , they always connect to the database using different tool like Pl/sql dev,sqldev etc.
Is there any option through which I can make database access within group only ?
View 1 Replies
View Related
Aug 25, 2013
Database 11g Enterprise Edition.
Probably if I give the installation procedure I went through and specified Error messages,. Installation Option: - Create and configure database was selectedSystem Class: -Sever Class was selected Install Product:-Oracle Database Installation= Succeeded· Prepare= Succeeded· Copy files= Succeeded· Setup files= SucceededOracle database configuration= Succeeded· Oracle Net Configuration Assistant=Succeeded· Oracle database configuration Assistant=Ignored· Oracle configuration Manager Configuration (optional)=Succeeded In the process of the Install Product the following Error messages
[code]....
View 1 Replies
View Related
Feb 28, 2013
i have local network 3 pc , and i install database 11g r2 on my server( windows server 2008 r2 64 bit ) ..
i want to access this database from another pc (windows 7 64 bit) to query , insert and modify .
View 2 Replies
View Related
Jul 11, 2007
I am New to Oracle and PL/SQL. How to import ACCESS database to Oracle(10g) using PL/SQL.
View 1 Replies
View Related
Feb 7, 2007
I'm using Oracle10.0 as database for my project and I have installed Toad as front end tool for the Oracle. Now I want to access the database in the network using the Toad.
My question is, is it compulsory that oracle should be installed in every system to access Toad or any thing can I change in the server system to access the database from other systems in the Network.
View 1 Replies
View Related
Apr 20, 2012
I have two differenct databases with nsame name. Database 1 named DBX is on server SERVERX used for dev Database 2 named DBX is on server SERVERY used for test
I want to install OEM Agent on both server and access from one single OEM 11g Grid control.
What I find is that, the OEM seems to get confused when I try to login to the A database from OEM.
How should I configure OEM or Agent so that OEM can be used to login to both DBs?
View 3 Replies
View Related
Jun 22, 2010
How can we access a table from one database to another database on the same server.
Let us say One database is "A" and the Other database is "B" both databases are running on one server "ABCD".
My question is how can we access a table from database B to database A.
View 21 Replies
View Related
Apr 5, 2013
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
View 4 Replies
View Related
Nov 22, 2010
i want to restrict particular ips ,for that i specified
TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)
in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),
View 1 Replies
View Related
May 26, 2013
How to connect forms 6i with ms access.
View 1 Replies
View Related
Nov 8, 2011
Is there a way to find out the user access the database?
View 1 Replies
View Related
