conect to repository - Developer Suite Software Configuration Manager (SCM)(Archived)

Dear sir
I will want to conect to the repository in another city
what wide is going to be my band width
thank you in advanced 

Mehdi,
As always the answer is 'it depends'. If you are downloading
large files from the repository you will need something better
than a normal telephone modem.
I have used Designer to access a repository over a normal phone
line, this works but would get very boring if this were the only
option.
ISDN/ADSL or cable modem would be more sensible.
David

Related

10G -> Windows XP -> Huge Problems!

Guys,
I'm a relative newbie. I have done plenty of scripting for Oracle databases... but never installed it on my own machine.
I need to make an application for a university project (C#.Net) so want a VERY basic oracle database; something I can connect to from my machine and other machine via the internet... create tables / query etc etc
I downloaded 10G and installed it as a personal type. Where ever possible I picked 'typical' etc. There were a few problems in the installation... error findng TCP host etc and later on 'Error starting DBConsole'.
All these errors seemed to be small as the installation carried on just fine. After finishing I was shocked by the amount of resources Oracle seemed to want... from 350mb in use to 720mb!
Then when I try and connect to the database it always times out!
Anyone help? Is there an extremely cut down version? I just want the basics... none of this java stuff thats sucking 150mb of ram!
Cheers
Tom 
Choose 'Custom Installation' and switch off all options, you don't want to use. 
Werner,
Thanks for your reply. Ive tried that with all the stuff that looks like its 'extra'... but obviously i cant pick exactly what i need for the barebones as i dont know whats used for what...
But I've narrowed it down as much as I can. Read on the net installing while on a net connection might be a prob... so will try that first :) 
Did you get it running. If so, how?
I am also getting problem when installing 10g on my laptop. I read that it might help giving a permanent Ip instead of a DHCP one.
I have 10G installed on an HP laptop.
Everything is fine as long as I run at my home office. When I take it on the road, none of the java components will run. This is because the java components use oc4j and some of the folders it uses have the installation ip address hardwired in the folder name. I'm hoping for a method to fix that so I can run this thing anywhere.

Connect from SQL*Developer to apex.oracle.com

hi folks -
I downloaded XE and SQL*Developer (onto my husband's PC)
I understand how to connect from SQL*Developer to XE, and I understand that I can use Apex from within XE.
However, I'm working from my mac, which does not have windows; therefore, while I can run SQL*Developer, I do not have XE.
Can I connect from SQL*Developer to the tables I'm creating at apex.oracle.com?
Thank you
(sorry if I am not using the right words; hopefully I've articulated the question properly)
Marion (I'll also post this over at SQL*Developer) 
Marion,
Simple answer. Nope, since the hsoted instance is closed for access to tools like that... You can however use the sql development tools in APEX..
Thank you,
Tony Miller
Webster, TX 
Marion,
As you've no doubt found out from the SqlDeveloper forum you can easily connect from Developer to XE on your husband's pc IF you are both on the same network, wireless or otherwise. In fact you can run Apex remotely on your machine using your browser. When you start Developer you should see the connections panel. Click on the Green + icon.on the panel that appears enter a connection name the username and password you used when you installed XE. For Hostname enter the name of your husbands pc (or the ip address), 1521 for the port and xe for the sid. Click the test button and it should say status: success. You can click the icon next to Connectons in the white part of the panel and it should open with the list of objects. Piece of cake. Then you can open your modeling tool, do the same thing and reverse engineer your tables, thereby creating your first ER model.
Keep smiling,
Bob R
Edited by: bobrudolf on Oct 24, 2009 8:23 PM 
Hi Bob -
No one from SQL*Developer has responded yet, so I truly appreciate your information.
I think I have been running Apex remotely using my browser.... I've been doing that since before he downloaded XE.
I will try this on Sunday with my husband - we are networked but I don't know his IP address, or username or p/w from when he installed XE.
However - I would only be able to open my "modeling tool" if I were using one! I've been creating the tables directly in the SQL Workshop of Apex (altho, I have also been doing it in Filemaker since it's semi-familiar to me)
Thanks -
Marion 
#Bob
Very exciting stuff.... but I think I'm in over my head...
I'm connected from my SQL*Developer to my husband's computer... now I have to think about what this means.
OK - I just created a table from within SQL*Developer - and yes, SQL*Developer gave me a lot more feedback about the health and well-being of my SQL*Command than working from within SQL*Workshop.....
I need a bit of hand-holding to understand what happened, and what happens next.
I think I just created a table that is LIVING on my husband's computer. I'm connected to it via the network.
Problem #1: I do not see that table existing anywhere via SQL*Developer (yes, i refreshed).
Problem #2: If I want to work with that table from within Apex, you said that I can connect via my browser..... and I'm not sure how or what that means...
I thought you were saying that I should log into apex.oracle.com, using his account information.... but that doesn't make sense... because that site is for demo purposes only - I don't think I can connect from the demo site to the data on my husband's computer.
So I'm drawing a blank on how I can work from my mac with Apex with the tables (aside from using the demo hosted version and tables I create online for learning purposes)
Thanks Bob
(by the way - I don't think your email works in your profile)
Marion in NY 
Marion
You would probably be best getting APEX up and running on the same machine that you have 10g XE installed on. Then you can can work on your project locally. You can't use SQL Developer to connect to the database underlying the Oracle hosted instance of APEX (apex.oracle.com).
Cheers
Ben 
Thanks Ben.
for the moment, I'll continue to learn from my mac, using the Oracle hosted instance of APEX without the benefits of SQL*Developer.
If I can make a bit more progress on the project (and hire a mentor/guide), I'll be convinced that I can pull this together. And then I'll install windows on the mac so I can run XE, so I can run SQL*Developer.
Marion

How best to use two desktops but one schema?

How best to use two desktops but one schema?I have at home the home version of SQL DEVELOPER, 4.1....I have my main PC in the family room where I do most of my study and learning.But I set up an second PC in the dungeon with the thought that when I am sent there I could study and use SQL DEVELOPER there.On both PCs I have Oracle SQL DEVELOPER and all the needed parts installed and working.The PCs are connected together on a home network using a LAN line.When I first started this about five months ago I noticed that if I say made a table and various other things from one PC it show up on the other.I figured that sense I just had the schema the same name that when I connected that the Oracle corporation the schema was really the same even though I had two installs, one on each PC.I thought this was cool.  But then I thought that I really wanted the PC in the dungeon really be separate so I have it a different user name and a different schema name.  That worked so that whatever I did on that PC did not affect the schema on the living room PC.  That did fine.  But truth is I never used it.Well sense then there is a baby in the house and sometimes I need the quite of the dungeon.  So now I want what I do on the up stairs PC to show up on the dungeon PC.I think there is a way to get things back the way they were but not sure how to proceeed.Any suggestions are welcomed. 
Just use ONE Oracle DB and use the same username/schema to hold your tables/views/objects. It does NOT matter which machine the database is on.
I suspected so much but after poking around I have not figured out how to do that.As the home version only allows only one schema I don't know how to proceed.  I can delete the one but getting the one that I have on the up stairs PC - that I am not sure how to do. 
As the home version only allows only one schema
I have NO IDEA what you are even talking about. There is no such thing as a 'home version' of Sql Developer. And Sql Developer is NOT a database so does NOT have schemas.
Well, I likely do not either.  Doing some more research I should state that I am using “Oracle Database 11g Express Edition” and have that installed on both PCs.  And of course SQL Developer installed with it.  I made a 'connection' on each PC and I think I am confusing a connection with a SCHEMA.  I guess the 'data base' is buried in the  “Oracle Database 11g Express Edition”  and when I made my connection and gave it a name that is closely related to a SCHEMA but not quite the same thing.  Regardless, I think what I want to do is make a new connection on the dungeon PC and maybe change the Hostname to a path to the data base that is on the living room PC.  I really want to be able to use my PC in the dungeon to use the database/schema/connection that I am using in the living room.  Can such a thing be done?  If so, how?
The remote connection should look like this.... On your living room PC1. Open connections (menu => View/connections) and add new connection.2. give it a name that means something to you.3. set connection type to basic.4. for hostname, enter the IP address of your dungeon PC.5. port should default to 1521 which is probably the right one.6. SID/Service name.  I never can remember which one is which, so try one then the other.  But in the place you type, put in the name given to the instance of Oracle running on the dungeon pc.  ("instance name" is the keyword to use if you need to search for more info on the topic)7. in the username and password fields at the top, use the same ones that worked when you were actually on the dungeon PC.8. click that Test button to make sure things work and then his the save button when it does. It has been a loooong time since I used the express edition and it may only permit connections from localhost.  If that is the case then you are out of luck (might be able to install PuTTy on the dungeon PC to do port forwarding, but that is a more involved topic) Good luck and don't let non-answers from other users discourage you!
  Doing some more research I should state that I am using “Oracle Database 11g Express Edition” and have that installed on both PCs.  And of course SQL Developer installed with it.  I made a 'connection' on each PC and I think I am confusing a connection with a SCHEMA.  I guess the 'data base' is buried in the  “Oracle Database 11g Express Edition”  and when I made my connection and gave it a name that is closely related to a SCHEMA but not quite the same thing.  Regardless, I think what I want to do is make a new connection on the dungeon PC and maybe change the Hostname to a path to the data base that is on the living room PC.  I really want to be able to use my PC in the dungeon to use the database/schema/connection that I am using in the living room.  Can such a thing be done?  If so, how?
Then you have posted in the wrong forum. This forum is ONLY for Sql Developer questions. Please mark this thread ANSWERED and repost in the General Database forumGeneral Database Discussions This is what I first said:
Just use ONE Oracle DB and use the same username/schema to hold your tables/views/objects.
 
It does NOT matter which machine the database is on.
Create one Oracle DB on ONE machine. Then you can connect to that DB from ANY machine located anywhere in the world.

Is there a mobile version of the Admin Tool?

I know this is a long shot, but... Many times I go to meetings and a question arises about the RPD.If I didnt bring my laptop, I have to go get it, It would be nice if there was an Android version of the BI Admin Tool, or an RPD viewer. I dont want to use remote desktop or anything like that. Is there a way to view an RPD file downloaded to my Android?No need to make any changes, just view and navigate the RPD.
Short answer: No. Longer answer: No. Clicked too soon. Wanted to say if you use the RPD in XML form in a git repository you can use a mobile git app but that's probably not what you're looking for.
Export to CSV so that you have at least something available? Or always bring your laptop to the meeting.
Or remote to your desktop from the mobile phone ;-)
Try to enable Repository Documentation. this is the best.

Cannot access my new database. -listener-?

Hi everyone. Please help me as I am [still] new to Oracle.
Installing Oracle9iDB version 2 on windows xpPro, enough gigs and ram.
This is a DEVELOPMENT machine and I need to access the database locally on this machine.
I have installed twice. The first time I chose one of the pre-defiend databases and I had no problem accessing it with a variety of tools.
But when I added my own [empty] database, hoping to create tables via SQL+ or other tools, I couldn't get rights or access it.
So, I deleted the entire shelack-bang and re-installed, this time telling it that I don't want ANY pre-defined anything, database samples, or schemas. I need to try this like I will by my customer.
Ok. So it let me create a database, via the wizard, assign a SYS password.
I also setup a LISTENER (although I suspect something is wrong there).
BUT, if I try to access it via the EMP(locally) it tells me that there is no LISTENER, although there is!
Also SQL+ does not allow access, but maybe I don't understand what HOST_NAME to supply.
Question. Since for now, I am using the same machine for the database server as well as the client connectiong to it, do I still want the listener to use tcp? (I also tried nmp and it didn't help.)
Oh, the administration tool does show that the database is UP and running.
I am willing to UN-INSTALL and erase every iota of the previous installs. (Please tell me how.)
Can you please tell me what to watch out for when installing again?
Do I need to reintall to get it straight?
Thank you all in advance.
-Nat 
Nathan,
if you sent me your listener.ora, tnsnames.ora and sqlnet.ora (you can find them in your Oracle_HOME/network/admin directory), I'll have a look for you.
(arbe#rscafans.be).
Kind regards,
Rik 
Thank you.
I have since re-installed, this time allowed it to create a general-purpose database, and all is well. I can now access both, the gp database and the database I am designing/learning/training.
Thanks again.
-Nat

Categories

Resources