Sqlplus Error While Connecting To Database?
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
ADVERTISEMENT
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
Nov 17, 2012
I have oracle db server 9.2.0.2 , I have a client connected with this server, the client has sqlplus 8.0.6.0
I adjust the tnsnames in the client with the following parameters :
myconn =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = my_sid)
)
)
this connection was successful
when I tried the same connection with oracle db server 11g (11.2.0.1)
this connection failed
how can i connect wih the new server 11g (11.2.0.1)
View 7 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
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
View Related
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 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
Feb 17, 2012
we have a production database 'X'. Now i have created a test database 'T' and did'nt configured another listener to it! The issue is when i cam connecting to oracle through sqlplus i am directly connecting to Test database 'T' but not the production database 'X'----ofcourse i can login to production DB afterwards. but initially i want to access the production database 'X'.
View 15 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
May 29, 2013
running CENTOS 6 and oracle DB 11.2.0 and when i try to launch sqlplus i get the following error:
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
problem is, it's telling me to set ORACLE_HOME but I'm not sure where this is to set.
View 17 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
Nov 20, 2012
In my database server i am not able to login to the database via sqlplus and exp/imp also having error as below. But i am having permission to the this executable. I am falling under other user catagary
export ORACLE_SID=TEST
export ORACLE_HOME=/dboracle/orabase/product/10.2.0.3
export PATH=$PATH:$ORACLE_HOME/bin
Error:sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Permission details.
testuser@sgh3001:/dboracle/orabase/product/10.2.0.3/bin> ls -lrt sqlplus
-rwxr-x--x 1 oracle dba 12924 2007-03-27 10:21 sqlplus
View 22 Replies
View Related
Aug 14, 2012
i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.
View 6 Replies
View Related
Sep 10, 2013
I have a .sql file that is used as a wrapper file that when executes within sqlplus (9.2.0.1.0), executes a bunch of .sql files within it. Example below:
WRAPPER.SQL
START D:ScriptsA.sql "'04-01-2012 00:00:00'"
START D:ScriptsB.sql "'04-01-2012 00:00:00'"
START D:ScriptsC.sql "'04-01-2012 00:00:00'"
START D:ScriptsD.sql "'04-01-2012 00:00:00'"
START D:ScriptsE.sql "'04-01-2012 00:00:00'"
EXIT;
Each of the .sql file (A,B,C,D,E) Spools individual output of sql statment within them. Each of the indv .sql file queries different tables with different filters(where) clause.
I would like to capture any error (OS,SQL,DB) into indv error file (A_ERROR.log). The reason being is because later in the process we need to validate if there were any errors before processing and loading the data into our SQL database
View 15 Replies
View Related
Feb 14, 2011
i want to connect to a database that is out side my network and my application is running on forms 6i and database version is 10g .
View 2 Replies
View Related
Mar 19, 2010
Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]
I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects. I create a 10.1.0.5 database and copied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]
I did add the entry for the 10G database to TNSNAMES.ora:
NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)
I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.
View 6 Replies
View Related
May 30, 2013
We have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .
Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)
Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)
1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?
2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?
3] Is there any other solution apart from using "Database Gateway for SQL Server " ?
View 1 Replies
View Related
Sep 12, 2012
We've got a 32 bit .Net windows application which uses ODAC 10g (1.x) to connect to a 10g database on the backend. Things work fine in this deployment.
We're in the process of setting up a new development machine. This machine has ORACLE 11g (64 bit) installed on it. We're running into issues connecting the the database.
This is the code block we're using to connect to the database:
=======================================
string dataString = "user id=xxx;password="xxx";data source=localhost:1521/ORCL";
using (OracleConnection oraconn = new OracleConnection(dataConn))
{
oraconn.Open();
Oracle.DataAccess.Client.OracleCommand cmd = new OracleCommand(sOraSQL, oraconn);
[code]........
We get an exception on the "oraconn.Open()" command.
The output window in VS2010 shows this:
-----------------------------------------------------------
A first chance exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll
The oraconn variable looks like:
-------------------------------------------
- oraconn {Oracle.DataAccess.Client.OracleConnection} Oracle.DataAccess.Client.OracleConnection
+ base {Oracle.DataAccess.Client.OracleConnection} System.ComponentModel.Component {Oracle.DataAccess.Client.OracleConnection}
ConnectionString "user id=xxxxx;password="xxxxxx";data source=localhost:1521/ORCL" string
ConnectionTimeout 15 int
DataSource "localhost:1521/ORCL" string
[code]........
The details of the exception are:
---------------------------------------------
- ex {""} System.Exception {Oracle.DataAccess.Client.OracleException}
+ [Oracle.DataAccess.Client.OracleException] {""} Oracle.DataAccess.Client.OracleException
+ Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal}
HelpLink null string
[code].........
To reiterate, in our original deployment (10g database with 10g (1.x) ODAC, we can connect fine with the database. It's with the new setup (11g database with 10g(1.x) ODAC) that we are having issues. We've previously been able to deploy on client machines which were using ORACLE 11g. To accomplish this, we had to make sure that the password was inclosed in quotes (").
What is going on here? What should we be looking at? How do we go about debugging fixing this?
View 1 Replies
View Related
Mar 5, 2011
tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:
rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found
i have also tried to set the oracle_home, oracle path & oracle SID.
find the below configuration parameters which i have set to.
root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
[code]....
View 4 Replies
View Related
Mar 8, 2012
I have a problem concerning change of the connection inside a form. I have this code in when validate item trigger
LOGOUT ;
LOGON ('FIFES_HN','FIFES_HN@PRD_253');
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (:DAILY_TRX_CONT.ORG_ID);
[code].........
how the last message is 'FIFES_HN' it show be 'SIFESD'
View 7 Replies
View Related
Jul 13, 2012
connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.
how to use the tnsnames,ora and listener.ora file for connecting both system.
View 39 Replies
View Related
Jul 16, 2012
I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+
when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+
"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"
I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit
When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.
View 2 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 19, 2011
I want to know if it is possible, to run IMP program without connecting with database user , for example :
imp '/ as sysdba' file=f.dmp fromuer=u1 touser=u2 log=flog.log
that permits to perform scripts without passwords in.
View 8 Replies
View Related
May 24, 2011
Connecting Oracle to SQL Server via database link.
I am trying to connect from Oracle 10G to a SQL Server database. I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of the documentation describe how each option works.
As an example, i have been given the following information on the database i need to connect to (i.e. the SQL Server database)
- Username
- Password
- Database Name [lets assume the database name is data_extract]
To connect the above i made the following changes
$ORACLE_HOME/hs/admin/inithsodbc.ora
---------------------------------------
HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0
$ORACLE_HOME/network/admin/tnsnames.ora
---------------------------------------
sqlserver.db =
(DESCRIPTION =
[code]....
Note: In listener.ora, i only added the last SID_DESC entry. I then went on and created the database link as shown below
create database link sqlservdb using 'sqlserver.db';
When i try to access a table i get the following error
sqlplus> select * from TESTTABLE@sqlservdb;
select * from TESTTABLE@sqlservdb
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from ORASQLSERVER
A couple of things i am not sure of:
- Where do i specify the username and password to access the sql server from the oracle db to the sql server db
- Having read around on the internet, i can see some people refering to a DSN datasource. I am told that the information that i have is all i need. Is this correct or do i need something else?
- The sid i specified in inithsodbc.ora and tnsnames.ora is actually the sql server database. Is this correct?
View 10 Replies
View Related
Jun 4, 2013
I checked lots of pages but I'm not able to find a solution für my problem. I already set up a primary and a standby database (prim = ALPHA1 / standby = ALPHA2). After enabling my dgmgrl configuration I got two errors:
DGM-17016: failed to retrieve status for database "alpha2"
ORA-16664: unable to receive the result from a database
The dg log from ALPHA1 says:
06/04/2013 16:06:57
Site alpha2 returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration alphadgb Warning ORA-16607
Primary Database alpha1 Success ORA-00000
Physical Standby Database alpha2 Error ORA-16664
While the dg log from ALPHA2 (standby) says:
06/04/2013 16:43:28
SPFILE is missing value for property 'LogArchiveFormat' with sid='ALPHA2'
Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='arch_ALPHA2_%S_%t_%r.arc', SPFILE='(missing)', DATABASE='arch_ALPHA2_%S_%t_%r.arc'
Failed to connect to remote database alpha1. Error is ORA-12514
Failed to send message to site alpha1. Error code is ORA-12514.
How can I solve this issue? Every type of tnsping is successfull. The sqlplus login from the primary to the standby database works, the other way round works too! Therefore the tnsnames and listener data seems to be correct.
My configuration for ALPHA1 (primary db):
---------------------------------------------------------------
Listener
---------------------------------------------------------------
LISTENER_ALPHA1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
[code]....
View 3 Replies
View Related
