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


ADVERTISEMENT

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

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

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

Server Administration :: Unable To Connect To 11g EM?

Nov 22, 2012

1-How much memory is needed to use the Oracle 11g Enterprise Manager? (Probabely other parts need less memory than EM)

2-When i try to connect to Oracle 11g , get the following error?

View 2 Replies View Related

Reports & Discoverer :: Unable To Connect To DB From 10g

Feb 27, 2012

I have installed Windows7 64bit on my laptop and then installed Reports10G. I am not able to connect to DB from Reports10g, Its gives below error -

REP-0501: Unable to connect to the specified database
ORA-02248: Invalid Option for ALTER SESSION

Same Reports10g is able to connect to DB on Windows XP machine. Database version is 11g which is remote.

View 5 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

Unable To Connect OE Once Change Sys Password

Jan 7, 2013

some days ago we chaged sys,system and sysman password using SQL console. ORACLE 10.2.0.1.0 Now Backups and SQL console loggins are ok but we cant connect OEM console having: insufficient privileges, logging as sys / as sysdba

we reload (start / stop) oem console service and now the OM page is unable to be desplayed having (when starts finished no error messages was found):

The webpage cannot be found

or

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

but all is OK !!The DB SO is linux unbrekeable.

View 2 Replies View Related

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

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

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

Networking And Gateways :: Unable To Connect To DB From Client

Dec 3, 2011

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

listener.ora
------------
[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/netw
ork/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
[code]........

View 4 Replies View Related

Windows :: Unable To Connect SQLState IM004

Jan 10, 2007

I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. When connected to the terminal server via RDP as a domain administrator, the odbc connection functions appropriately. When connected to the terminal server console as a standard user, the odbc connection functions appropriately.When connected to the terminal server via RDP as a standard user, I get the error: "Unable to connect SQLState= IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home is defined first in my path environment variable (path - c:oracleclientin;). I select my folder options (there is no security tab, windows 2000) I select sharing, then permissions. I allow 'Everyone' and 'Authenticated Users' full control, change & read permissions. I reboot the server.

View 4 Replies View Related

Networking And Gateways :: Unable To Connect To OPMN

Jan 25, 2011

Getting Unable to connect to OPMN. Opmn may not be up while checking the status of instance.

View 2 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

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 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

Client Tools :: Unable To Connect To Oracle From Toad

Jul 28, 2010

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.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Anu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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.

View 18 Replies View Related

Networking And Gateways :: ORA-12203 TNS - Unable To Connect To Destination

Oct 17, 2012

I install oracle database 11g and developer 6i on windows7 64bit server everything is working fine on the server and i install developer 6i on windows XP on client now i'm getting "ora-12203:TNS: unable to connect to destination" when trying to connect the server. i have check the TNSNAMES.ORA file the configuration is fine. then why i'm getting this message?

View 5 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

RAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager

Aug 8, 2011

when i'm creating ASM instance, i'm getting an error

Quote:ora-29701: unable to connect to cluster manager

for this there were some workaround given to start css.

i tried everything from /etc/init.d/init.cssd start/enable but nothing worked, then i tried with executing

localconfig delete
localconfig add====>it failed and recommended to go for reset option

when i executed localconfig reset i get this following error:

Quote:
[root@rac2 bin]# sh localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

[code]....

This is the same case when i used reset option.

View 3 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

Networking And Gateways :: Client Machines Unable To Connect DB?

Sep 2, 2011

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.

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

Server Administration :: Unable To Connect Both SQL And RMAN Prompt?

Jul 21, 2011

now DB is hanging; i am not able to connect both SQL and RMAN prompt. Is it possibel to move some old archives using ASMCMD prompt to datafile mount point location? Once i got some free space, then i can try connect RMAN and fire my script manually to take the backup and delete the same. ....

ASMCMD [+QSTAGE_T1_BACKUP_01/QSTAGE/ARCHIVELOG] > ls -ltr
cdType Redund Striped Time Sys Name
Y 2011_07_15/
Y 2011_07_16/
Y 2011_07_17/
Y 2011_07_18/
Y 2011_07_19/
Y 2011_07_20/
i have free space at mount point : +QSTAGE_T1_DATA_01/QSTAGE/DATAFILE

i need to backup the archives first before deletion..as those are required for Streams.

backup script:

run {
backup archivelog all delete completed before 'sysdate-1';
}

note: i would like to remove the file which are older than one day

View 8 Replies View Related

XE :: Unable To Connect To XE Service When Running Cisco AnyConnect VPN

Jun 4, 2013

We have the Oracle 11g XE database installed on a Windows 7 laptop. The Oracle XE database runs fine when the laptop not connected to a network, when connected to our corporate lan, or when connected to a cable-modem. However, when running under the Cisco AnyConnect VPN client, we are unable to connect to the Oracle XE service.

I have tried to resolve this, but am stuck. I do not if this issues is caused by:
1. There is no IPv6 address listed for the AnyConnect VPN (from ipconfig /all)?
2. Something regarding split-tunnelling that must be configured on the VPN?
3. Can the Oracle XE database run under an SSL VPN?

Below is the output of when I try to connect the Oracle XE service via sqlplus.
**************************
The OracleXETNSListener service is starting.
The OracleXETNSListener service was started successfully.

The OracleServiceXE service is starting..............
The OracleServiceXE service was started successfully.

C:ProgramDataoraclexeapporacleproduct11.2.0serverin>sqlplus system/password@XE

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 31 07:03:24 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12546: TNS:permission denied

Enter user-name:
**************************
listeneralertlog,xml
<msg time='2013-05-31T07:03:24.950-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:ProgramDataoraclexeapporacleproduct11.2.0serverinsqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
[code].........
**************************
listener racelistener.log file

Started with pid=3688
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
[code]......
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:07:43

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 31-MAY-2013 07:01:12
Uptime 0 days 0 hr. 6 min. 31 sec
[code].......

The command completed successfully
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:08:13
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER

The command completed successfully

View 4 Replies View Related







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