Oracle Internet Directory Exclusively - Getting Ora-12505?

Jul 8, 2013

I am using Oracle Internet Directory exclusively.  There are no tnsnames files in my environment. When I try to connect to database "A" on server "A" from server "B" using username/passwd@A, I get this error.ORA-12505: TNS:listener does not currently know of SID given in connectThis problem ONLY occurs from server "B"

. I have ten servers ALL configured identically, but only one has this issue.Remember ALL ldap.ora and sqlnet.ora files are identical. They are all using the same OID. 

View 6 Replies


ADVERTISEMENT

Security :: Oracle Internet Directory Tables

May 5, 2011

Does any technical details on the tables found in Oracle Internet Directory? I've checked eTRM and google etc.. - nothing there apart from very minor snippets. I'd like logical schema drawings (PDF) if possible or even a list of the tables and what they do as like the modules in EBS.

View 3 Replies View Related

Client Tools :: Unable To Open Oracle 9 ISQL Window In Internet Explorer 6?

Oct 12, 2010

I am unable to open Oracle 9 iSQL window in internet explorer 6. And i have two oracle version installed in my system are 9i and 10g.Now i am able to open the iSQL windows of 10g but not the 9i. It's happen after installing the Oracle 10g in system.

how i open both the iSQL windows in my system the Oracle 9i and 10g

View 3 Replies View Related

Forms :: Open Test Form In Oracle 10g Only Internet Explorer Is Opening With Blank Screen?

Apr 26, 2010

I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).

Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...

View 2 Replies View Related

Networking And Gateways :: ORA-12505 Error With SQL Developer

Jul 21, 2013

I installed oracle 11g successfully and was able to login with SQL plus.When I tried making a connection with the username and password via SQL developer I'm getting the ora-12505 error (picture is attached)

Printout of tnsname.ora:

# tnsnames.ora Network Configuration File: C:Oracle11gproduct11.2.0dbhome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
ORACLE11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle11g)
[code]....

getting sql developer connected with my oracle database?

View 13 Replies View Related

JDeveloper, Java & XML :: ORA-12505 / TNS / Listener Does Not Currently Know Of SID Given In Connect Descriptor

Jul 29, 2011

use oracle 11g and JDeveloper Studio 11.1.1.1.0 but cant connection between database and jdeveloper becouse these message error

Test failed: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Picture after the annex to the author of this code"isnrctl service" But under the error appears sometimes

View 8 Replies View Related

Express Edition (XE) :: ORA-12505 / TNS / Listener Does Not Currently Know Of SID Given In Connect Descriptor

Jun 2, 2013

DB is up and running fine

Connection test failed.
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

[code].....

View 8 Replies View Related

Database Instance Cannot Be Startup / Status / Failed ORA-12505

Jul 19, 2012

I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.

Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.

Today I found my instance failed startup.

In OEM, it is showing:

Agent Connection to Instance
Status: Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

In SQLPlus:

SQL> connect sys/password as sysdba
Connected to an idle instance
SQL> startup
ORACLE instance started.

[code]....

View 3 Replies View Related

Client Tools :: ORA-12505 - TNS - Listener Doesn't Currently Know Of SID Given In Connect Descriptor

Jul 25, 2011

When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".

i can't loose the builted tables and the information stored in them.My listener.ora file is :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
[code]....

View 36 Replies View Related

Database Access Error - Listener Refused Connection With ORA-12505 - TNS?

Jul 29, 2013

I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:

jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :

I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.

 If I change the URL syntax to following, it works

jdbc:oracle:thin:@IP address:port/service_name  

But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":"  does not work and "/"  works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same? 

View 6 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related

Security :: Possible To Create New Directory On Linux Fs From Oracle

Nov 29, 2010

I understand how to create a database directory object to point to a directory on the server File System. Is there a way to take the next step and create a new directory on the host file system from within Oracle?

View 8 Replies View Related

JDeveloper, Java & XML :: Writing XML To Oracle Directory

Apr 24, 2013

I have the following tables & data ..

create table identity (IDENTITY_ID varchar2(100));

Insert into identity values ('100');
Insert into identity values ('101');

create table CM_ENCOUNTER (IDENTITY_ID varchar2(100), CSN varchar2(100));

Insert into CM_ENCOUNTER values ('100','3a1');
Insert into CM_ENCOUNTER values ('101','1a2');

create table CM_PATIENT (IDENTITY_ID varchar2(100), GENDER varchar2(100), race varchar2(100));

Insert into CM_PATIENT values ('100','F','AA');
Insert into CM_PATIENT values ('101','M','HA');
Insert into CM_PATIENT values ('101','F','EA');

create table CM_ENCOUNTER_RFV
(IDENTITY_ID varchar2(100), CSN_ID varchar2(100), LINE varchar2(100), ENC_REASON_NAME varchar2(100));
Insert into CM_ENCOUNTER_RFV values ('100','23vx','2', 'phone');
commmit;

The output needed is :

<EvaluatePatient>
<PatientInformation>
<Patient>
<mrn>100</mrn>
<CSN>3a1</CSN>
[code]......

Based on the above, I created a table (which is of xml) ...

Create table temp_xml
as
Select XMLELEMENT("PatientInformation",(XMLELEMENT("Patient",
XMLELEMENT("mrn", s.identity_id),
XMLELEMENT("CSN", m.csn),
XMLELEMENT("Gender", p.gender),
[code]........

Now, I need to write each record into xml file. So, I used the below to write into file..but it gives me an error...wrong number of arguments to utl_file at line 14.

DECLARE
CURSOR c_data IS
SELECT * from temp_xml;
v_file UTL_FILE.FILE_TYPE;
BEGIN
[code]..........

View 4 Replies View Related

Server Utilities :: Oracle Directory And Datapump

Mar 31, 2010

We have three instances on the RAC, When I create a directory is there a default instance that it gets created on? When I execute an datapump export on instance 1, it works but on 2 and 3 it fails with error relating to directory.

Error -
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

Is my only option is to use shared storage space?

View 6 Replies View Related

Security :: Use Oracle Database On AIX With Active Directory

Apr 28, 2011

I'm checking the possibility to use Active Directory to log on the our Oracle databases. But only for dba's and developers, not application users. We use Oracle 10.2.0.4 (and soon 11g) As OS on the databaseserver we use AIX5L 5.3

Is it possible to implement Active Directory on databases running on AIX ? If it is possible, what must be done to get it to work, software ... etc ?

View 3 Replies View Related

SQL & PL/SQL :: Querying Active Directory From Oracle Database

Apr 16, 2012

I have a table in Oracle with a column userid and i have a userid column in Active Directory. based on this i want to query the Network ID and update in one of the Group in the Active Directory. how to get the results?

View 2 Replies View Related

Reinstall Oracle Server Using Existing Directory Structure?

Sep 28, 2010

howto to setup an oracle server and "import" my old databases just from the copied directory structure d:\oracle\product\... ("cold backup") to the new install.i was trying to setup an new server by shutting down the db and just copying back my data/control/log/*.ora files which doesnt seem to work.

i could see the old tables structures in the local sqlplus console, but the databases are not reachable over the net.
also the enterprise manager is not able to startup the dbs, it show just an running listener.

View 3 Replies View Related

Security :: Active Directory Routing To Oracle DB Server

May 1, 2013

I've Googled several times but the result is 50% null ^_^

How can I use the Active Directory to route the clients request to the Oracle Database server so that I can do the basic operation on the Oracle DB remotely.

As shown here [URL]........

View 1 Replies View Related

Server Administration :: How To Access Active Directory With Oracle Database

Oct 12, 2012

How to access Active directory(Microsoft 2003) with oracle database 11g.

View 1 Replies View Related

Client Tools :: SP2-0750 / Set ORACLE_HOME To Oracle Software Directory

Jan 29, 2010

bash: sqlplus: command not found
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

i install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.

View 18 Replies View Related

Open Excel File From Oracle Directory On Local Machine

May 31, 2013

I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .

View 1 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Server Administration :: Oracle And Active Directory Services - Missing Binaries

Mar 8, 2012

What two Active Directory services are stopped when you install Active Directory before Oracle 10g? I know the error message for that and I know why it happened but I just need to know the two services so I can start them again. I think it happened because I installed Active Directory first so when I installed Oracle second it stopped two services and I just need to know them. The error message is:

Active Directory is missing binaries, please restart and try again

View 2 Replies View Related

Forms :: Internet And Developer 6i

Sep 21, 2010

Is it possible to connect a Oracle based application designed in Developer 6i to a remote Oracle database server?

If YES then

How open can do this?

Else

View 4 Replies View Related

Forms :: How To Run Reports From Server Through Internet

Oct 30, 2012

How can we run forms & Reports from server through internet. I mean that i want to install forms, reports and database on server and not interested to install runtime on client computers so is it possible if yes then what can i do for this?

View 1 Replies View Related

SQL & PL/SQL :: Import Data Into Table From Internet

Jun 18, 2012

I have a table which contains curreny rates. I want to populate that table from internet's currency rates site. Is it possible?

View 6 Replies View Related

Forms :: Not Running On Internet Explorer

Apr 6, 2009

I am getting error while running oracle forms (oracle 10g) in internet explorer.

an unhandled win32 exception occurred in iexplorer.exe [7572]

View 6 Replies View Related

Forms :: On Cell Phone Through Internet Using Live IP?

Jan 21, 2012

Can I run oracle forms on cell phone through internet using live IP?

View 2 Replies View Related

Forms :: Calling Internet Explorer Within Form

Oct 4, 2011

is there any way to call internet explorer with in form.i want to provide net fascility to the users using 10g forms.

I have tried some beans but some restrictions are there.it is not properly displaying page.

View 3 Replies View Related

Forms :: Internet Explorer 8 Not Working As Browser For 10g?

Mar 1, 2010

For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.

View 3 Replies View Related







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