Posts Tagged ‘oracle 10g’

TNS-12546/ORA-12546: TNS:permission denied

1, Oct 2008

After reboot in a newly installed Oracle 10g, TNS fails to start with these error: TNS-12546 / ORA-12546: TNS:permission denied TNS-12560 / ORA-12560: TNS:protocol adapter error TNS-00516: permission denied Solaris Error: 13: permission denied If you try to telnet the port 1521 and you get network is unreachable, this is clearly a permission error related [...]

Oracle 10g: Creating external tables from a text file in a windows system

29, Sep 2008

External Tables let you query data in a flat file as though the file were an Oracle table. In 10g, you can write out data to an external table, but you can’t write to an existing table. While external tables can be queried, they’re not usable in many ways regular Oracle tables are. You cannot [...]


top