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.