Windows :: No Connection When Specifying Database Name

Jul 21, 2010

I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error. For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/ password @web I get an error.The full error that appears in the log is:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error

I have checked the tns entries and listener file and both are fine. Here are the entries:
TNSNAMES:

WEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = web)
)
)
[code]....

View 3 Replies


ADVERTISEMENT

Windows :: Error Regarding Oracle Connection?

May 20, 2013

error regarding oracle connection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand

[code]...

Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

View 1 Replies View Related

Windows :: Oracle Connection Not Working?

Jun 23, 2012

I'm having great difficulty connecting to two separate databases on my PC. Here are the details.

c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =

[code]...

View 22 Replies View Related

Windows :: Connection From Client To Server?

Apr 21, 2013

I Develop Application with C# . I want to connect from Client to Server.

my connection string is ""Data Source=192.168.100.50:1521/XE;User Id=system;Password=system;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;""

When exectue this Connection on Server ، all things OK but when execute on Client this error accure :

"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. The type initializer for 'OracelExperss' threw an exception"

View 1 Replies View Related

Security :: Windows Authentication And Connection In Oracle?

Jul 15, 2013

I have been using oracle based database security but company now wants to handle with windows authentication.I have windows os 2008 R2 and oracle 11.2.0.3.

I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS).I created user with create user "domainusername" identified Externally! but now how can i connection from application to database!

View 1 Replies View Related

Client Tools :: TOAD 9.1 - Show Windows By Connection?

Jan 21, 2008

TOAD 8.6.1 has an option of showing windows by connection. It is useful when there are multiple connections and, choosing one of these, all windows that belong to other connections are minimized.

Its icon looks like this:

Does TOAD 9.1 have the same option? I'm unable to locate it in options, toolbar customizations or elsewhere.

TOAD 9.5 Release Notes document says that "'Connection list' dropdown button has been restored and can be added to the Toad toolbar.". If I understand it correctly, it says that previous version didn't have that dropdown button, but 9.5 does.

In another words ... 9.1 might not have it at all.

View 3 Replies View Related

Performance Tuning :: Oracle (HP-UX) Connection Very Slow From Windows Client?

Jun 18, 2012

I have an Oracle database (9.2.0.7) installed on a HP-UX server.When trying to access this database from another HP-UX or Linux server, connection is fine. But when trying to connect from a Windows based client, connection is very slow (almost 1 minute to return the result of a 'select count(*)' like query, which is immediate from the Linux client).

Here are some facts I can add :

- Clients and servers are on the same network segment (it is not a network matter)

- No matter which client version I use, there no difference

- I tried to know what happens on the Oracle server when performing my sample query using tusc command : the result is that the server is performing exactly the same actions when sending my query from a Linux client or a Windows client

- The only relevant difference seems to be the client OS

View 13 Replies View Related

Client Tools :: ORA-06413 - Connection Not Open Error Oracle On 64-bit Windows

Jul 11, 2013

I have newly installed Oracle 11g R2 64 bits to window 8 PRo 64 bits. Able to connection successfully Oracle NEt Configuration Assistant service name.

But when I try to connect it Toad 9.6 32 bits its show error message

ORA-06413: Connection not open

View 5 Replies View Related

Backup & Recovery :: Transfer Database From Windows 2003 32 Bit To Windows 2008 64 Bit

Mar 30, 2011

I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit I have Cold RMAN backup. and directory structure of both server are same Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object

View 6 Replies View Related

Windows :: Installing 10g Database Software On Windows 2008 Server?

Sep 28, 2010

I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:

Checking Operating system version: must be 5.0,5.1,5.2 or 6.0

Actual 6.1

FAILED <<<<

Exiting Oracle Universal Installer

Press any key to Exit.

View 12 Replies View Related

Windows :: Does Oracle Database 10.1.0.2 (64-bit) Compatible With Windows 2003 R2

Jan 9, 2011

Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.

View 1 Replies View Related

Forms :: 11g And Database Connection

May 13, 2010

I have just installed Oracle Forms 11g with the Weblogic web server. I have a local installed database, and access to our network databases also.

I can do a TNSPING and get valid results back from that. I can connect with SQL Plus, and SQL Devloper. However, I cannot connect with the Forms 11g Forms Builder. where to copy the TNSNAMES.ORA file for use with Forms 11g?

View 5 Replies View Related

Database Connection And Memory Parameters

Sep 4, 2012

I have 3 questions.

I have 11.2.0.1 database on Windows 2008 R2 SP1.

1) While connecting to the database as sysdba (sqlplus "/as sysdba"), it takes about 12 to 15 seconds what things I need to check/change so that connection will be faster?

2) Also, I have read somewhere that changing the sga/memory parameters connecting to the database. is it true?

3) This is not concerned with above 2 questions. What should be the memory parameters size for a 8 gb database?

What I have is:

Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 1027605056 bytes
Database Buffers 33554432 bytes
Redo Buffers 5595136 bytes

View 14 Replies View Related

Forms :: Get Live Connection To Database?

Jun 19, 2012

Our database is on one site . There is a form which is used by users on another site. The internet connection is lost sometimes and the form that they use looses connection to the database. What I would like to do on the form is whenever the connection is lost to the database i,eORA-03114,I want to reestablish the connection so that the form can be used by users all the time.

View 1 Replies View Related

RAC & Failsafe :: JDBC Connection To A 10g Database?

Mar 30, 2005

The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.

if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.

View 5 Replies View Related

Forms :: Connection Between 6i And Oracle Database 11g

Jun 8, 2011

I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.

TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.

So whenever i want to login to the application i must to change the schema password, i need to use it directly.

View 2 Replies View Related

Forms :: Oracle 10g And Database Connection

Aug 8, 2011

Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

"ora-12154 tns could not resolve the connect identifier specified"

View the image below:

Here are the values in forms 10g tns

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......

and here the values of forms 10g SQLnet

# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)

What changes should i make to overcome this problem.

View 1 Replies View Related

Error Database Connection Closed?

Jan 29, 2013

I am gettting error message databse connection closed itried

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

[code]...

View 10 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

View 1 Replies View Related

SQL & PL/SQL :: Verifying Database Connection From External Java Process?

Apr 11, 2013

Is there any way, in Oracle where I can find out if there is any process from some machine which has been successfully connected database ?

View 5 Replies View Related

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.

View 3 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument

Attaching output session.

View 16 Replies View Related

Networking And Gateways :: Database Connection From Server To Client

Jul 15, 2010

I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.

BAM240T_EARTH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.154.119.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = BAM_240T.ipdc.com)
)
)

The database name is : BAM_240T.ipdc.com

Sqlnet.ora entry is

NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DEFAULT_DOMAIN= ipdc.com

When I connect to server I m getting the following error.

$ tnsping BA240T_EARTH

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 15:45:35

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

View 16 Replies View Related

Networking And Gateways :: How To Connect To Database When LAN / USB Datacard Connection

May 12, 2011

when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.

but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.

how can i connect to database when the LAN,USB datacard connection.

View 1 Replies View Related

SQL & PL/SQL :: ORA-02019 / Connection Description For Remote Database Not Found

Mar 12, 2009

I have created ".sql" script in Unix and I am trying to execute the script at SQL prompt. But I am getting the following error message after getting the output.

ORA-02019: connection description for remote database not found

Disconnected from Oracle Database 10g Enterprise Edition

Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

View 10 Replies View Related

Server Administration :: Database Resident Connection Pooling?

Jan 3, 2011

[URL]... says that session memory is maintained in the PGA (unlike shared server) and then gives a calculation for memory usage that I don't understand: it suggests that instead of there being one PGA per session, there is one PGA per pooled server plus a small allocation of 35k per session, but this is not what I see.

It's easy to demonstrate. As sys,
exec dbms_connection_pool.start_pool
and then launch any number of session with
sqlplus scott/tiger@127.0.0.1:1521/orcl:POOLED
and you'll see a process called Lnnn launched for each session:

[code]...

There is a mention of a process called the connection broker, but I can't see this in v$process.There is more detail in the OCI developers guide [URL]... which goes beyond my knowledge of application development.

View 3 Replies View Related

Connection To Database From Sqlplus Client Refuse ORA-03135

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

Forms :: Frm-40514 - Operation Requires A Database Connection

Sep 7, 2010

Am running forms 10g on windows vista service pack 1 and am having problems with the FRM-40514 error. (Operation requires a database connection).

I can connect quite alright from form builder, but when i run a form it request for login credentials again. I dont understand why this is so, when am already logged on in form builder.I tried to tacke this by creating the following

DECLARE
Uname VARCHAR2(80);
Pword VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
--pause;
--logout;
--message ('Logging out');
--synchronize;
[code]....

This code suppreses the logon screen and runs the form without logging on to the database. I know this because when I try to enter and execute query it brings up the message: FRM-40514: Operation requires a database connection.

View 15 Replies View Related

Security :: Audit User Connection On Reporting Database?

Jun 9, 2011

I want to audit user connection on my reporting database, and send a report to application team on monthly basis, with a list of users who are not connected for a month and remove them.

What would be best method, i know there is LOGON trigger, or database level auditing.

View 14 Replies View Related

Tnsnames.ora File Cannot Handle Connection Information For More Than One Database

Mar 12, 2007

I am having problem with my tnsnames.ora file.seems the file cannot handle connection information for more than one DB. It worked fine in the beginning, after that, whenever i had to connect to a DB, i had to keep switching and renaming 5 files, with respect to whichever database I want to connect to. this is the entries in the file, for 2 D's and it wont work, with just one in each it works, but not for two...

newtpt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(HOST = ipadd/virtualname)
(PORT = 1521)
[code]....

I am sure, nothing wrong with teh IP/virtualname, cause with just one of these in the file, they work excellent.I tried leaving line between the connection strings for each DB, without leavin lines, etc..

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved