An error was encountered performing the requested operation oracle

heyI am new to oracle database.i am using 11g DB and i am using it in my local PC. i have used the data base many time before with SID -orcl ,hostname-localhost, port-1521.but today when i open it , i...

hey

I am new to oracle database.

i am using 11g DB and i am using it in my local PC. i have used the data base many time before with SID -orcl ,hostname-localhost, port-1521.

but today when i open it , it is showing this error.

An error was encountered performing the requested operation:

Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Vendor code 12505

tnsname.ora    ——-

# tnsnames.ora Network Configuration File: E:appMandyproduct11.2.0dbhome_1networkadmintnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl.168.0.6)

    )

  )

listener.ora ——-

# listener.ora Network Configuration File: E:appMandyproduct11.2.0dbhome_1networkadminlistener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = E:appMandyproduct11.2.0dbhome_1)

      (PROGRAM = extproc)

      (ENVS = «EXTPROC_DLLS=ONLY:E:appMandyproduct11.2.0dbhome_1binoraclr11.dll»)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = E:appMandy

please guide me with the solution.

Источник

Содержание

  1. SQL Developer Cannot Connect To Database Fails With Vendor code 17002 (Doc ID 1324766.1)
  2. Applies to:
  3. Symptoms
  4. Changes
  5. Cause
  6. To view full details, sign in with your My Oracle Support account.
  7. Don’t have a My Oracle Support account? Click to get started!
  8. An error was encountered performing the requested operation: Listener refused the connection with t
  9. Best Answer
  10. Answers
  11. An error was encountered performing the requested operation: Listener refused the connection with t
  12. Answers
  13. ORA-01034 — Oracle not availabe
  14. Best Answer
  15. Answers

SQL Developer Cannot Connect To Database Fails With Vendor code 17002 (Doc ID 1324766.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Symptoms

In the process of rolling out banners for SEC_USER_UNAUTHORIZED_ACCESS_BANNER and SEC_USER_AUDIT_ACTION_BANNER.

Testing applications to see if there was any effect on connectivity, and noticed unable to connect to the database using SQL Developer (3.0.04). SQL Developer throws error:

Error
———
An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Works
————
Using SQL Developer 2.1 connects without any errors
SQL Plus can connect to the database without any issues, as can TOAD
SQL Developer can connect to the database without issues if we remove the banner files.

Does Not Work
—————
Using SQL Developer 3.0 and banner files.

Changes

Upgraded from SQL Developer 2.1 to 3.0.

Cause

To view full details, sign in with your My Oracle Support account.

Don’t have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use

Источник

An error was encountered performing the requested operation: Listener refused the connection with t

I am new to oracle database.

i am using 11g DB and i am using it in my local PC. i have used the data base many time before with SID -orcl ,hostname-localhost, port-1521.

but today when i open it , it is showing this error.

An error was encountered performing the requested operation:

Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Vendor code 12505

# tnsnames.ora Network Configuration File: E:appMandyproduct11.2.0dbhome_1networkadmintnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.168.0.6)

# listener.ora Network Configuration File: E:appMandyproduct11.2.0dbhome_1networkadminlistener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = E:appMandyproduct11.2.0dbhome_1)

(PROGRAM = extproc)

(ENVS = «EXTPROC_DLLS=ONLY:E:appMandyproduct11.2.0dbhome_1binoraclr11.dll»)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ADR_BASE_LISTENER = E:appMandy

please guide me with the solution.

Best Answer

Is the database open and registered with the listener? It sounds like the DB is local, so try from a command prompt via copy and paste:

sqlplus / as sysdba

Copy and paste the output here. If it all worked fine then you should then be able to connect over the listener using your prior method.

Answers

Is the database open and registered with the listener? It sounds like the DB is local, so try from a command prompt via copy and paste:

sqlplus / as sysdba

Copy and paste the output here. If it all worked fine then you should then be able to connect over the listener using your prior method.

First, is the database running (so do you have a running instance)? If the database is not running the Service is not registered within the listener and therefore «unknown».

Second, is the «orcl.168.0.6» in the tnsnames.ora really the service name or shouldn’t it be «orcl» only?

Third, if you still can’t connect, can you please post the output of «lsnrctl status listener» here?

And last, but not least, you could change the registration of the database to the listener to use a «STATIC» registration. You need to add the database to the SID_LIST_LISTENER entry. Examples can be found a lot at google.

should my listener file need to contain something like SID_NAME = ORCL ?

because i was previously using orcl as SID name for connection.

output:

C:UsersDell>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 27 02:26:07 2018

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

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 — 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-01081: cannot start already-running ORACLE — shut it down first

mandeepmandy, to go with Joerg’s suggestions also make sure your OS environment variables were set correctly. Your ORCL post does not show a sid as it specifies the service name only. You can try adding (SID = ORCL) to the entry. Posting the actual connection attempt would have been helpful.

HTH — Mark D Powell —

Ok, the database is running, what are about the steps 2 to 4 of my first post? Can you try them also?

post the results of the OS commands below

12505, 00000, «TNS:listener does not currently know of SID given in connect descriptor»

// *Cause: The listener received a request to establish a connection to a

// database or other service. The connect descriptor received by the listener

// specified a SID for an instance (usually a database instance) that either

// has not yet dynamically registered with the listener or has not been

// statically configured for the listener. This may be a temporary condition

// such as after the listener has started, but before the database instance

// has registered with the listener.

// — Wait a moment and try to connect a second time.

// — Check which instances are currently known by the listener by executing:

// — Check that the SID parameter in the connect descriptor specifies

Источник

An error was encountered performing the requested operation: Listener refused the connection with t

From sql developer I am trying to connect to database in my local machine. It shows the following below error. Any suggestions?

An error was encountered performing the requested operation:

Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Vendor code 12505

Answers

post results from OS commands below

post excerpt from listener.log file which contains same error code

lsnrctl results are as shown below

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 — Production on 18-AUG-2013 17:40

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 — Produ

Start Date 18-AUG-2013 15:29:41

Uptime 0 days 2 hr. 10 min. 50 sec

Trace Level off

Security ON: Local OS Authentication

Listener Parameter File C:appndodd_000product11.2.0dbhome_1networkadmin

Listener Log File c:appndodd_000diagtnslsnrVamsilisteneralertlog

Listening Endpoints Summary.

Service «CLRExtProc» has 1 instance(s).

Instance «CLRExtProc», status UNKNOWN, has 1 handler(s) for this service.

Service «sysdba» has 1 instance(s).

Instance «sysdba», status READY, has 1 handler(s) for this service.

Service «sysdbaXDB» has 1 instance(s).

Instance «sysdba», status READY, has 1 handler(s) for this service.

The command completed successfully

lsnrctl service results

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 — Production on 18-AUG-2013 17:

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

Service «CLRExtProc» has 1 instance(s).

Instance «CLRExtProc», status UNKNOWN, has 1 handler(s) for this service.

«DEDICATED» established:0 refused:0

Service «sysdba» has 1 instance(s).

Instance «sysdba», status READY, has 1 handler(s) for this service.

«DEDICATED» established:186 refused:0 state:ready

Service «sysdbaXDB» has 1 instance(s).

Instance «sysdba», status READY, has 1 handler(s) for this service.

«D000» established:0 refused:0 current:0 max:1022 state:ready

Источник

ORA-01034 — Oracle not availabe

Hello all,
The database was working fine (11g) but 2 days ago suddenly I got this error:
An error was encountered performing the requested operation:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
01034. 00000 — «ORACLE not available»
*Cause: Oracle was not started up. Possible causes include the following
— The SGA requires more space than was allocated for it.
— The operating-system variable pointing to the instance is
improperly defined.
*Action: Refer to accompanying messages for possible causes and correct
the problem mentioned in the other messages.
If Oracle has been initialized, then on some operating systems,
verify that Oracle was linked correctly. See the platform
specific Oracle documentation.
Vendor code 1034

Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup

but it did not worked either.

Please guide me how this problem can be solved.

Thank you so much

Best Answer

I finally fixed it. Thanks for your help my friends

Answers

>
Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup

but it did not worked either.

Please guide me how this problem can be solved.
>
First — STOP MAKING CHANGES.

If you are ‘not familiar with the oracle very much’ you should NOT be making changes to Oracle or performing shutdowns or startups. Those operations should ONLY be performed by someone that IS familiar with Oracle and knows what will actually happen when you do those operations. Not only what will happen when you do the ops properly but, more importantly, what might happen if you do them improperly.

Saying you shutdown the server has NO meaning. Post the exact command you used to do the shutdown and what account you were connected as when you ran it.

Also any information in the alert log from just before to just after you shutdown the database.

Do NOT make any more changes until you know what changes to make and what the result might be if you make them wrong.

1004201 wrote:
Hello all,
The database was working fine (11g) but 2 days ago suddenly I got this error:
An error was encountered performing the requested operation:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
01034. 00000 — «ORACLE not available»
*Cause: Oracle was not started up. Possible causes include the following
— The SGA requires more space than was allocated for it.
— The operating-system variable pointing to the instance is
improperly defined.
*Action: Refer to accompanying messages for possible causes and correct
the problem mentioned in the other messages.
If Oracle has been initialized, then on some operating systems,
verify that Oracle was linked correctly. See the platform
specific Oracle documentation.
Vendor code 1034

Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup

but it did not worked either.

Please guide me how this problem can be solved.

Thank you so much

if you have sys password try like as below.

Unix :
$export ORACLE_SID=GRMS
$sqlplus sys/[email protected] as sysdba
SQL> startup

Window :
C:> set ORACLE_SID=GRMS
C:> sqlplus sys/[email protected] as sysdba
C:> startup

Источник

Источник

I encountered same problem with ORACLE 11G express on Windows.
After a long time waiting I got the same error message.

My solution is to make sure the hostname in tnsnames.ora (usually it’s not «localhost») and the default hostname in sql developer(usually it’s «localhost») same. You can either do this by changing it in the tnsnames.ora, or filling up the same in the sql developer.

Oh, of course you need to reboot all the oracle services (just to be safe).

Hope it helps.

I came across the similar problem again on another machine, but this time above solution doesn’t work.
After some trying, I found restarting all the oracle related services can fix the problem. Originally when the installation is done, connection can be made. Somehow after several reboot of computer, there is problem.
I change all the oracle services with start time as auto. And once I could not connect, I restart them all over again (the core service should be restarted at last order), and works fine.

Some article says it might be due to the MTS problem. Microsoft’s problem. Maybe!

Источник

Я пытаюсь подключиться к базе данных с помощью SQLDeveloper, и я получаю следующую ошибку:

An Error was Encountered performing The requested operation:

IO Error: Conection reset

Vendor code 17002.

Не могли бы вы помочь мне?

4b9b3361

Ответ 1

Ниже перечислены шаги, которые могут исправить ошибку:

  • Нажмите Windows + R
  • Введите services.msc и нажмите Enter
  • Найти все службы
  • Начиная с ora запустите эти службы и подождите!!
  • Когда инициализируется служба вашего сервера (в моем случае это было orcl)
  • Теперь запустите mysql или что вы используете и запустите coding.P

Ответ 2

Я столкнулся с той же проблемой с ORACLE 11G express в Windows.
После долгого ожидания я получил то же сообщение об ошибке.

Мое решение заключается в убедиться, что имя хоста в tnsnames.ora(обычно это не «localhost» ) и имя хоста по умолчанию в sql-разработчике (обычно это «localhost» ) одинаково. Вы можете либо сделать это, изменив его в tnsnames.ora, либо заполнив то же самое в разработчике sql.

О, конечно, вам нужно перезагрузить все службы оракула (просто чтобы быть в безопасности).

Надеюсь, что это поможет.

Я снова столкнулся с подобной проблемой на другой машине, но на этот раз выше решение не работает.
После некоторых попыток я обнаружил, что перезапуск всех связанных с oracle сервисов может решить проблему. Первоначально, когда установка завершена, соединение может быть выполнено. Как-то после нескольких перезагрузок компьютера возникает проблема.
Я меняю все службы оракула с временем начала, как авто. И как только я не смог подключиться, я перезапускаю их снова и снова (основная служба должна быть перезапущена в последнем порядке) и работает нормально.

В какой-то статье говорится, что это может быть связано с проблемой MTS. Проблема с Microsoft. Может быть!

Ответ 3

У меня была та же проблема. Я начал использовать свой слуховой аппарат Oracle TNS, затем он работает нормально снова.

См. LISTENER: TNS-12545… Нет такого файла или каталога.

Ответ 4

В вашем случае «Код 17002 поставщика» является эквивалентом ошибки ORA-12541: скорее всего, ваш слушатель выключен или имеет неправильный порт или имя службы. Из документов:

ORA-12541: TNS no listener

Причина. Слушатель исходного репозитория не запущен.

Действие: Запустите прослушиватель на компьютере, на котором находится исходный репозиторий.

Источник

I am newbie to ORCALE

I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help

An error was encountered performing the requested operation:

Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


Vendor code 12505

this is my listener.ora file

SID_LIST_LISTNITBSCAT =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ITBSCAT)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = ITBSCAT)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DB-ORACLE-11G-RHEL6)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

LISTNITBSCAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DB-ORACLE-11G-RHEL6)(PORT = 1522))
  )

ADR_BASE_LISTNITBSCAT = /u01/app/oracle

This is my tnsnames.ora file which is my env

(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DB-ORACLE-11G-RHEL6)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ITBSCAT)
    )
  )

DMSORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ARCHDBGG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.5.16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = archdb)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DB-ORACLE-11G-RHEL6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Listener status:

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                11-OCT-2018 18:26:36
Uptime                    0 days 2 hr. 8 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/DB-ORACLE-11G-RHEL6/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB-ORACLE-11G-RHEL6)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@DB-ORACLE-11G-RHEL6 admin]$

TNSPING ORCL

[oracle@DB-ORACLE-11G-RHEL6 admin]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on
11-OCT-2018 21:32:30

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
DB-ORACLE-11G-RHEL6)(PORT = 1521))) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = orcl))) OK (0 msec)
[oracle@DB-ORACLE-11G-RHEL6 admin]$

Источник

Данные для считывания из сокета отсутствуют

Была установлена СУБД Oracle на сервер, с ошибками (как полагается). Подробнее в Установка СУБД Oracle на Windows.

Далее при подключении к БД возникла ошибка:
An error was encountered performing the requested operation:
Данные для считывания из сокета отсутствуют
Vendor code 17410

Решение:
1. Проверить создана ли БД. Если нет создать в конфигураторе баз. В случае с SYS/SYSTEM была такая ситуация.

2. 99% вероятность ошибки в том, что неправильно сконфигурированы listener.ora и tnsnames.ora.
Поэтому, лучше всего, проверить и, если ничего не помогает, пересоздать их с помощью конфигуратора (Net Configuration Assistant) и Net Manager.

Популярные сообщения из этого блога

КБК. КВФО — Код вида финансового обеспечения (деятельности)

НПА:  Приказ Минфина России от 01.12.2010 N 157н Письмо Минфина России от 18 января 2018 г. N 02-06-10/2715 В целях организации и ведения бухгалтерского учета, утверждения Рабочего плана счетов применяются следующие коды вида финансового обеспечения (деятельности): для государственных (муниципальных) учреждений, организаций, осуществляющих полномочия получателя бюджетных средств, финансовых органов соответствующих бюджетов и органов, осуществляющих их кассовое обслуживание: 1 — деятельность, осуществляемая за счет средств соответствующего бюджета бюджетной системы Российской Федерации (бюджетная деятельность); 2 — приносящая доход деятельность (собственные доходы учреждения); 3 — средства во временном распоряжении; 4 — субсидии на выполнение государственного (муниципального) задания; 5 — субсидии на иные цели; 6 — субсидии на цели осуществления капитальных вложений; 7 — средства по обязательному медицинскому страхованию; для отражения органами Федерального казн

TRUNCATE / DELETE / DROP или как очистить таблицу

ИМЕЕМ: Таблица MSG (сообщения) с большим количеством записей. SQL> CREATE TABLE msg (id INTEGER NOT NULL PRIMARY KEY,                               description CHAR (50) NOT NULL,                            date_create DATE); ЗАДАЧА: Необходимо очистить таблицу от данных РЕШЕНИЕ: Для решения данной задачи есть несколько способов. Ниже описание и пример каждого из них. Способ №1 — используем DELETE  Самый простой способ (первый вариант) — выполнение оператора удаления записи. При его выполнении вы будете видеть результат (сколько записей удалено). Удобная штука когда необходимо точно знать и понимать правильные ли данные удалены. НО имеет недостатки перед другими вариантами решения поставленной задачи. SQL>  DELETE FROM msg; —Удалит все строки в таблице SQL>  DELETE FROM msg WHERE date_create = ‘2019.02.01’; —Удалит все строки у которых дата создания «2019.02.01»  Способ №2 — используем TRUNCATE  Использование оператора DML для очистки всех строк в та

Linux (РедОС). Сброс пароля

Изображение

Используется ОС РедОС 7.1, которая установлена в VBox. В процессе установки ОС, был задан только пароль для «root», дополнительных пользователей не создавалось. В  рекомендациях на сайте производителя ОС  указано: Помимо администратора РЕД ОС (root) в систему необходимо добавить, по меньшей мере, одного обычного пользователя. Работа от имени администратора РЕД ОС считается опасной (можно по неосторожности повредить систему), поэтому повседневную работу в РЕД ОС следует выполнять от имени обычного пользователя, полномочия которого ограничены. После перезапуска и попытке войти в систему под root, система выдает сообщение «Не сработало .попробуйте еще раз». Поэтому для решения проблемы было решено создать пользователя, для этого выполняем такие действия: После загрузки, в момент выбора системы, быстро нажимаем стрелки вверх и вниз (приостанавливаем обратный отсчет). Выбираем ядро и нажимаем «e». Находим строку, которая относится к ядру: здесь будет ряд «boot parameter

ТФФ 34.0. Полный перечень документов альбома ТФФ (Таблица 2)

  Для удобства и поиска информации по томам, маркерам и обозначении версии ТФФ. Таблица  актуальна  —  версия 34.0  — (дата начала действия с 01.01.2023 г.) Ссылки на предыдущие версии форматов: ТФФ 33.0 —  https://albafoxx.blogspot.com/2021/01/320-2.html ТФФ 32.0 —  https://albafoxx.blogspot.com/2020/01/310-2.html ТФФ 31.0 —  https://albafoxx.blogspot.com/2020/01/310-2.html ТФФ 30.0 —  https://albafoxx.blogspot.com/2019/12/300-2.html ТФФ 29.0 —  https://albafoxx.blogspot.com/2019/05/290-2.html ТФФ 28.0 —  https://albafoxx.blogspot.com/2019/04/2.html Наименование документа (справочника) Маркер Номер версии ТФО документа № тома Казначейское уведомление SU TXSU190101 2 Расходное расписание, Реестр расходных расписаний AP TXAP190101 1 Перечень целевых субсидий TL TXTL170101 1 Уведомление (протокол), Ин

SQL Error [53200]: ОШИБКА: нехватка разделяемой памяти Подсказка: Возможно, следует увеличить параметр max_locks_per_transaction

При выполнении запросов на БД (Postgres) возникла ошибка: 24.02.21 13:50:38.219,main,ERROR,ExecSql,null com.bssys.db.jdbc.DBSQLException: ОШИБКА: нехватка разделяемой памяти Подсказка: Возможно, следует увеличить параметр max_locks_per_transaction. Подробная информация по параметру здесь . Коротко ниже: max_locks_per_transaction (integer) Этот параметр управляет средним числом блокировок объектов, выделяемым для каждой транзакции; отдельные транзакции могут заблокировать и больше объектов, если все они умещаются в таблице блокировок. Значение по умолчанию = 64 рядом также находится параметр  max_pred_locks_per_transaction (integer) В файле  postgresql.conf (Postgres/data/) указано так: #———————————————————————- # LOCK MANAGEMENT #———————————————————————- #deadlock_timeout = 1s # max_locks_per_transaction = 64 # min 10 # (change requires restart) # max_pred_locks_per_transaction = 64

Источник

Summary: in this tutorial, you will learn how to fix the ORACLE initialization or shutdown in progress error when you connect to the Oracle Database.

Sometimes, you may encounter the following error when you connect to an Oracle pluggable database in Oracle Database 12c:

An error was encountered performing the requested operation:

ORA-01033: ORACLE initialization or shutdown in progress
01033. 00000 - "ORACLE initialization or shutdown in progress"
*Cause: An attempt was made to log on while Oracle is being started up
or shutdown.
*Action: Wait a few minutes. Then retry the operation.
Vendor code 1033
Code language: SQL (Structured Query Language) (sql)

To fix this issue, you use the follwing steps:

First, launch the SQL*Plus program and login to the database instance as a SYSDBA user:

Enter user-name: ot@pdborcl as sysdba
Enter password: <password>

Code language: SQL (Structured Query Language) (sql)

This statement connected to the PDBORCL database using the OT user.

Second, issue the following statement to check the status of the current instance:

SQL> select status, database_status from v$instance;

STATUS       DATABASE_STATUS
------------ -----------------
MOUNTED      ACTIVE
Code language: SQL (Structured Query Language) (sql)

The output showed that the instance status is mounted.

Third, change the state of the Oracle Database instance to OPEN:

SQL> alter database open;

Database altered.
Code language: SQL (Structured Query Language) (sql)

For more information on the Oracle Database stages, check it out the Startup Oracle Database instance tutorial.

Finally, double check the database status by using the following statement:

select status, database_status from v$instance;

STATUS       DATABASE_STATUS
------------ -----------------
OPEN         ACTIVE
Code language: SQL (Structured Query Language) (sql)

The instance status is open and available to all users for normal operations.

Now, you should be able to connect to the OT pluggable database without any issue.

Was this tutorial helpful?

Источник

This article is intended to help with troubleshooting SQL Developer connection
problems. It won’t tell you how to set up a connection because that is already well covered
online help (Start with the Getting Started topic and follow the link from there.)

The article is limited to the SQL Developer BASIC connection type. That is a simple
JDBC type 4 connection with no additional authentication or
security options, and no additional oracle client software.

What is a connection?

When you connect to an oracle instance using SQL Developer, you are
making a TCP/IP connection to a specific
host, on a specific port, and to a named instance
or service. These are the parameters you supply when creating a
basic connection in SQLDeveloper.

  • host

    This can be a hostname or an IP address. If you use a hostname, including localhost, your workstation must be able to resolve it to an IP address.

  • port

    This is the TCP port on the host which is listening for oracle connections. It is usually 1521, but not always.

  • SID

    This the instance name of the database

  • service

    This is the service name under which the database is available.
    It is often the same as the SID, but may not be.

These details should be available from your DBA, or from when you created a database.

In the remainder of this article there is an assumption that you have
the correct details. There is always the possibility that you have the
wrong information or have mistyped something. If a test fails, re-check
your information before investigating other causes.

The database host and your workstation may be the same machine —
you may have SQL Developer installed on the database host,
or you may have an oracle database installed on your PC —
but you still need a TCP/IP connection. In this article I will use the
terms host and workstation to distinguish the two.

Connection Errors

This is not a comprehensive list of oracle errors, or even all errors relevant to SQL Developer connections.

See the Oracle Error messages reference manaual
for all error messages.

  1. Client Side Errors

    These are errors caused by issues on the workstation,
    or somewhere between the workstation and the host. If you get either of these errors, follow the troubleshooting tips at Basic Network Connectivity Below

    • Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
    • An error was encountered performing the requested operation:

      IO Error: The Network Adapter could not establish the connection

      Vendor code 17002

  2. Host side errors

    These are errors caused by issues on the host such as the
    database service not running.
    In each case you will need to contact the team responsible for the host.

    • Status : Failure -Test failed: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor.

      This means that the service you have specified is not running.

    • Status : Failure -Test failed: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

      This means that the SID you have specified is not running.

    • Status : Failure -Test failed: IO Error: Got minus one from a read call

      This is a non-specific error, but I have seen it when the remote database is shutting down.

    • Status : Failure -Test failed: Listener refused the connection with the following error:
      ORA-12528, TNS:listener: all appropriate instances are blocking new connections

      This can mean that either the database is still starting up, or that the database is
      overloaded (too many connections.)

    • Status : Failure -Test failed: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory

      This means that the database is down.

    • Status : Failure -Test failed: ORA-01033: ORACLE initialization or shutdown in progress

      This means that the database is in the process of starting or stopping.

  3. Other errors

    These are not SQL Developer specific connection errors, but may mean you can’t connect.

    • Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied

      This is self-explanatory. Either your username or password is wrong.

    • An error was encountered performing the requested operation:

      ORA-28000: the account is locked
      28000. 00000 — «the account is locked»
      *Cause: The user has entered wrong password consequently for maximum
      number of times specified by the user’s profile parameter
      FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
      *Action: Wait for PASSWORD_LOCK_TIME or contact DBA
      Vendor code 28000

      The account you are using is locked. You will need to contact your security administrator or DBA.

Basic Network Connectivity

These tests use a windows command window and windows tools. Tools on other platforms may produce different responses.

  1. Can you ping the host? 
    Q:tests>ping mercure
Ping request could not find host mercure. Please check the name and try again.

    This indicates that the host «mercure» isn’t known to your workstation. Typically this means that there is no DNS entry, or no HOSTS file entry.

    Q:tests>ping hermes


Pinging hermes.ponder-stibbons.local [192.168.1.18] with 32 bytes of data:

Request timed out.
Request timed out.
Request timed out.
Request timed out.

Ping statistics for 192.168.1.18:
    Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),

    This indicates that the host «hermes» is known to your workstation, but the host itself is not accessible.
    The host could be down, or there could be a DNS error (i.e. wrong IP address,) or your network configuration
    means that your workstation cannot reach it.

    Q:tests>ping mercury

Pinging mercury.ponder-stibbons.local [192.168.1.5] with 32 bytes of data:

Reply from 192.168.1.5: bytes=32 time<1ms TTL=64
Reply from 192.168.1.5: bytes=32 time=5ms TTL=64
Reply from 192.168.1.5: bytes=32 time<1ms TTL=64
Reply from 192.168.1.5: bytes=32 time<1ms TTL=64

Ping statistics for 192.168.1.5:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 5ms, Average = 1ms

    This is a successful test, you can now proceed to the next stage.

  2. Can you telnet to the host on the correct port? 
    Q:tests>telnet mercury 1522
Connecting To mercury...Could not open connection to the host, on port 1522: Connect failed

    This could mean that the listener is not running, or that a firewall is blocking the port. The firewall could be
    on the database host, on your workstation or anywhere in between.

    Q:tests>telnet mercury 1521

    If you get a blank screen here, you have successfully connected. Type ctrl-] to get the telnet command line and quit.

    Welcome to Microsoft Telnet Client

Escape Character is 'CTRL+]'


Microsoft Telnet> quit

Q:tests>

    If something other than an oracle listener is using port 1521 you may still get a blank screen, or you may see a welcome message.
    This is unlikely if you have the correct host.

  3. Can other oracle clients connect? 
    $ tnsping xe

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 19-OCT-2012 10:47:47

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
D:oracleproduct11.2.0dbhome_1networkadminsqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = mercury.ponder-stibbons.local)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICAT
ED) (SERVICE_NAME = XE)))
OK (20 msec)

TODO:

  • Other connection types connections (TNS,LDAP, Advanced, Local/Bequeath)
  • Oracle client software interactions
  • diagnostic tools

Update History

Date Amendment
19 Oct 2012 Initial version
Источник

Понравилась статья? Поделить с друзьями:
  • An error prevented the install from completing red giant universe
  • An error on our end caused your launch to fail
  • An internal error occurred in rigs of rods technical details below failed to generate list
  • An internal error occurred editing functionality may be limited
  • An internal error occurred during parsing heap dump from java heap space