Can't connect to oracle remotellyarchive log backups in oracleData Guard Oracle 11gMove Data on Oracle...
I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?
Can inspiration allow the Rogue to make a Sneak Attack?
Does the in-code argument passing conventions used on PDP-11's have a name?
New invention compresses matter to produce energy? or other items? (Short Story)
Naming Characters after Friends/Family
School performs periodic password audits. Is my password compromised?
Different Account page layouts, what are they?
PTIJ: Aliyot for the deceased
What is better: yes / no radio, or simple checkbox?
Paper published similar to PhD thesis
I can't die. Who am I?
What's the difference between Compensation, Indemnity, and Reparations?
Can a Mimic (container form) actually hold loot?
Create chunks from an array
3.5% Interest Student Loan or use all of my savings on Tuition?
Is there a math expression equivalent to the conditional ternary operator?
Under what conditions would I NOT add my Proficiency Bonus to a Spell Attack Roll (or Saving Throw DC)?
Do natural melee weapons (from racial traits) trigger Improved Divine Smite?
Can you run a ground wire from stove directly to ground pole in the ground
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
Why do phishing e-mails use faked e-mail addresses instead of the real one?
What is Tony Stark injecting into himself in Iron Man 3?
Short story about an infectious indestructible metal bar?
Python 3.6+ function to ask for a multiple-choice answer
Can't connect to oracle remotelly
archive log backups in oracleData Guard Oracle 11gMove Data on Oracle 11gCan't start managed server in Oracle Weblogic 10.3.2Oracle Enterprise Manager licenseOracle databasecannot connect to oracle after server crashUnable to connect to an Oracle XE database from Oracle Sql DevloperCan oracle handle SERVER = POOLED (DRCP) and SERVER = DEDICATED clients simultaneously?Oracle 11g free server frequently raising ORA-12519 during a healthy connection
I've been trying to install oracle in my home for more than a month now, but I still having some issues.
Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine.
The installation seems alright. Locally it works the way it's supposed to do.
However I can't logon remotely in sqlplus/sqldeveloper/Visual Studio or whatsoever.
Initially I was getting a ORA-12514 error. After I corrected the TNS I got stuck on this situation whenever I try to logon:
C:>sqlplus gama@main
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 17 09:22:43 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
The connection get stucked after I give the password and hit enter.
There is no error message. I tough that I would receive a timeout, but no matter how long I wait, nothing happens (yesterday, it took a 3 hour skyrim session before I give up and hit CTRL+C)
Again, I can connect locally and also I have no firewall problems (I've even disabled the firewall in client and server). The client machine can connect to the server via Remote desktop. The connection to Oracle is established as I can confirm in netstat and finally, here's the output of the LSNRCTL services for the server while in the 'stuck state':
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "MAIN.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "MAINXDB.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: WIN2K8-ORACLE, pid: 1712>
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN2k8-ORACLE)(PORT=49160))
The command completed successfully
Note the service MAIN.WIN2k8-ORACLE has 1 established connection.
I do have some experience developing for Oracle but this is the first time I try to install it.
Thanks in advance.
====EDIT======
Folow my tnsnames.ora:
MAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <MY SERVER'S IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MAIN.WIN2k8-ORACLE)
)
)
oracle-11g
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I've been trying to install oracle in my home for more than a month now, but I still having some issues.
Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine.
The installation seems alright. Locally it works the way it's supposed to do.
However I can't logon remotely in sqlplus/sqldeveloper/Visual Studio or whatsoever.
Initially I was getting a ORA-12514 error. After I corrected the TNS I got stuck on this situation whenever I try to logon:
C:>sqlplus gama@main
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 17 09:22:43 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
The connection get stucked after I give the password and hit enter.
There is no error message. I tough that I would receive a timeout, but no matter how long I wait, nothing happens (yesterday, it took a 3 hour skyrim session before I give up and hit CTRL+C)
Again, I can connect locally and also I have no firewall problems (I've even disabled the firewall in client and server). The client machine can connect to the server via Remote desktop. The connection to Oracle is established as I can confirm in netstat and finally, here's the output of the LSNRCTL services for the server while in the 'stuck state':
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "MAIN.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "MAINXDB.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: WIN2K8-ORACLE, pid: 1712>
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN2k8-ORACLE)(PORT=49160))
The command completed successfully
Note the service MAIN.WIN2k8-ORACLE has 1 established connection.
I do have some experience developing for Oracle but this is the first time I try to install it.
Thanks in advance.
====EDIT======
Folow my tnsnames.ora:
MAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <MY SERVER'S IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MAIN.WIN2k8-ORACLE)
)
)
oracle-11g
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04
add a comment |
I've been trying to install oracle in my home for more than a month now, but I still having some issues.
Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine.
The installation seems alright. Locally it works the way it's supposed to do.
However I can't logon remotely in sqlplus/sqldeveloper/Visual Studio or whatsoever.
Initially I was getting a ORA-12514 error. After I corrected the TNS I got stuck on this situation whenever I try to logon:
C:>sqlplus gama@main
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 17 09:22:43 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
The connection get stucked after I give the password and hit enter.
There is no error message. I tough that I would receive a timeout, but no matter how long I wait, nothing happens (yesterday, it took a 3 hour skyrim session before I give up and hit CTRL+C)
Again, I can connect locally and also I have no firewall problems (I've even disabled the firewall in client and server). The client machine can connect to the server via Remote desktop. The connection to Oracle is established as I can confirm in netstat and finally, here's the output of the LSNRCTL services for the server while in the 'stuck state':
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "MAIN.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "MAINXDB.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: WIN2K8-ORACLE, pid: 1712>
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN2k8-ORACLE)(PORT=49160))
The command completed successfully
Note the service MAIN.WIN2k8-ORACLE has 1 established connection.
I do have some experience developing for Oracle but this is the first time I try to install it.
Thanks in advance.
====EDIT======
Folow my tnsnames.ora:
MAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <MY SERVER'S IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MAIN.WIN2k8-ORACLE)
)
)
oracle-11g
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
I've been trying to install oracle in my home for more than a month now, but I still having some issues.
Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine.
The installation seems alright. Locally it works the way it's supposed to do.
However I can't logon remotely in sqlplus/sqldeveloper/Visual Studio or whatsoever.
Initially I was getting a ORA-12514 error. After I corrected the TNS I got stuck on this situation whenever I try to logon:
C:>sqlplus gama@main
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 17 09:22:43 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
The connection get stucked after I give the password and hit enter.
There is no error message. I tough that I would receive a timeout, but no matter how long I wait, nothing happens (yesterday, it took a 3 hour skyrim session before I give up and hit CTRL+C)
Again, I can connect locally and also I have no firewall problems (I've even disabled the firewall in client and server). The client machine can connect to the server via Remote desktop. The connection to Oracle is established as I can confirm in netstat and finally, here's the output of the LSNRCTL services for the server while in the 'stuck state':
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "MAIN.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "MAINXDB.WIN2k8-ORACLE" has 1 instance(s).
Instance "main", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: WIN2K8-ORACLE, pid: 1712>
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN2k8-ORACLE)(PORT=49160))
The command completed successfully
Note the service MAIN.WIN2k8-ORACLE has 1 established connection.
I do have some experience developing for Oracle but this is the first time I try to install it.
Thanks in advance.
====EDIT======
Folow my tnsnames.ora:
MAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <MY SERVER'S IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MAIN.WIN2k8-ORACLE)
)
)
oracle-11g
oracle-11g
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
edited Jan 17 '12 at 13:29
Gama Felix
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
asked Jan 17 '12 at 11:52
Gama FelixGama Felix
12
12
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04
add a comment |
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04
add a comment |
1 Answer
1
active
oldest
votes
Please post output of lsnrctl services. You can try to bounce DB and listener.
You can also try to add UR=A setting to your tnsnames.ora
...
( SERVICE_NAME=srv1 )
( UR=A )
...
answered Feb 14 '12 at 6:39
SamSam
91
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
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%2fserverfault.com%2fquestions%2f350595%2fcant-connect-to-oracle-remotelly%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
Please post output of lsnrctl services. You can try to bounce DB and listener.
You can also try to add UR=A setting to your tnsnames.ora
...
( SERVICE_NAME=srv1 )
( UR=A )
...
answered Feb 14 '12 at 6:39
SamSam
91
add a comment |
Please post output of lsnrctl services. You can try to bounce DB and listener.
You can also try to add UR=A setting to your tnsnames.ora
...
( SERVICE_NAME=srv1 )
( UR=A )
...
answered Feb 14 '12 at 6:39
SamSam
91
add a comment |
Please post output of lsnrctl services. You can try to bounce DB and listener.
You can also try to add UR=A setting to your tnsnames.ora
...
( SERVICE_NAME=srv1 )
( UR=A )
...
answered Feb 14 '12 at 6:39
SamSam
91
Please post output of lsnrctl services. You can try to bounce DB and listener.
You can also try to add UR=A setting to your tnsnames.ora
...
( SERVICE_NAME=srv1 )
( UR=A )
...
answered Feb 14 '12 at 6:39
SamSam
91
answered Feb 14 '12 at 6:39
SamSam
91
answered Feb 14 '12 at 6:39
SamSam
91
answered Feb 14 '12 at 6:39
SamSam
91
91
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f350595%2fcant-connect-to-oracle-remotelly%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
Please update with your tnsnames file.
– kubanczyk
Jan 17 '12 at 13:04