<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
		<id>http://mediawiki.oblteh/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5</id>
		<title>Обновление БД Oracle в ограниченном режиме - История изменений</title>
		<link rel="self" type="application/atom+xml" href="http://mediawiki.oblteh/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5"/>
		<link rel="alternate" type="text/html" href="http://mediawiki.oblteh/mediawiki/index.php?title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5&amp;action=history"/>
		<updated>2026-05-01T10:05:34Z</updated>
		<subtitle>История изменений этой страницы в вики</subtitle>
		<generator>MediaWiki 1.29.1</generator>

	<entry>
		<id>http://mediawiki.oblteh/mediawiki/index.php?title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5&amp;diff=143&amp;oldid=prev</id>
		<title>Admin в 08:34, 13 декабря 2012</title>
		<link rel="alternate" type="text/html" href="http://mediawiki.oblteh/mediawiki/index.php?title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5&amp;diff=143&amp;oldid=prev"/>
				<updated>2012-12-13T08:34:19Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
				&lt;tr style='vertical-align: top;' lang='ru'&gt;
				&lt;td colspan='2' style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Предыдущая&lt;/td&gt;
				&lt;td colspan='2' style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Версия 08:34, 13 декабря 2012&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l5&quot; &gt;Строка 5:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Строка 5:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; set oracle_sid=ER&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; set oracle_sid=ER&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; set path=%oracle_home%\bin;%path%&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; set path=%oracle_home%\bin;%path%&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; sqlplus / as sysdba&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160; sqlplus / as sysdba&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://mediawiki.oblteh/mediawiki/index.php?title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5&amp;diff=142&amp;oldid=prev</id>
		<title>Admin: Новая страница: «1. проверить что sqlnet.ora прописано  SQLNET.AUTHENTICATION_SERVICES = (NTS) 2.  Готовим bat-файл  set oracle_home=C:\oracle\prod...»</title>
		<link rel="alternate" type="text/html" href="http://mediawiki.oblteh/mediawiki/index.php?title=%D0%9E%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%91%D0%94_Oracle_%D0%B2_%D0%BE%D0%B3%D1%80%D0%B0%D0%BD%D0%B8%D1%87%D0%B5%D0%BD%D0%BD%D0%BE%D0%BC_%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5&amp;diff=142&amp;oldid=prev"/>
				<updated>2012-12-13T08:34:00Z</updated>
		
		<summary type="html">&lt;p&gt;Новая страница: «1. проверить что sqlnet.ora прописано  SQLNET.AUTHENTICATION_SERVICES = (NTS) 2.  Готовим bat-файл  set oracle_home=C:\oracle\prod...»&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;1. проверить что sqlnet.ora прописано&lt;br /&gt;
 SQLNET.AUTHENTICATION_SERVICES = (NTS)&lt;br /&gt;
2.  Готовим bat-файл&lt;br /&gt;
 set oracle_home=C:\oracle\product\10.2.0\db_1&lt;br /&gt;
 set oracle_sid=ER&lt;br /&gt;
 set path=%oracle_home%\bin;%path%&lt;br /&gt;
&lt;br /&gt;
 sqlplus / as sysdba&lt;br /&gt;
&lt;br /&gt;
3. Выполняем&lt;br /&gt;
&lt;br /&gt;
shutdown&lt;br /&gt;
&lt;br /&gt;
4.&lt;br /&gt;
&lt;br /&gt;
 startup restrict&lt;br /&gt;
&lt;br /&gt;
5. Выполняем нужные обновления&lt;br /&gt;
&lt;br /&gt;
6. &lt;br /&gt;
&lt;br /&gt;
 ALTER SYSTEM DISABLE RESTRICTED SESSION;&lt;br /&gt;
&lt;br /&gt;
[[Категория:Oracle]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	</feed>