Can't connect to Oracle service

axnst2
axnst2 used Ask the Experts™
on
Hi Experts,

      First off, I am brand new to Oracle so i am guessing I did soemthing I wasn't supposed to!  Oooops...  

      So I was going to create a table space using SQL*Plus using the same name as one of my existing tablespaces.  I didn't want to delete the old one so I was going to rename the file (MyTableSpace.dbf) using Windows Explorer.  It wouldn't let me due to "file is being used by another application".  So I figured that the server must still be accessing it so smart me I stopped the services OracleServiceXE, then changed the name of the file to MyTableSpace_Backup.dbf.  Then i restarted the service and tried to log in connect using both SQL*Plus and Oracle SQL Developer and I get the below errors:

SQL*Plus Error
and

SQL Developer Error
I tried naming the file back to the original name and restarting my PC but I am still getting the error...  How do I fix this?  I tried looking online, but apperantly a lot of things can cause this.  I tried 3-4 different things I found but none of them are a fix...

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
As you can tell, you cannot rename a file like that...

Stop the Oracle service (the one with your database name in it).  Make sure the fil is the original name.

Try to start the service.

from sqlplus:
conn / as sysdba
shutdown immediate;
startup;

Post any errors.
axnst2IT Manager

Author

Commented:
Changing the file name back and restarting my PC one more time fixed the issue...  Thanks!
axnst2IT Manager

Author

Commented:
Thanks!
Geert GOracle dba
Top Expert 2009

Commented:
1 distinction.

you renamed a datafile filename, not a tablespace
a tablespace is a container for files... (1 or multiple)

sample
tablespace A
  datafile c:\oracle\data\A1.dbf
  datafile c:\oracle\data\A2.dbf

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial