[oracle@localhost ~]$ sqlplus system/password SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
But when i am using SID name while connecting to database i am able to connect...
[oracle@localhost ~]$ sqlplus system/password@apple SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL>
I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.
I installed Oracle 10g XE and Toad 10.5 in my home system.I am able to connect to Oracle from Oracle XE homepage and XE SQL command line but when I try to connect to Oracle from toad 10.5 I am getting the error 'TNS: could not resolve the connect identifier specified (XE)'.From toad I tried direct and TNS options but it did not work. My tns ora file looks like below.
TNS_ADMIN variable has correct parameter and Toad is directing the correct TNS file. I tried changing hostname with my system's ip but still I am unable to connect to Oracle from Toad.
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 have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.
I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.
I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
I am unable to insert and even display euro symbol from server as well as windows client.
Following are the details of my database server
SQL> select * from nls_database_parameters; PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8MSWIN1252
[code]....
1) When I try to insert € from Db server (using putty) using Alt+0128 it does not print anything (nothing gets typed on the screen). Not even junk characters Also following query does not print anything
SQL> select chr(128) from dual; C -
2) while I set NLS_LANG on client and try to insert €, Alt+0128 produces a question mark symbol And following query displays junk character
SQL> select chr(128) from dual;
C - Ç
3) Regardless when I inserted couple of rows and tried UNISTR following was the result
The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.
# Host name is vmwwin7634.na.SAS.com # SID is sting2 # SERVICE_NAME is sting2.na.sas.com
PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com
I am using SQuirreL Client version 3.4.0
# Here is the tnsnames.ora entry on the server. STING2 = (DESCRIPTION =
[code]...
# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.
# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com (SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.") jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)
# "New Method" jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works) jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors) (SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
I am using oracle 10 g on my pc .i have no issues while working on it but whenever i am not connected to the internet its says failed to connect.As most of the time i am not connected to the internet the isql plus browser would show the same error but the moment i connect to the inet,it works.
Is it that 10g isql plus wont work while not connected to internet ?
I was trying to connect to oracle 10g database from oracle 10g client. But unable to do so.
i am able to tnsping the db from client but unable to estatblish sqlplus connection. I get ORA-28547 error when i issue the command sqlplus hr/***@db1. ORA-1560 when the command sqlplus hr/*** is issued.
I have mentioned the listener and tnsnames.ora files
I have TOAD 8.6 installed and hoping to use with Oracle 10g databases. I have SQL Navigator also - it works fine. However TOAD does not. Open up TOAD and see the TNS dropdown, select a database and try to log in - click on Connect and the little SQL hour glass comes on, goes off - there is no error, no message and no connection. I have tried several databases and again, SQLPlus, SQL Navigator are both working fine.
Database is up and running and client machines able to do TNSPING; But when users try to connect the database thro SQL DEVELOPER, they are getting below information:
your database connection has been reset. Any pending transactions or session state has been lost.in the database server, SQLNET.ORA reads as below:
> more sqlnet.ora AUTOMATIC_IPC = ON names.directory_path = (TNSNAMES,EZCONNECT) names.default_domain = world name.default_zone = world sqlnet.expire_time = 15sqlnet expire time shows 15 min.
normally this error willbe suppressed if user tried after some time. But now we get this error for more than 2 hrs.
I have installed and loaded a mssql express database on my pc for migration testing. When I test a connection from sql developer 3 receive "Failure -Test failed Cannot connect to Microsoft SQL Server on localhost. I am using windows authentication and SQL Server authentication and the default port 1433.
I'm not able to login to PL/SQL Developer 7.0.3.1123.I'm receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Although it lists all TNS entries in Database drop down.It was working fine last week but now I'm not able to login.
I'm not able to run SQL *Plus on my machine. It is giving me below error.
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
Setting of PATH environment variable is as below. If I remove below highlighted part I'm able to run SQL * Plus. I cannot remove this because it is required to run my application.
i am using client-server environment without using a domain.On One computer i have installed Oracle 8.0.5 and developer 2000. and on client side i have installed form 6i. i have made a service (star) in Tnsnames.ora in client side.
When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".
i can't loose the builted tables and the information stored in them.My listener.ora file is :
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