Windows :: ORA 12154 From Other Machine

Feb 14, 2011

I have Oracle installed on a Windows 2008 server. When the database was created, it could not register with the listener (I confirmed that the listener service was running but when I started creating the database it stopped).I completed the db creation and started the listener again and tried "alter system register" but that didn't work either.Then I manually edited listener.ora and added an entry to the SID_LIST_LISTENER and I could successfully connect using sqlplus dba1@orcl/password from the same server.

Now, I tried to use the instant client to connect to the database from another Windows 2008 server. I copied the TNSNames.ora from the db server to this new server. When I run sqlplus dba1@orcl/password I get the ORA 12154 error.

Why would this happen from a remote machine which is on the same network? Ping from one server to the other works (both ways).

View 5 Replies


ADVERTISEMENT

ORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?

Oct 7, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.

Oracle Client: 10.2.0.3 32 bit

Windows OS: Windows server 2008 R2 64 bit

I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).

ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]

View 1 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

XE :: Will 11G Work On 64 Bit Windows Machine

Oct 3, 2012

I would like to down load and install 11g XE beta but I do not know if it will install and run on my 64 bid Windows machine. I had trouble with the 10 G XE trying to down load it on 64 bits.

If I cannot use it on 64 bits could I make it work if I down load Unbuntu Linux? System info as follows:

OS Name     Microsoft Windows 7 Professional
Version     6.1.7601 Service Pack 1 Build 7601
Other OS Description      Not Available
OS Manufacturer     Microsoft Corporation
System Name     XXXXXXXXX (censored)
[code]........

View 1 Replies View Related

Windows :: Oracle 10g On Virtual Machine 2003 X64

Jul 9, 2010

Does already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?

Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?

View 9 Replies View Related

Windows :: OScanner - Java JRE Installed On Machine

Mar 16, 2011

I have recently downloaded (the zip file for) OScanner (1.0.6) and have Java JRE installed on my machine. However, I am experiencing some difficulty in running the scanner. how I should start to use this tool, once I have downloaded the zip file.

View 8 Replies View Related

How To Do DDL Sync On Windows Machine Through Command Line Prompt

Mar 26, 2013

We have siebel server on windows machine and db server on unix box. We have done some modification(added columns) in siebel tools level. Now we want to ddl synch through command line prompt. how ot do ddl sync?

View 4 Replies View Related

Windows :: Installing Oracle 10g On Win 2008r2 64 Bit On HP ML110 G7 Machine

Jun 29, 2012

we are having problem installing oracle 10g on windows 2008r2 64 bit on a HP ML110 G7 machine.

we have 10203_vista_w2k8_x64_production_db.zip
downloaded from oracle site.

View 3 Replies View Related

Installation :: Oracle 10g Client Install Skips - Windows 7 Machine

Nov 15, 2013

I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.

But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path.  It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors. 

View 15 Replies View Related

Client Tools :: Oracle / Crystal Reports On Windows 7 64Bit Machine?

Feb 1, 2011

I recently got a new PC at work which is Windows 7 64 bit.

We run lots of crystal reports(1000's) that pull data from an oracle back end.

I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.

However, when I use crystal to access the TNS Name it gives me the following error.

[URL]

My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".

I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.

View 7 Replies View Related

Windows :: Copy A File To DB Server From A Remote Machine Using Plsql / Java

Oct 2, 2013

We want to copy a file from a remote machine to the DB server. copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql

I've used Java and a wrapped it into a PL/SQL procedure so I can do :

exec run_os_command(p_command => 'copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql');

The file was not copied.

I have mapped \<IP_ADRESS>SHARED_FOLDER to x: for example and issued : exec run_os_command(p_command => 'copy x:some_file.sql d:copied_file.sql');

The file was not copied.

But when I issued from the OS prompt copy x:some_file.sql d:copied_file.sql then the file is copied.

What can I add to the PL/SQL procedure so it wil work ?

View 19 Replies View Related

Best Way To Change Language Of Windows Oracle Client Machine Edit Registry

Jun 29, 2012

We have installed oracle client on Windows machine and despite selecting language as English

when look in registry shows NLS_LANG as

AMERICAN_AMERICA.WE8MSWIN1252.

What is the best way to change language of Windows oracle client machine edit registry.

View 2 Replies View Related

Forms :: Installing Weblogic On Windows 7 X86 Machine / Restarting Admin-server Hangs

Jul 5, 2011

Im trying to install Weblogic/Forms on a Windows 7 x86 machine. Its for the developers to use.But when I run the config.bat and is creating the domain and installing Forms builder and the other stuff the installation hangs at: step restaring admin server started.

Log:

Stopping Derby Server...
Starting AdminServer
Starting the domain ...
DEBUG : Loading the 32 bit dll here
DEBUG : Loading DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll
DEBUG : Loaded DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll

View 1 Replies View Related

Installation :: Oracle Database 11gR2 On Virtual Box on Windows 32bits Machine

Oct 31, 2013

I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.

View 6 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Database Auto Start With Machine On And Shutdown With Machine Shutdown

Sep 2, 2012

i install oracle 10g on linux on perform the following step but my database is not auto start with the machine

Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.

The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.

-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.

In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.

If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.

Automate Startup/Shutdown of Oracle Database on Linux

Step 01: Be sure that oratab file is correct and complete.

Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.

Database entries in the oratab file have the following format:

$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.

If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.

Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.

a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.

# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.

[Code].....

View 1 Replies View Related

ORA-12154 / TNS - Could Not Resolve The Connect Identifier Specified

Nov 3, 2010

I have installed Oracle 10g client and am trying to connect to an Oracle 9i database with it. I have already created the required Listner and service names. But when I try to login to SQL * Plus , it gives me the following error: Ora-12154: TNS: Could not resolve the connect identifier specified

Could Oracle 10g client connect to a 9i database? If so how do I fix this problem?

View 4 Replies View Related

ORA-12154 - TNS - Could Not Resolve Connect Identifier Specified

Dec 14, 2012

OS:Solaris
DB:10G

I am trying to create a DR on the same server as that of primary server.

Specifictaions:
Primary server:test
DR: testdr

I have made thetns entries and i am also able to tnsping both test and testdr. But below is the error that is being constantly getting logged in the alert of primary server.

Error 12154 received logging on to the standby
Fri Dec 14 20:09:36 2012
Errors in file /11g/oradata/admin/ettest/bdump/ettest_arc0_7336.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC0]: Heartbeat failed to connect to standby 'ettestdr'. Error is 12154.

View 3 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Could Not Resolve Service Name

Dec 18, 2003

I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :

SQL> connect sys/oracle@summ as sysdba

NB: I have no problem when I use

SQL> connect sys/oracle@orcl as sysdba

Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files

# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[code]....

View 39 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Service Name

May 15, 2013

What I'm trying to do Establish a remote connection to an Oracle 9i R2 9.2.0.8.0 database using "Oracle Provider for OLEDB 9.2.0.7.0" (I was unable to find an 9.2.0.8.0 equivalent) on a Windows Server 2008 R2 64-bit machine.

My configuration

sqlnet.ora
# SQLNET.ORA Network Configuration File: D:oracleora92
etworkADMINsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = B81DCS.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)

[code]....

View 21 Replies View Related

Networking And Gateways :: ORA-12154 - TNS - Could Not Resolve Service Name?

May 14, 2013

My database is oracle 9i when try to connect oracle database using putty to AIX server like..

$ sqlplus

SQL*Plus: Release 9.2.0.8.0 - Production on Wed May 15 09:50:01 2013

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: sys@testdb as sysdba
Enter password: (given password)

(then showing the following Error message)

ERROR:
ORA-12154: TNS:could not resolve service name

But I try to connect using SQLPlus window then it is successfully connected also if i try to connect using command line window like..

C:>sqlplus /

Enter user-name: sys@testdb as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
JServer Release 9.2.0.8.0 - Production

SQL> select name from v$database;

NAME
---------
TESTDB

then it is also successfully connected to database..what is the problem .

my TNSLISTENER.ora file is

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SINGERDB =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 7 Replies View Related

Precompilers, OCI & OCCI :: Ora-12154 When Working With Pro*fortran

Dec 14, 2008

when i try to include a select statement in my pro*fortran code I am getting Ora-12154 TNS could not resolve service name

The select query is given below.

EXEC SQL SELECT PERIOD_NAME, UBR, UER
1 INTO :ENAME, :SAL, :COMM
2 FROM TEST

I am using the 32bit version of libraries and the compilation is happening without any problem. Earlier when i tried with 64 bit libraries i was getting errors during compilation.

Note: I am not getting any errors when I run only the conect statement.

View 8 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Service Name?

Dec 24, 2010

My server database is not connected today whenever I try to connect it. It was working properly till yesterday but today morning when I came to office and want to connect with server then my database server show the message "ORA-12154 TNS: could not resolve the service name" and not connected.

View 9 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Couldn't Resolve Service Name

May 19, 2010

I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error. ORA-12154: TNS:could not resolve service name...I am using the following method.

1. Login to the database server via putty.
2. sqlplus A/****

for the user A,the step2 is working fine. But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.

db01: sqlplus B/*****
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name

Enter user-name: I don't know why this error is coming for a particular user only.

View 21 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Dec 4, 2012

While connecting to Database through sqlplus as sysdba, error pop-up.

SQL> conn sysdba@disdevt
Enter password: *******
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL>

but i am able to log-in to database through pl/sql developer. Since TNS is same for both.

View 6 Replies View Related

Networking And Gateways :: ORA-12154 - Could Not Resolve Connect Identifier Specified

Dec 26, 2008

I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).

When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.

D:Documents and SettingsBAR>tnsping appdev

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:22:57

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

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters

D:Documents and SettingsBAR>tnsping vislinux

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21

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

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

TNS-03505: Failed to resolve name

and when I use TOAD to connect the schema's I get the following error ORA-12154:TNS:could not resolve the connect identifier specified

Here are the contents of my TNSNAMES.ora file

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

[Code]....

View 4 Replies View Related

Networking And Gateways :: ORA-12154 / Could Not Resolve Connect Identifier Specified

Mar 17, 2011

What works: There is a oracle database on the local network. I'm connecting to it through my web server on my pc (apache/php). I have installed "oracle_instantclient10". It works fine - i can connect to oracle db, queries are executed fine.

What doesnt work: I'm trieing to connect to the same oracle db from a Linux server, but i get the error:

ORA-12154: TNS:could not resolve the connect identifier specified

My linux server can connect to remote oracle db, because "nmap ORACLE_DB_MACHINE_IP -PN", gives me answer "1521/tcp open oracle". I have the same firewall allowance with my winXp pc.

I use the same "TNSNAMES.ORA" and "SQLNET.ORA" files on both: linux server, winXp pc. The only difference between winXp and linux machines is that winXp uses oracle instant client version 10.2, and linux uses version 11.2.

View 16 Replies View Related

Precompilers, OCI & OCCI :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Jun 25, 2009

I have a 10.2.0.3 server installation on Solaris x86-64.I am trying to compile the sample1 proc demo program with the 32 bit make file :

compilation is successfull, however - I am unable to connect to Oracle ( TNS error ) my TWO_TASK is set correctly.

rstnyc01:>make -f demo_proc32.mk sample1
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc32.mk OBJS=sample1.o EXE=sample1 build
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc32.mk PROCFLAGS="" PCCSRC=sample1 I_SYM=include= pc1
proc iname=sample1 include=. include=/export/home/oracle/product/10.2_s/precomp/public32 include=/export/home/oracle/product/10.2_s/precomp/public include=/export/home/oracle/product/10.2_s/rdbms/public include=/export/home/oracle/product/10.2_s/rdbms/demo include=/export/home/oracle/product/10.2_s/plsql/public include=/export/home/oracle/product/10.2_s/network/public

[code]....

ORACLE error--

ORA-12154: TNS:could not resolve the connect identifier specified

However - when I am doing the exact same thing with the 64 bit make file, I am able to connect with no issues :

rstnyc01:>make -f demo_proc64.mk sample1
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc64.mk OBJS=sample1.o EXE=sample1 build
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc64.mk PROCFLAGS="" PCCSRC=sample1 I_SYM=include= pc1
proc iname=sample1 include=. include=/export/home/oracle/product/10.2_s/precomp/public include=/export/home/oracle/product/10.2_s/rdbms/public include=/export/home/oracle/product/10.2_s/rdbms/demo include=/export/home/oracle/product/10.2_s/plsql/public include=/export/home/oracle/product/10.2_s/network/public

[code]....

View 1 Replies View Related

Client Tools :: ORA-12154 / TNS - Could Not Resolve Connect Identifier Specified

Nov 21, 2012

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.

View 10 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Connect Identifier Specified

Mar 7, 2011

While connecting to oracle database, i'm getting

SQL> conn red_user/red@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

View 6 Replies View Related







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