Database 10.2.0.3 - Cannot Connect To Sqlplus?
Aug 29, 2012
My database in on 10.2.0.3 and facing hang problem when I am connecting to sqlplus.
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 00:54:03 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01075: you are currently logged on
As per Metalink note(215858.1) suggested in forums I have followed steps and produced results below.
bash-3.00$ sqlplus -prelim
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 28 23:28:02 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: / as sysdba
SYS on test>oradebug help
SYS on test>oradebug setmypid
Statement processed.
SYS on test>oradebug hanganalyze 12
[code]...
Now I have got struck how to analyze above results.
View 3 Replies
ADVERTISEMENT
Jul 19, 2010
When I try to remotely connect to an Oracle schema using SQLplus, I consistantly get this error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Yet I can connect to the same machine, from my own machine just fine using SQLDeveloper.Here are the details I have collected so far
- I am using the instantclient for OS X
- export DYLD_LIBRARY_PATH=/Users/jeff/instantclient
- export ORACLE_HOME=/Users/jeff/instantclient
- export TNS_ADMIN=/Users/jeff/instantclient/tns
The command line i ran : ./sqlplus seam_classoft/seam_classoft@//oracle11gtest.terida.net:1521/orcl
Its behind a VPN, so I'm not worried about posting my info.
My /Users/jeff/instantclient/tns/tnsnames.ora that I copied directly from the server looks like this:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gtest.terida.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.terida.net)
)
)
I've tried changing SERVICE_NAME to SID = orcl, no change inbehavior. My original guess was that the database wasn't registered with the listener, but that would mean sqlDeveloper should fail as well, but it works.Here is out put of lsnctrl status:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-JUN-2010 09:16:40
Uptime 42 days 0 hr. 58 min. 59 sec
Trace Level off
[code]....
View 4 Replies
View Related
Feb 24, 2010
it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems
sqlplus username/password@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oradev10)(PORT = 10520))(CONNECT_DATA = (SERVICE_NAME = D10)))
i set the ORACLE_HOME environment variable correctly... what more i have to do? following is my tnsnames.ora
TOTEMPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ttf19.cern.ch)(PORT = 1521))
[code]...
View 6 Replies
View Related
Sep 6, 2012
when i try to connect with sqlplus or toad then i get an error
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Users>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:Users>
and i want to tell what i do before it-my all files were be converted in .FLT then i shorted out this problem after that when i tried to connect with sqlplus or toad then i get above error.and i have restarted my system but throwing same error.
i am using oracle 11.2.0.1 on windows 7
View 5 Replies
View Related
Oct 6, 2010
I have the following computer/setup:
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
View 2 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
Dec 4, 2012
I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
SCHEMA USERNAME
PASSWORD
HOSTNAME
PORT NO
SID/SERVICE NAME
these details. May be am wrong to ask this question but i need to login and check the requirement. Is there any other anyway to login without sqlplus utility?
View 17 Replies
View Related
Sep 23, 2012
I am using oracle 10.2.0.3 in AIX
From client machine , i m not able to connect, it raise error
sqlplus t24/t24@pbldr
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 23 16:21:46 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-03135: connection lost contact
Note : after restart the listener only one time I can able to login to database next time raise above error.
View 3 Replies
View Related
Nov 10, 2011
For example, I have 3 database, database 1 and database 2 connect together by database link db_link1, database 2 and database 3 connect together by database link db_link2.
I want to ask: Can I connect from database 1 to database 3 ? ( Of course don't use database link between database 1 and 3, just use database db_link1 and db_link2 )
Both db_link1 and db_link2 are public database link.
Can I restrict user access by 2 these public database link ?
View 1 Replies
View Related
Feb 11, 2013
I am not able to connect to database due to ORA-257. So manually i deleted the archivelog files in diskgroup. however it is showing 13gb free space after deletiion. Archive log files generated due to Import job is running.
In below ways i have tried to connect to database.
1) Through SQLPLUS (Not able to Connect)
2) Through RMAN i tried to connect (Not able to connect)
3) I tried to connect impdp to stop the running job. It was also failed
View 7 Replies
View Related
Feb 23, 2009
I do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.
View 1 Replies
View Related
Jul 18, 2011
while new form open i need to connect the data base.
View 5 Replies
View Related
Oct 24, 2010
I extracted the script of creating user in my database in SQL navigator and Toad tools but it is displaying encrypted password. But I am unable to connect with that password.
To get the original password then I will be able to connect my database.
View 3 Replies
View Related
Aug 26, 2010
How can I connect forms6i to run on SQL database ?
View 4 Replies
View Related
Sep 10, 2008
I'm writing PRO C program with oracle 8i. My process first connect to the database with using ora_connect(), proceed the task then diconnect with using ora_disconnect(). This would always in a loop, recently after few cycle of connect and disconnect, when the next issue connect statement, it was unable to connect and return me ora-00604 and the process end. Even i restart the process, after few cycle also the same return me ora-00604 during the connect.
View 3 Replies
View Related
Oct 19, 2012
I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.
View 1 Replies
View Related
Jun 8, 2011
How can i connect my d2k form to database, when i installed d2k it gave an error like :
user1.pin(20):os_error while spawning ifsrv660-install forms60 server port=9000
mode=socket batch=yes
after installation when i want to compile my form it gave tns error like:
ora-12154:tns:could not resolve service name
View 3 Replies
View Related
Jan 31, 2013
I recently installed Oracle database 11g XE onto my home computer running Windows 32 bit, but I can't connect to the database. I also have Oracle 10g R2 installed on my computer, and I can still connect to it finely. When trying to make a connection in SQL DEVELOPER, I get this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I tried to tnsping the XE database and it returns successfully.
C:>tnsping xe
TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-JAN-2
013 07:59:17
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:oraclexeapporacleproduct11.2.0server
etworkadminsqlnet.ora
[code]....
View 3 Replies
View Related
Apr 23, 2010
I want to know what will be the performance of my DB before loading data and how many users can connect with my database.
View 7 Replies
View Related
Jul 17, 2013
have a problem while i am trying to connect to database through JDBC here is my code,i am using oracle11g express edition import java.sql.
Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement; public class connectiontoDB { public static void main(String[] args) throws Exception { // TODO Auto-generated method stub try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","citi","citi"); Statement stmt=con.createStatement(); stmt.executeUpdate("create table user(id number(10))"); System.out.println("connected to database successfully"); } catch(Exception e){ e.printStackTrace();
View 1 Replies
View Related
Jul 19, 2010
I have created an Oracle database on my Windows XP system but cannot connect from a php script
CODE
<?php
if (!$db = @ocilogon("big", "big", "s7s"))
{
$error = ocierror();
printf("Error was: %s", $error["message"]);
die();
}
$stmt = ociparse($db,"SELECT count(*) FROM members");
ociexecute($stmt);
?>
When I created the database the connection I used was s7s but whether or not I include that name or just use the ID/password that script will not connect.
View 2 Replies
View Related
Apr 8, 2013
How to write a code(procedure) to connect external database through PLsql coding.. I mean,
first, "Create connection like connection string", then "retrieve data from tables inside the database".
View 4 Replies
View Related
Sep 3, 2009
I installed oracle 10g and developed simple software using forms 6i. Its working well as a stand alone system.
I want to share it in network. so I installed forms 6i as oracle client , copied the tnsnames.ora from the oracle installation path to forms installation path.(inside NET80/Admin folder)
When i try to connect with user name and password , it comes ORA-12203 Unable to connect to destination. I checked LSNRCTL in the database machine, it is listening.
View 11 Replies
View Related
Nov 2, 2011
I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
View 19 Replies
View Related
Jun 4, 2011
i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides
View 6 Replies
View Related
Nov 17, 2012
I have intsalled oracle client 9i.I add my services into tnsnames.ora .I could connect in sqlplus but in Enterprise manager i receive error ora12154 tns could not resolve service name!
View 4 Replies
View Related
Dec 8, 2011
how to connect oracle database through online
View 8 Replies
View Related
Oct 31, 2012
I cant able to connect to my local DB instance. Oracle service for DB instance will be started running when the system boots automatically.I faced this problem before, I was instructed to boot my system without network connection. It worked for few days. Suddenly I cant able to connect to my local DB instance again, even though I am booting my system without network connection.
This is the configuration I have in tnsnames.ora in my local machine.I have the host as localhost, because local machine is laptop and IP will change periodically.
CSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSS)
[code]....
View 14 Replies
View Related
Jun 25, 2013
how to connect to sql server databases via toad. I have used toad to connect to oracle databases, but never to a sql server database. To connect to an oracle database, we first install the client and then add the tnsentry of the database to the tnsnames.ora file and then we can directly connect to the oracle database right?So I was wondering if there are any steps like that to be followed to connect to the sql server databases.
View 2 Replies
View Related
Nov 21, 2012
Am getting the following error while connecting db from sql dev "network adapter could not establish connection vendor code 20"
FYI - database is up and running fine in sqlplus, and am not able to find the service in lnsrctl. As am using OIM db as service name while its showing CLRExtProc.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-NOV-2012 20:28:48
Uptime 0 days 0 hr. 27 min. 32 sec
Trace Level off
[code].....
View 2 Replies
View Related
