Oke, pak endrue, thank's atas solusinya... On Feb 1, 2008 3:48 PM, Andrew E.K. <[EMAIL PROTECTED]> wrote:
> Pak, > > Saya kutip dari Metalink nih, semoga membantu : > > Subject: > ORA-106 or ORA-1031 Error On Startup/Shutdown Database Using Enterprise > Manager > > Doc ID: > Note:1058680.6 > Type: > PROBLEM > > Last Revision Date: > 25-OCT-2005 > Status: > ARCHIVED > > Problem Description > =================== > > You are running a multi-threaded server and are trying to shutdown your > database using Oracle Enterprise Manager. You receive the following error > message: > > > ORA-00106: cannot startup/shutdown database when connected to a dispatcher > Cause: An attempt was made to startup/shutdown database when connected > to a shared server via a dispatcher. > Action: Re-connect as user INTERNAL without going through the dispatcher. > For most cases, this can be done by connect to INTERNAL without > specifying a network connect strin > > Or > > When shutting down or starting up an instance via Oracle Enterprise > Manager > (OEM) Navigator when connected as SYSDBA or SYSOPER you receive an > > ORA-01031: insufficient privileges. > Cause: An attempt was made to change the current username or password > without the appropriate privilege. This error also occurs if > attempting to install a database without the necessary operating > system privileges. > When Trusted Oracle is configure in DBMS MAC, this error may occur > if the user was granted the necessary privilege at a higher label > than the current login. > Action: Ask the database administrator to perform the operation or grant > the required privileges. > For Trusted Oracle users getting this error although granted the > the appropriate privilege at a higher label, ask the database to > regrant the privilege at the appropriate label. > > Solution Description > ==================== > > To startup/shutdown a database, you must connect via a dedicated server > process > and not a shared process. > > Add the following entry to your tnsnames.ora file in the address_list > section: > > (SERVER=DEDICATED) > > Example: > -------- > > <service name> > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = > (PROTOCOL = <PROTOCOL>) > (Host = <server>) > (Port = <port #>) > ) > ) > (CONNECT_DATA = > (SID = <sidname>) > (SERVER=DEDICATED) > ) > ) > > Explanation > =========== > > You are trying to shutdown the database while connected to a shared server > > process. You cannot startup or shutdown a database while connected to a > shared server process via a dispatcher.Andrew > > > ----- Original Message ---- > From: Kang Oyib <[EMAIL PROTECTED] <kang.toyib%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Friday, 1 February 2008 4:35:38 > Subject: [indo-oracle] Shutdown dan up database > > Dear All, > > Saya ada masalah saat down database, error seperti dibawah ini : > > *ORA-00106: cannot startup/shutdown database when connected to a > dispatcher > > Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - > Production > > With the Partitioning option > > JServer Release 8.1.7.0.0 - Production > > *Padahal user dan password sudah benar. > > Ada yang tahu solusinya... ? > > Thank's > > Kang Toyib > > [Non-text portions of this message have been removed] > > <!-- > > #ygrp-mkp{ > border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px > 14px;} > #ygrp-mkp hr{ > border:1px solid #d8d8d8;} > #ygrp-mkp #hd{ > color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px > 0px;} > #ygrp-mkp #ads{ > margin-bottom:10px;} > #ygrp-mkp .ad{ > padding:0 0;} > #ygrp-mkp .ad a{ > color:#0000ff;text-decoration:none;} > --> > > <!-- > > #ygrp-sponsor #ygrp-lc{ > font-family:Arial;} > #ygrp-sponsor #ygrp-lc #hd{ > margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} > #ygrp-sponsor #ygrp-lc .ad{ > margin-bottom:10px;padding:0 0;} > --> > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, > sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, > sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family:Arial; > clear:both;} > #ygrp-vitnav{ > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} > #ygrp-actbar .left{ > float:left;white-space:nowrap;} > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana;font-size:77%;padding:15px 0;} > #ygrp-ft{ > font-family:verdana;font-size:77%;border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px;} > > #ygrp-vital{ > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} > #ygrp-vital ul{ > padding:0;margin:2px 0;} > #ygrp-vital ul li{ > list-style-type:none;clear:both;border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > > font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} > #ygrp-vital ul li .cat{ > font-weight:bold;} > #ygrp-vital a{ > text-decoration:none;} > > #ygrp-vital a:hover{ > text-decoration:underline;} > > #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > #ygrp-sponsor #ov{ > padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0;} > #ygrp-sponsor #ov li{ > list-style-type:square;padding:6px 0;font-size:77%;} > #ygrp-sponsor #ov li a{ > text-decoration:none;font-size:130%;} > #ygrp-sponsor #nc{ > background-color:#eee;margin-bottom:20px;padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > > font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} > #ygrp-sponsor .ad a{ > text-decoration:none;} > #ygrp-sponsor .ad a:hover{ > text-decoration:underline;} > #ygrp-sponsor .ad p{ > margin:0;} > o{font-size:0;} > .MsoNormal{ > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120%;} > blockquote{margin:0 0 0 4px;} > .replbq{margin:4;} > --> > > __________________________________________________________ > Tired of visiting multiple sites for showtimes? > Yahoo! Movies is all you need > http://sg.movies.yahoo.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
