Forms :: REP-0501 / Unable To Connect To The Specified Database

Nov 7, 2012

I'm able to log-in the application and use any form but when I'm trying to run any report I got following error message on the client machine.

REP-0501: Unable to connect to the specified database.

ORA-01017: invalid username/password; logon denied

View 6 Replies


ADVERTISEMENT

Windows / .NET :: Unable To Connect Database From SQL Dev

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

Server Administration :: Unable To Connect To Database

Nov 27, 2010

I have installed a database in D drive. I want to create another database in the same machine. I tried installing the new database using DBCA. Installation was ok. I added entry in TNS file.

When i try to login to this new database from other machine, i am unable to connect to this database. I made an entry in TNS on my local machine. It says the user id /password is wrong, even though they r correct. I am using the same password to delete the database.

View 3 Replies View Related

Server Administration :: Unable To Connect To Database?

Sep 26, 2013

I migrated one database ( DB1) from old database server to new database server where user accounts were locked before migrating the database.But migration was successful and database and accounts got created in new database server.

In old database server , user accounts status is locked and in new database server user accounts are open but still i am unable to connect to database using new user in new database server.

why im unable to connect to database whose accounts are open?

View 6 Replies View Related

Networking And Gateways :: Unable To Connect To Database?

Feb 1, 2012

I am getting beloww error very frequently in database log and not able to connect to the database.

************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err 12535

TNS-12535: TNS:operation timed out
ns secondary err 12606
nt main err 0
nt secondary err 0
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************

View 2 Replies View Related

Client Tools :: Unable To Connect To Database?

Oct 4, 2013

I am getting error in my database....

SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

I tried shutdown and startup

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted

[code]....

ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>

View 1 Replies View Related

Networking And Gateways :: Unable To Connect To Database

Jun 27, 2011

am getting this message when am connecting to a database :

ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA

am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected

i searched the net and my database provider guided me to this log URL.....

how to set my ORACLE_HOME environment variable.

View 9 Replies View Related

Clusterware :: Unable To Connect Database Service?

Apr 29, 2013

We are getting problem while installing OID Infrastructure on one node.

metadata repository database: 10g R1 (10.1.0.2.0)
OID: 10g R1 (10.1.0.2.0)

We had installed in node 1 & now the partition is shifted to node2 ,But installation on OID infrasturcture, when we aretrying to connect repository database, it says, hostname:<PORT> service may not be avaialble, listener may not be up.unable to connect
orcl.test.com

whereas the service is running & listener is up. We copied inventory location and oraInst.loc and oratab file from node1 to node2, But still unable to connect metadata repository from infrastructure node.What are we missing here..

View 0 Replies View Related

Forms :: Unable To Connect To Destination

Oct 2, 2007

I m using Oracle Forms 6i and Oracle 10g Express Edition. I am having the following error message when I am trying to connect to the database from client.I have dont following configuration in my client's FORM's TNSNAMES.ORA file.

0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)

In the above configuration

0001 = my connect string.
BankVigil = My Oracle database server hostname.

View 9 Replies View Related

Forms :: ORA-12203 - TNS - Unable To Connect To Destination?

Sep 18, 2012

I am having trouble connecting to oracle forms 4.5, I keep getting an "Ora-12203:TNS:unable to connect to destination" eror message. I am able to connect using sql plus or other similar application so there is no problem with my tnsnames.ora file.

View 4 Replies View Related

Server Administration :: Unable To Connect To Database / ORA-12560 / TNS / Protocol Adapter Error

Feb 7, 2013

In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.

In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.

Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :

ERROR:ORA-12560: TNS:protocol adapter error

In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?

View 6 Replies View Related

Server Administration :: Unable To Connect To Oracle 11g Using Forms 4.5

Apr 21, 2011

We are unable to connect to Oracle 11.1.0.7.0 from Oracle Forms 4.5..However we are able to connect using Oracle forms 6i

Now Forms 4.5 is old and not supported, however apart from Tests I will need prove it to the higher ups...Do we have any link, document which will cover such compatibility issue?

View 7 Replies View Related

Forms :: FRM-41213 / Unable To Connect To Report Server

Jul 5, 2013

I'm trying to catch the FRM-41213 ERROR (Unable to connect to the report server), so I can switch the generation to another report server. At runtime the message FRM-41213 appers but I'm unable to catch it using 'exception' or 'error_code'.

Here's my

begin
v_rep := run_report_object (repid, pl_id);
if err_type = 'FRM' and (err_code = '41213' or err_code = '41214') then
message('ss error catch');
end if;
exception
when others then
message('ss error to handle');
end;

View 1 Replies View Related

Forms :: FRM- 41213 / Unable To Connect To Report Server

May 18, 2010

"FRM- 41213: Unable to connect to the report server error"

View 17 Replies View Related

Client Tools :: Unable To Connect Database / ORA-27101 / Shared Memory Realm Does Not Exist

Feb 21, 2012

[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 have only one database...

TNS.......
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
APPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 72.0.0.11)(PORT = 1521))

[code]...

View 6 Replies View Related

Forms :: Client-server Environment - Unable To Connect To Destination

Nov 29, 2010

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.

star.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROtoCOL = TCP)
(Host = server)
(Port = 1521)
)
)
(connect_DATA = (SID = ORCL)
)
)
--------------------------------------------
it gives me error:

ORA-12203:TNS :unable to connect to destination

View 6 Replies View Related

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

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.

View 3 Replies View Related

Forms :: How To Connect Database

Jul 18, 2011

while new form open i need to connect the data base.

View 5 Replies View Related

Forms :: How To Connect 6i To Run On SQL Database

Aug 26, 2010

How can I connect forms6i to run on SQL database ?

View 4 Replies View Related

Forms :: How To Connect Remote Database Using 6i

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

Forms :: How To Connect Database With Static IP

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

Forms :: Using 6i To Connect Oracle Database 10g Express

Oct 8, 2011

I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express.

As I would like to

I use Oracle Net8 Easy Config to create a connection.

According to "tnsnames.ora", the parameter of connection is as follows;

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)

Unfortunately, when I use Oracle Net8 Easy Config to test the connection, an error message is prompted as follows:

Connecting....

The test did not succeed.

ORA-03106: fatal two-task communication protocol error

There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.

View 1 Replies View Related

Windows :: Connect Forms 6i With MS Access Database

May 26, 2013

How to connect forms 6i with ms access.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

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

Forms :: How To Connect Excel With Oracle Database Via 10g Login Screen

Jul 20, 2010

In fact I have around 50 excelbooks that are connect with oracle via ODBC/or any other way. My task is to build the login screen on form 10g. This form will validate the user via .dll after successfully validation, Form will connect to specific oracle user. This Login Screen will call the new form that will execute the query for the list of excel sheet [table that will keep the name, description and path of the excelbook]. User will select the one excelbook to open. As user will select Excelbook should be open. Now this excel book should be connected with specific oracle user.

Question 1: How to open the excelbook, that excelbook should be connected via form 10g login screen. After connection excel has its own micros to run he query from oracle database.

Question 2: How I can create the mirco into form 10g to run into excelbook/excelsheet.

Question 3: How I can pass the query or function/procedure to the excelbook/excelsheet.

View 3 Replies View Related

Unable To Connect DB From LAN PC?

Mar 12, 2013

I hv no problem connecting oracle at localhost. but when connecting using another pc on the same LAN, the sqldeveloper returned an error saying

IO Error: The Network Adapter could not establish the connection on the linux where oracle installed, iptables is disable, but firewalld is enabled, so I did a

'firewall-cmd permanent zone=home --add-port=1521/tcp'

yet the remote pc still prompt the same IO error. what should I do to have oracle accept connection from the LAN and WAN ( I hv setup virtual server on router)

View 12 Replies View Related

Unable To Connect To Sql Server From 11g?

Jun 21, 2012

When we tried to query a data from the sql server we are getting the below generic error message i

SQL> select * from all_users@testing
2 /
select * from all_users@testlink1
*
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 TESTLINK1

below are the details setup / configuration done by us:

os :windows 2008 server.
database "oracle standard edition
Command Line input /output:
C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc
Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
Oracle Database Gateway for ODBC

[code]....

View 1 Replies View Related

Forms :: Unable To Save Record In Database

Jun 4, 2010

I developed one form having 3 blocks(query_find,Summary and detail). If i do some changes in the 3rd block then press F4 key it's prompting "Do u want to save the Changes?[YES/NO/CANCEL].

If i press "YES" it displays message "1 Records applied and Saved. But the record is not saved in the database.

View 5 Replies View Related

Unable To Connect To Oracle 10g Through TOAD

Jul 28, 2010

I have installed Oracle 10g XE in my laptop having Windows 7 home 64 bit OS..I have created some users in the oracle and iam able to connect these users through cmd prompt..But the issue is that iam unable to connect to the database through TOAD..

I have given the user name and password and database as XE and connect using as : XE but still iam getting the error as "TNS could not resolve the connect identifier (XE).

View 12 Replies View Related

Unable To Connect In TOAD In ORACLE 11g

Jan 4, 2011

Unable to connect in TOAD in ORACLE 11g through sys user.

I am using Toad for ORACLE version 9.0.0.160 and ORACLE 11gR2 (11.2.0.1).

I make the FALSE to "sec_case_sensitive_logon" parameter hence not able to login through sys user. I can logged in through system user without any issue.

View 4 Replies View Related







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