Back to the office today and found unable to connect to database website,
Check, found that Oracle has stopped,
I use the following instructions to reopen
up sqlplus/nolog
The connect/as sysdba
SQL> Startup
SQL> The exit
LSNRCTL> Start
Open the Oracle,
But I want to check the log and see why Oracle is stopped, someone put it stopped or affected by what,,,
Excuse me each elder younger brother how to office, (the younger brother is a novice, many still do not understand)
thank you
CodePudding user response:
Please everybody comment,,,!CodePudding user response:
Their top,,,!Very urgent, please elder grant instruction help,,,!
CodePudding user response:
The alert after 50 lines up to look at it,CodePudding user response:
& lt; MSG time='2017-03-17 T16: dress. 352 + 07:00 org_id=' oracle 'comp_id=' TNSLSNR '
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;17-16:28:39 MAR - 2017 * 12502
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;TNS - 12502: TNS: the listener received no CONNECT_DATA from client
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;17-16:31:39 MAR - 2017 * 12502
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;TNS - 12502: TNS: the listener received no CONNECT_DATA from client
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;17-16:34:39 MAR - 2017 * 12502
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;TNS - 12502: TNS: the listener received no CONNECT_DATA from client
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;17-16:37:39 MAR - 2017 * 12502
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;TNS - 12502: TNS: the listener received no CONNECT_DATA from client
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;17-16:40:39 MAR - 2017 * 12502
Type='UNKNOWN' level='16' host_id='DB01'
Host_addr='127.0.0.1 & gt;TNS - 12502: TNS: the listener received no CONNECT_DATA from client
This is alert Log
Predecessors, please help
CodePudding user response:
TNS - 12502 error is generally by the client tnsnames. Ora does not include the CONNECT_DATA cause, check your tnsnames. Ora file