473,320 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Unable to close database, get error ORA-01093

broggyr
I am trying to ALTER DATABASE CLOSE; on my learning database (not production) and I am getting the error:

"ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected"

SELECT sid,serial#,username from v$session;

SID SERIAL# USERNAME
---------- ---------- ---------------------------
135 6 SYSMAN
137 102 SYSMAN
139 1274 SYSMAN
141 17 DBSNMP
142 107 SYS
143 185 SYSMAN
147 32 DBSNMP
152 12
159 3
160 3

SID SERIAL# USERNAME
---------- ---------- ---------------------------
161 153
162 38
164 1
165 1
166 1
167 1
168 1
169 1
170 1

I have tried killing the named sessions (only a database for learning, no production impact) only to either have them reappear or not being killed in the first place.

What am I missing? How can I clear existing sessions?

Oracle 10g, 10.1.0.4.0 on Windows2003 Server

Thanks, Brian
May 17 '07 #1
4 12060
dear brain,
i too had same problem then
i connected as sys , just run sql>select * from tab, such that some session goes on!
then at sql>shutdown; worked.
goodluck
Oct 22 '07 #2
amitpatel66
2,367 Expert 2GB
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

Cause: There is at least one more session other than the current one logged into the instance. ALTER DATABASE CLOSE is not permitted.

Action: Find the other sessions and log them out and resubmit the command
Oct 22 '07 #3
debasisdas
8,127 Expert 4TB
Disconnect all other active sessions before closing the database.
Oct 22 '07 #4
Find the other sessions and disconnect them. Then retry the ALTER DATABASE CLOSE command. Also, issue the SHUTDOWN IMMEDIATE command to force users off the system, or issue the SHUTDOWN ABORT command to shut down the database without waiting for users to be forced off.
Oct 23 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Barry Young | last post by:
I am using the following code to insert a row in an Oracle Database. strConnection = "Provider=OraOLEDB.Oracle;Data Source=MYDATABASE;User Id=SYSTEM;Password=******" Dim strMessage As String ...
1
by: Park Yeon Jo | last post by:
About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I installed Oracle 8.1.7 on Windows XP Professional. and I wanto connect to that server...
1
by: valexena | last post by:
I am attempting to take tablespace offline and receiving the following error: ORA-01546- cannot take tablespace offline. What I am doing wrong? -- Posted via http://dbforums.com
3
by: Cherrish Vaidiyan | last post by:
Sir, A Warm and Smart 2004 greetings to all. I have a problem with standby database.I have been posting queries but no response ..... I am using 2 system running on Red Hat Linux9 and...
0
by: Brian Lesker | Impulse Info Systems | last post by:
Keywords: Oracle 6i Citrix ORA-06508 Crash Problem descryption: Oracle (6i) application crashes in Citrix farm with error ORA-06508. HOWTO resolve:
1
by: 3xxx | last post by:
I start to learn the form now with oracle 9i environment (this URL appear after running menu in Oracle forms builder ==>>> program-> run form) ...
3
by: Thakur vikas | last post by:
when we run the query then we got ": (Error): ORA-00907: missing right parenthesis" what may be the error?
2
by: sushil4487 | last post by:
I am getting this error while writing this query. I am using the same query in other server but i am not getting any error message Do I need to reset the date format in Server. Date is saved in...
2
by: amoldiego | last post by:
Hi I have encountered the error ORA-01536 . I have earlier grant sysdba to SCOTT & then I revoked the sysdba role from SCOTT a couple of days later. After that, I encountered the error...
1
by: gowthams123 | last post by:
Dear All, Plz help me with this oracle form builder installation? I have installed SQL *PLUS Release 9.2.0.1.0 and then installed form builder 9.0.2.7.0. When i enter the following username...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.