oracle ora-12546,ORA-12546: TNS:permission denied

ORA-12546: TNS:permission denied

Cause: User has insufficient privileges to perform the requested

operation.

Action: Acquire necessary privileges and try again.

9i也有出64位元的windows版本,你如果一定要裝在

64位元的OS上,就應該裝這個版本的 oracle db

Oracle9i Release 2 (9.2.0.2)

Oracle9i Database Release 2 Enterprise/Standard/Personal/Client

Edition

for Windows XP 2003/Windows Server 2003 (64-bit)

oracle metalink

上是說64位元的OS就要裝64位元的oracle軟體,

否則create database時就會出現你那樣的error

Oracle Server -

Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1

Microsoft Windows Server 2003 (64-bit Itanium)

Symptoms

While creating Oracle Database, received following errors :

ORA-12546 TNS:permission denied

ORA-12560 TNS protocol adpater error

ORA-516 Permission denied

From SQL*Net trace :

....

nladtrm: exit

nscall: error exit

nioqper: error from nscall

nioqper: nr err code: 0

nioqper: ns main err code: 12546

nioqper: ns (2) err code: 12560

nioqper: nt main err code: 516

Cause

The errors can be caused by incompatible OS and Oracle software

versions.

Platform : Windows 200x/XP 64-bit

Product : Oracle 9.2.x.x EE 32-bit or

Oracle 10.x.x.x EE 32 bit

This configuration is not supported. Please refer to Metalink

-> Certify.

Solution

You can run Oracle 32bit, on Windows 32bit.

OR

You can run Oracle 64bit, on Windows 64bit.

You can not mix the versions.

Download the correct software

Oracle 9.2.x.x / 10.x.x.x 64-bit for Windows 64-bit

from OTN site http://otn.oracle.com.

Install the downloaded oracle software on the platform.

Then proceed to create the database.