Link to home
Start Free TrialLog in
Avatar of axnst2
axnst2Flag for United States of America

asked on

Can't connect to Oracle service

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:

User generated image
and

User generated image
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!
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of axnst2

ASKER

Changing the file name back and restarting my PC one more time fixed the issue...  Thanks!
Avatar of axnst2

ASKER

Thanks!
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