The Oracle database error up sqlplus connection-CodePudding

We use a computer is Windows xp system, the client is Oacle11g, installed in the client connected to the database connection of test can be connected, but then again connection has been described below error,
ORA - 12514 TNS listener request in current descriptor can not connect to identify service
But also can appear error "listener" free
What reason is this excuse me, is there any solution,

CodePudding user response:

Look at the service is stopped,

CodePudding user response:

Look at the server listening state

CodePudding user response:

reference 1st floor wmxcn2000 response:

see if service is stopped,

manager service is started, including CMD have tried, no problem,

CodePudding user response:

refer to the second floor baidu_36457652 response:

look at the server monitoring state

start listening is normal, but in the CMD command prompt today have run error prompt, but couldn't find where the problem is, and is not even log in what went wrong,

CodePudding user response:

You tnsping IP: port/service_name see

CodePudding user response:

reference 5 floor baidu_36457652 reply:

you tnsping IP: port/service_name see

is this installation path or what or which files,

CodePudding user response:

refer to 6th floor vv9128_41 response:

Quote: refer to the fifth floor baidu_36457652 reply:

You tnsping IP: port/service_name see

what is this installation path or which files, or

CMD running orders

CodePudding user response:

refer to 7th floor baidu_36457652 response:

Quote: refer to the sixth floor vv9128_41 response:

Quote: refer to fifth floor baidu_36457652 response:

You tnsping IP: port/service_name see

what is this installation path or which files, or

CMD command run under

log file is wrong, recently, see the installation log, this time to find to monitor log files,

CodePudding user response:

refer to 7th floor baidu_36457652 response:

Quote: refer to the sixth floor vv9128_41 response:

Quote: refer to fifth floor baidu_36457652 response:

You tnsping IP: port/service_name see

what is this installation path or which files, or

CMD command run under

TNS - 12514: TNS: listeners in the descriptor can not connect to identify the requested service

Type='UNKNOWN'

Level='16' host_id='PC - 20180410 vpvy'
Host_addr='192.168.0.117 & gt;
11 - April - 2018 10:20:38 * (CONNECT_DATA=https://bbs.csdn.net/topics/(SID=former) (CID=

(the PROGRAM=D: \ app \ Administrator \ perl \ bin \ perl exe) (HOST=vpvy PC - 20180410) (USER=SYSTEM))) * (ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1486) PORT=) * establish * wouldn * 12505

Type='UNKNOWN' level='16' host_id='PC - 20180410 vpvy'

Host_addr='192.168.0.117 & gt;

TNS - 12505: TNS: listeners can't identify current specified in the connect descriptor SID

Type='UNKNOWN'

Level='16' host_id='PC - 20180410 vpvy'
Host_addr='192.168.0.117 & gt;
11 - April - 2018 10:20:32 * (CONNECT_DATA=https://bbs.csdn.net/topics/(SID=former) (CID=

(the PROGRAM=D: \ app \ Administrator \ perl \ bin \ perl exe) (HOST=vpvy PC - 20180410) (USER=SYSTEM))) * (ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1472) PORT=) * establish * wouldn * 12505

Type='UNKNOWN' level='16' host_id='PC - 20180410 vpvy'

Host_addr='192.168.0.117 & gt;

Can see is that what is going wrong,
Also, perl. Exe how the file should be open, file icon is a horse,

CodePudding user response:

Sid or service_name is wrong

CodePudding user response:

Not wrong, is your machine before loading the client then however there is no use of discharge clean

CodePudding user response:

references to the tenth floor baidu_36457652 response:

wrong sid or service_name

That in the which files which are modified to run the program, how to change,

CodePudding user response:

The picture above is to monitor log information content,