Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies


ADVERTISEMENT

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

Client Tools :: Unable To See Database List In Dropdown Of PL/SQL Developer

Mar 27, 2013

I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.

View 4 Replies View Related

Client Tools :: Oracle SQL Developer Connection

Feb 1, 2011

I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.

I have given user name: ora; pswd: ora.

In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora

But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.

So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.

1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.

I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])

3] Is there any editor for practicing sql & pl sql queries. where I can download it.

View 6 Replies View Related

Client Tools :: Connect From Oracle 9i To Sql Developer?

Aug 30, 2011

how i can add new connection to sql developer i had made a database name abb how i will connect that to sql developer.

View 12 Replies View Related

Client Tools :: Compare Schemas And Database Objects Using TOAD And SQL Developer

Apr 17, 2013

My primary objective was to compare objects in schemas in two different databases and find out the differences, Execute DDL's in the database where objects are missing and syn schemas in two different databases. So I need to compare schemas in databases. make a comparison of database objects existing in schemas in two different databases. I'd like to see if I can get a list of pro and cons between Toad and SQL Developer for comparing schemas pros and cons. navigation in SQL Developer to compare schemas.

Connect to Source
Connect to Target
Compare schemas with different object types
Find out differences
Generate DDL's for the missing objects or for the objects in difference report
Run them in missing instace(Source/Target)
Make sure both are in sync.

View 2 Replies View Related

Client Tools :: Login To Database Through Pl/sql Developer - ORA-01031 / Insufficient Privileges

Oct 28, 2013

While trying to logging to database through pl/sql developer, getting error as "ORA-01031: insufficient privileges".But am able to logging by system.

As per the instruction by the below link, checked the privileges of ord_dba. All are correct. Now, i am in puzzle to rectify the error.

[URL]

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

Client Tools :: Display Windows On Oracle SQL Developer?

Sep 10, 2013

find in the menu of Oracle SQL Developer how to display the result of explain plan for .. I have just "Succès de l'élément plan FOR".

View 3 Replies View Related

Client Tools :: Connection From Oracle SQL Developer To MS SQL Server

Jun 8, 2010

I'd like to make a connection from Oracle SQL Developer to a MS SQL Server DB. How can I do that?

View 2 Replies View Related

Client Tools :: No Server Option In Oracle SQL Developer?

Jan 31, 2013

Using SQL Developer I am able to login using oracle credentials but I dont see any option for SQL Server. I see both Oracle and Access. Why I am not able to see the SQL Server option in SQL Developer tool? I need the SQL Server option because I want to transfer some tables from SQL Server database to Oracle database.

View 1 Replies View Related

Client Tools :: How To Install Oracle Developer Suit 10g On Windows 7 32 Bit

Oct 3, 2011

can u give me link from where i have to learn step by step how to install oracle develor suit 10g on windows 7 32 bit

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

Accessing Oracle On VirtualBox From Host Virtual Machine?

Jul 18, 2013

I have a Host system of windows 8, installed the Virtual Box Latest edition.The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.The VM is set to HOST ONLY network setting. Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect theSQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect. do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.

View 10 Replies View Related

Oracle 11g - Java Virtual Machine Could Not Find Main Class Program Will Exit

Jul 26, 2013

In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit. 

Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .

View 1 Replies View Related

Client Tools :: How To Configure Rumba Emulator For TN3270 Interface

Dec 9, 2011

how to configure Rumba emulator for TN3270 interface?

View -1 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Developer Tools :: Add New Oracle Database Connection In Visual Studio 2012 Explorer?

Feb 22, 2013

1> I installed "Microsoft Visual Studio Express 2012 for Web[32 Bit]" on Win-7[64 Bit] platform.
2> Then installed Oracle Database 11gR2 [64 Bit]

What else do i need to install, in order to Add a new database connection through Visual Studio 2012's Database Explorer.

View 5 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: Audit Records From Specific Machine / Terminal Only?

Apr 11, 2011

Is there any tool available for audit records from a specific Machine/terminal Only?

View 1 Replies View Related

Client Tools :: PL/SQL Developer And Tnsnames.ora 10g?

Apr 3, 2008

I'm trying to connect to my DBs.I installed Oracle Client 10g, but PLSQL Dev. 7.1.4 doesn't find my tnsnames.ora.

View 4 Replies View Related

Client Tools :: PL/SQL Developer - ORA-12514 TNS?

Sep 30, 2012

I am using PL/SQL Developer.When i am trying to login with PL/SQL Developer i am getting the error

ORA-12514:TNS:listner does not currently know of service requested in connect descriptor

How to solve this one?

View 4 Replies View Related

Client Tools :: Getting Error While Connecting To DB In PL/SQL Developer

Dec 5, 2012

I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.

PL/SQL developer

Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g

I am getting the below error

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

View 1 Replies View Related

Client Tools :: Sql Developer Startup Is Slow?

Apr 15, 2013

I am finding Oracle sql developer start up to be very slow.It takes more than 5 - 10 mins to startup.It seems for long startup.Its installed on Windows 7 machine in c: drive. Want to know what is causing it to be too slow.virus scanning, JVM startup.... ?

FYI
---------
Oracle Sql developer Version -- 3.2.20.09
Java(TM) Platform -- 1.6.0_43

View 4 Replies View Related

Client Tools :: Generating Tkprof From SQL Developer

May 8, 2013

How do i get tkprof trace file in sqldeveloper tool ? I donot have access sql in command mode.

View 5 Replies View Related

Client Tools :: Characters Differences Between SQL+ And SQL Developer

Sep 20, 2013

we have an issue on a server, where if we insert a value containing foreign characters from SQL+ we see it screwed up from SQLdev, whereas if we do the same insert from SQLdev it's then screwed up in SQL+.

All operations are performed on the DB server itself, SQLdev connection type is TNS and the entry being used is the same as the one used by SQL+.We checked v$nls_parameters and the values contained there are the same from both SQL+ and SQLdev.

View 8 Replies View Related

Client Tools :: SQL Developer Not Working Constantly

Aug 31, 2013

sql developer tool which i am using to run query for every hour getting disconnected and to run a new query after an hour,i need to make a new connection again.Could you tell me an alternate way that should not disconnect the session in sql developer.

View 6 Replies View Related

Client Tools :: Submit Request Via SQL Developer?

Oct 3, 2012

I'm using the below code in SQL Developer, trying to submit a request:

Declare
vRequest_id NUMBER;
BEGIN
Fnd_Global.apps_initialize(9205,20639,200);

[code]...

However, when i check the fnd_concurent_request table, nothing is there.as I just used the following code in SQL Developer and it worked:

Declare
L_NUMBER number;
BEGIN
L_NUMBER := WF_ROLE_HIERARCHY.AddRelationship('UMX|XXR|GLFSA_RADG_BA','FND_RESP|SQLAP|XXR_GL_JNL_ADMIN|STANDARD');
END;

Is it due to the different types of packages im using? i.e. public/private? or is there an api i can use in SQL Developer to submit the request?

View 8 Replies View Related

Client Tools :: List Of Tables In PL/SQL Developer

Feb 4, 2010

I can do any sql commands against the schema I want (PSUSYS) with my username(SCHWAN) in the sql window, but when I want to export a table(created with a different schema) no tables are listed in the export window. This does work for my coworkers with the same access.

At one time this used to work so I'm wondering if it is a parameter that I inadvertently changed.

View 5 Replies View Related







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