Sp2 0640 not connected как исправить

Sp2 0640 not connected как исправить

Error: “SP2-0640: Not connected” when creating an Oracle user for Symantec DLP

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Data Loss Prevention

Issue/Introduction

When creating an Oracle user, you execute oracle_create_user.sql from SQL*Plus, and the following stream of errors appears. You are logged in as SYS as SYSDBA.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected

Cause

The Oracle Listener process was not successfully created.

This error indicates that the TNSNAMES.ora file was not created during the installation process.

Specifying the local service will create a TNSNAMES.ora file which can be used as one of the methods for resolving a connection string. While creating the protect user, the script attempts to connect to the database using TNS to resolve the connection. Without that specific information, SQL*Plus has no way to connect and generates the “SP2-0640: Not connected” error.

Resolution

Start the Oracle Net Configuration Assistant

  1. In Windows, navigate to Start > All Programs > Oracle-OraDb11g_home1 > Configuration and Migration Tools > Net Configuration Assistant.
  2. Select Local Net Service Name configuration.
  3. Click Next.
  4. Click Add, and type in a service name (the Database SID, typically “protect”).
  5. Click Next.
  6. Accept the default of TCP, and click Next.
  7. Enter the hostname or IP of the Oracle database server, and accept port 1521 (the default listening port).
  8. Click Next.
    You are presented with the opportunity to test.
  9. Click YES, and then click Next. The test may fail, which is OK.
  10. Click Change Login.
  11. Change the password to the same password as the Oracle SYS account.
  12. Click Next.

Feedback

thumb_up
Yes

thumb_down
No

Источник

Я новый пользователь sqldeveloper и пытаюсь создать нового пользователя.

Я использую эту командную строку: create user <myusernanme> identify by <password>

Но я получаю такую ​​ошибку: SP2-0640: Not connected

Может кто-нибудь мне помочь?

2 ответа

Лучший ответ

Спасибо ! Я обнаружил, что для создания нового пользователя я должен войти в систему. Я подключил ультилистатор SYS с помощью команды

CONNECT SYS AS SYSDBA

Создайте моего пользователя с помощью команды

CREATE USER <username> IDENTIFIED BY <password>

И наконец я даю ему разрешение на создание собственной сессии

GRANT CREATE SESSION TO <username>;

Но как отключить пользователя SYS?


1

Jessy
9 Окт 2021 в 09:49

Источник

April 30, 2021

I got ” SP2-0640 Not connected. ” error in Oracle database.

SP2-0640 Not connected.

Details of error are as follows.

SP2-0640 Not connected.

Cause: The PASSWORD command was issued when there was no connection to the Oracle instance.

Action: Connect to the Oracle database before re-issuing the PASSWORD command.






Not connected


This SP2-0640 errors are related with the PASSWORD command was issued when there was no connection to the Oracle instance.





  



                       
  






Connect to the Oracle database before re-issuing the PASSWORD command.


1)DBUA upgrade to 12.2 fails with  below error which can be seen in  catupgrd0.log file


get_instance_status_and_name: unexpected error in exec_DB_script
output produced in exec_DB_script [
SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 9 13:02:32 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> ERROR:
ORA-39710: The database mode conflicts with the connection type.
SQL> SQL> SQL> 2 SP2-0640: Not connected
SQL> SQL>
SQL> ] end of output produced in exec_DB_script
catconInit: unexpected error in get_instance_status_and_name
End of catcon Errors


2)Manual upgrade fails with error:




get_instance_status_and_name: unexpected error in exec_DB_script
output produced in exec_DB_script [

SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 1 14:11:17 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> ERROR:
ORA-12560: TNS:protocol adapter error

SQL> SQL> SQL> 2 SP2-0640: Not connected
SQL> SQL>
SQL> ] end of output produced in exec_DB_script
catconInit: unexpected error in get_instance_status_and_name




You do not use operating system authentication to connect to the database.


When using DBUA,Providing SYSTEM username and password in “Select database” screen  .


To solve this error, perform the following steps.


1)When running DBUA:





  



                       
  






Leave “User Name” and “Password” fields blank if you have OS authentication to SYS user.


Or


Provide the “SYS” username and “<sys_password>” (in case if you are calling DBUA screen for non-oracle user).


2) For manual upgrade ,invoke the command and enter the passowrd when asked for:


dbupgrade -u SYS


Read the following post, because the following error is related with this.




ORA-39710: the database mode conflicts with the connection type




Do you want to learn Oracle Database for Beginners, then read the following articles.




Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )





  



                       
  








  1,548 views last month,  3 views today










Источник












I have 2 oracle db (ORCL and ORCL24) and I can’t connect to ORCL database


enter image description here

«Выполняется» = Started


enter image description here


my listener.ora 


 SID_LIST_LISTENER01 =   (SID_LIST =
     (SID_DESC =
       (GLOBAL_DBNAME = ORCL24)
       (ORACLE_HOME = G:appproduct12.2.0dbhome_1)
       (SID_NAME = ORCL24)
     )   )

 SID_LIST_LISTENER =   (SID_LIST =
     (SID_DESC =
       (SID_NAME = CLRExtProc)
       (ORACLE_HOME = G:appproduct12.2.0dbhome_1)
       (PROGRAM = extproc)
       (ENVS = "EXTPROC_DLLS=ONLY:G:appproduct12.2.0dbhome_1binoraclr12.dll")

 )
 (SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = G:appproduct12.2.0dbhome_1)
   (SID_NAME = ORCL)
 )   )

LISTENER01 =   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1526))   )


 LISTENER =   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     )
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )   )





ADR_BASE_LISTENER01 = G:appproduct12.2.0dbhome_1log


ADR_BASE_LISTENER = G:appproduct12.2.0dbhome_1log





  



                       
  












Barbaros Özhan's user avatar







        asked Dec 25, 2018 at 16:32
    




Andrei Yakubets's user avatar








5




                     Load 7 more related questions


                     Show fewer related questions






Источник









Recommended Answers





  



                       
  












It means the client side tool SQL *PLUS is not connected to the server or was disconnected because of server restart or network disconnect.




Jump to Post






All 5 Replies














Member Avatar









  



                       
  















debasisdas


580







Posting Genius 






Featured Poster









15 Years Ago






It means the client side tool SQL *PLUS is not connected to the server or was disconnected because of server restart or network disconnect.















  



                       
  










Member Avatar










11 Years Ago






I was having the same problem but i sorted it out by doing the following:

1. Run SQL Command Line

2. Type Connect

3. Enter Username

4. Enter Pasword



Then you should get a message that the you are connected at this point you can access the database table. Thanks





  



                       
  




















Member Avatar










10 Years Ago






thanx Macebooks..

I was here for the same problem and solved it.

Thanks a lottttt.:)





  



                       
  




















Member Avatar










9 Years Ago






hi

my sqlplus get connection with user ‘SYS’,

but when i want to connect it with scott/tiger ,

it gives the message ‘the account is lock’,

when i unlock it it gives the error : sp2-0640: not connected





  



                       
  




















Member Avatar





  



                       
  

















Reply to this topic






Be a part of the DaniWeb community






  



                       
  







We’re a friendly, industry-focused community of developers, IT pros, digital marketers,

and technology enthusiasts meeting, networking, learning, and sharing knowledge.









Источник







  



                       
  













	







	
	
		

		
Добавить комментарий