No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

When trying to connect to database using sqlplus it hangs
Next thread: Oracle 12c ORDER BY
Prev thread: Issue with the SQL Jobs

Message Score Author Date
If I set variables <b>ORACLE_HOME</b> and <b>ORACL...... John Whalen Nov 30, 2017, 21:22
Hello John, setting ORACLE_SID: local connectio...... Bruno Vroman Dec 01, 2017, 08:10
Are you connecting to a PDB, CDB, or non-CDB? I...... Tim Boles Dec 01, 2017, 16:44
Many thanks for your replies, my tnsnames for "FOU...... John Whalen Dec 01, 2017, 18:10
Tim Thank you for your reply, this is not a plu...... John Whalen Dec 01, 2017, 18:14
Hi, why don't you turn SQL*Net trace on and see...... Ales Kavsek Dec 05, 2017, 13:35

Follow up by mail Click here


Subject: When trying to connect to database using sqlplus it hangs
Author: John Whalen, United Kingdom
Date: Nov 30, 2017, 21:22, 13 days ago
Os info: Windows
Oracle info: Oracle 12c
Message: If I set variables ORACLE_HOME and ORACLE_SID the following command connects ok:

sqlplus sys/password as sysdba

However, if I run the following command it seems to hang:

sqlplus sys/password@FOUN as sysdba

If I try connecting to database FOUN using SQL Developer selecting it from the dropdown list and entering user/password combination I get nothing.

The Listener is running and TNSNAMES.ora appears ok.

tnsping FOUN comes back ok too.

What am I doing wrong.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: When trying to connect to database using sqlplus it hangs
Author: Bruno Vroman, Belgium
Date: Dec 01, 2017, 08:10, 13 days ago
Message: Hello John,

setting ORACLE_SID: local connection, irrelevant for the connection using SQL*Net "@foun" (is "foun" the local database?)

Note that "tnsping OK" is not enough... This shows that there is a listener for this ( host, port ) but maybe the info about service_name (or sid) is incorrect.

You should try with another account than sys, for example try an invalid usr/pwd: sqlplus nobody/nopwd@foun
In case of "success" you should receive the error code 1017 invalid usr/pwd.

Maybe you can share with us the content of your tnsnames.ora entry FOUN?

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: When trying to connect to database using sqlplus it hangs
Author: Tim Boles, United States
Date: Dec 01, 2017, 16:44, 13 days ago
Message: Are you connecting to a PDB, CDB, or non-CDB?

It makes a difference.

If it is a PDB then my first guess without much else to go on is that the PDB service has not been started in the CDB.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: When trying to connect to database using sqlplus it hangs
Author: John Whalen, United Kingdom
Date: Dec 01, 2017, 18:10, 13 days ago
Message: Many thanks for your replies, my tnsnames for "FOUN" (this is the local database) is as follows:

# tnsnames.ora Network Configuration File: D:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_FOUN =
(ADDRESS = (PROTOCOL = TCP)(HOST = FOIL-IFSBASE-T)(PORT = 1521))


FOUN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = FOIL-IFSBASE-T)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FOUN)
)
)


Also, I tried using another account and also the using an account that doesn't exist and same thing happens it just hangs.

Thanking you in advance for your help with this matter.

Kind Regards


John
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: When trying to connect to database using sqlplus it hangs
Author: John Whalen, United Kingdom
Date: Dec 01, 2017, 18:14, 13 days ago
Message: Tim

Thank you for your reply, this is not a pluggable database is is a non-CD and was created in DEDICATED SERVER MODE.

Thanks

John
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: When trying to connect to database using sqlplus it hangs
Author: Ales Kavsek, Slovenia
Date: Dec 05, 2017, 13:35, 9 days ago
Message: Hi,

why don't you turn SQL*Net trace on and see what is happening behind the scenes....

Open sqlnet.ora and add:

DIAG_ADR_ENABLED = OFF
TRACE_LEVEL_CLIENT = 10
TRACE_FILE_CLIENT=12c_sqlnet.trc
TRACE_DIRECTORY_CLIENT=T:\TRACE

Then try to login.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here