Live online Oracle Database to test data source connection
I am working on C# windows application in which I have used Data link properties to allow the user to connect to variety of Data Source. I want to test Data Source connection to Oracle Database. The problem is we do not have Oracle installed in our company.
Are there any online live Oracle Database to which I can connect and test connection to Oracle Data source.
c# oracle
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
add a comment |
I am working on C# windows application in which I have used Data link properties to allow the user to connect to variety of Data Source. I want to test Data Source connection to Oracle Database. The problem is we do not have Oracle installed in our company.
Are there any online live Oracle Database to which I can connect and test connection to Oracle Data source.
c# oracle
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
add a comment |
I am working on C# windows application in which I have used Data link properties to allow the user to connect to variety of Data Source. I want to test Data Source connection to Oracle Database. The problem is we do not have Oracle installed in our company.
Are there any online live Oracle Database to which I can connect and test connection to Oracle Data source.
c# oracle
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
I am working on C# windows application in which I have used Data link properties to allow the user to connect to variety of Data Source. I want to test Data Source connection to Oracle Database. The problem is we do not have Oracle installed in our company.
Are there any online live Oracle Database to which I can connect and test connection to Oracle Data source.
c# oracle
c# oracle
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
asked Nov 23 '18 at 10:00
user2240189user2240189
663415
663415
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I don't know of any online Oracle database which would let you do something like that; I doubt that owners will allow such an action.
I'd suggest you to download & install Oracle 11g XE; it is a small footprint database, free to use (you won't have to pay anything) and will let you test what you're testing.
Download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Installation is simple; more or less a few NEXT clicks; just pay attention to question installer asks (usernames & passwords, ports).
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, runtnsping xeand you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), trysqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.
– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
|
show 1 more comment
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53444445%2flive-online-oracle-database-to-test-data-source-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't know of any online Oracle database which would let you do something like that; I doubt that owners will allow such an action.
I'd suggest you to download & install Oracle 11g XE; it is a small footprint database, free to use (you won't have to pay anything) and will let you test what you're testing.
Download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Installation is simple; more or less a few NEXT clicks; just pay attention to question installer asks (usernames & passwords, ports).
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, runtnsping xeand you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), trysqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.
– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
|
show 1 more comment
I don't know of any online Oracle database which would let you do something like that; I doubt that owners will allow such an action.
I'd suggest you to download & install Oracle 11g XE; it is a small footprint database, free to use (you won't have to pay anything) and will let you test what you're testing.
Download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Installation is simple; more or less a few NEXT clicks; just pay attention to question installer asks (usernames & passwords, ports).
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, runtnsping xeand you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), trysqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.
– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
|
show 1 more comment
I don't know of any online Oracle database which would let you do something like that; I doubt that owners will allow such an action.
I'd suggest you to download & install Oracle 11g XE; it is a small footprint database, free to use (you won't have to pay anything) and will let you test what you're testing.
Download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Installation is simple; more or less a few NEXT clicks; just pay attention to question installer asks (usernames & passwords, ports).
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
I don't know of any online Oracle database which would let you do something like that; I doubt that owners will allow such an action.
I'd suggest you to download & install Oracle 11g XE; it is a small footprint database, free to use (you won't have to pay anything) and will let you test what you're testing.
Download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Installation is simple; more or less a few NEXT clicks; just pay attention to question installer asks (usernames & passwords, ports).
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
answered Nov 23 '18 at 10:59
LittlefootLittlefoot
25.1k71634
25.1k71634
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, runtnsping xeand you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), trysqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.
– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
|
show 1 more comment
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, runtnsping xeand you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), trysqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.
– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Okay. I downloaded and installed Oracle 11g XE This opens a web page - get started "localhost:8080/apex/f?p=4950:2:8107036319133702::NO" Now how can I create database and test the connection. Actually I have never worked with Oracle before.
– user2240189
Nov 23 '18 at 16:01
Database is already created. Its name is, probably, "XE". At the operating system command prompt, run
tnsping xe and you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), try sqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.– Littlefoot
Nov 23 '18 at 17:57
Database is already created. Its name is, probably, "XE". At the operating system command prompt, run
tnsping xe and you should get response. In order to connect to the database, use SQL*Plus - at the command prompt (again), try sqlplus sys/its_password@xe as sysdba. As of the page you got - it runs Apex (development tool); if you aren't interested in it, don't use it.– Littlefoot
Nov 23 '18 at 17:57
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
If you use Docker already there are pre-built Oracle XE images. I do not know of any online open access Oracle database, but Oracle used to allow people to register for a online APEX account which gave you a user login to a database, but I never tried connecting direct to it, and it was a good 10-12 years ago.
– TenG
Nov 24 '18 at 13:55
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
That "free Apex account" is still available; I use it. But, as far as I can tell, it can't be accessed directly.
– Littlefoot
Nov 24 '18 at 14:00
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
I created workspace and now I am trying to read the EMP Table data. when I try to read the table data i get invalid table name.
– user2240189
Nov 24 '18 at 17:23
|
show 1 more comment
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53444445%2flive-online-oracle-database-to-test-data-source-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
