service-name

How can I change the SID of an Oracle XE instance.

I needed to change the SID of an Oracle XE database (not the Service Name) to match a production database. When I tried searching online, most of the pages were describing changing or adding a service name through tnsnames.ora; that's not what I needed to do. ...

Oracle database connections - what are all the fields I need to fill in?

I'm used to using SQL Server and I'm now faced with connecting to Oracle. Can I get some completely unambiguous descriptions for what all the fields I need to fill in are? Specifically, I want to understand what these are: Home Hostname Port SID Service name Network Alias Connect identifier My basic understanding is that hostname ...