Oracle Installation Experience

These days to install an Oracle database, work needs, start, to the official website to download a latest version of, now is July 30, 2015, ah, the latest is 12g that version, installed a long time not installed on, finally gave up, installed a 11g.

OK, after loading the SQL plus connection test, using the system of this account, login success, then want to use a high-end tool, Sqldeveloper, this link has a problem.

First thing to say is that Oracle comes with the sqldeveloper seems to have a problem, say what few shortcuts, I did not control it, download a problem on the internet to solve.

Then start testing the connection, or use the system this account, but he will explode all kinds of errors, what did not listen, Sid wrong, below I began to say.

Don't listen to this you can solve this, first check the state of listening, not open monitoring to open the monitoring, below I listed the instructions, referring to http://blog.sina.com.cn/s/blog_70bcd7c10101ckvw.html this big brother:

1. Check the Listener status

c:\users\administrator>lsnrctl Status2. Start the Listener
c:\users\administrator>lsnrctl Start3. Start an Oracle service instancec:\users\administrator>net start ORACLESERVICEORCL--oracleservice+ DB instance name

4. Turn off Oracle Service instances

C:\users\administrator>net Stop ORACLESERVICEORCL

5. Turn off monitoring

C:\users\administrator>lsnrctl stop

After saying SID this thing ah, sid view Windows and Linux is like this, open the SQL plus connection into the database, then enter select instance_name from v$instance; This command will be able to view the SID. Note that the L and 1 in the inside must distinguish. I'm referring to this guy http://blog.sina.com.cn/s/blog_6d39ac7e01017xg0.html.

There is a wrong place please understand that I use the sqldeveloper can be downloaded in my csdn, the address is:

2015.7.30 16:54

Oracle Service Name Lookup method:

Under the Oracle installation path \product\11.2.0\dbhome_1\network\admin A file called Tnsnames.ora, open with Notepad, there will be

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = XXX)
)
)

XXX is the service Name

Gzf

qq:212966054

Oracle Installation Experience