Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2548
  • Last Modified:

Oracle SQLPlus fails on Vista

I installed Oracle 10g Standard Edition on a new laptop with Windows Vista Premium. The Oracle DB instance and the TNSListener are started as Service automatically when Windows starts. The iSQLPlus also runs from the Browser window with no problem. But when I try SQLPlus, specifying SYSTEM/password and host string, I get an error that says ORA-12569 TNS:packet checksum failure. The oracle instance is at port 1158 (part of the host string). The sqlnet and tnsnames configuration has a different port number - 1522 - probably used by SQL Plus. The Oracle documentation only says to set the Trace Level and run it again which I did with the same results? I am not able figure out what set up needs to be changed or if it is a Vista problem.
Thanx in advance for any help.  
0
DOSLover
Asked:
DOSLover
  • 2
  • 2
1 Solution
 
TolomirAdministratorCommented:
Have you installed the vista version of oracle DB?

Oracle Database 10g Release 2 (10.2.0.3)
Enterprise/Standard Edition for Microsoft Windows Vista
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html

Also check the documentation:
http://download.oracle.com/otn/nt/oracle10g/10203_doc_vista.zip (requires login)
0
 
DOSLoverAuthor Commented:
Tolomir,
I have installed Standard Edition for Vista. I have downloaded the documentation also, not much help.
I am now using port 1521, and I get ORA 12514 TNS:Listener does not know of service requested in connect descriptor. The service is named as 'orcl'. The tnsnames.ora has an entry looks like this:
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.xxx.x.x)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )
  The Service that is started by Windows has a name of OracleServiceORCL. I did ping to the ip-address and tnsping to the service orcl. Both returned OK.
0
 
DOSLoverAuthor Commented:
I figured out what the problem is. The problem is with the Host string I specified on SQL Plus. I was specifying 192.xxx.x.x:1521 only. It worked fine when I included db instance also - 192.xxx.x.x:1521/orcl.
0
 
TolomirAdministratorCommented:
Still this is a strange error: ORA-12569 TNS:packet checksum failure.
0
 
Computer101Commented:
PAQed with points refunded (200)

Computer101
EE Admin
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now