| Cant install SQLT - user cant log in [message #537965] |
Tue, 03 January 2012 03:58  |
hristo
Messages: 258
Registered: May 2007
|
Senior Member |
|
|
Hi,
From metalink: Note 215187.1
Im trying to install SQLT. The installation process ask for:
Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key
I have tried with SID (@TESTDB) and SERVICE NAME (@TESTDB.mydomain.local) and leaving it blank, nothing works. I cant connect as SQLTXPLAIN
Any ideas?
Regards
Hristo
[Updated on: Tue, 03 January 2012 04:09] Report message to a moderator |
|
|
|
|
|
| Re: Cant install SQLT - user cant log in [message #537977 is a reply to message #537971] |
Tue, 03 January 2012 04:35  |
hristo
Messages: 258
Registered: May 2007
|
Senior Member |
|
|
Hi,
The tnsnames looks like this:
TESTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mydomain.local)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TESTDB)
(SERVICE_NAME = TESTDB)
(SERVICE_NAME = TESTDB.lindex.local)
)
)
I have tried all of them, none of them seems to work.
[Updated on: Tue, 03 January 2012 04:41] Report message to a moderator |
|
|
|
|
|
| Re: Cant install SQLT - user cant log in [message #537982 is a reply to message #537980] |
Tue, 03 January 2012 04:47 |
hristo
Messages: 258
Registered: May 2007
|
Senior Member |
|
|
sqlplus system/pwd@TESTDB
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jan 3 11:42:39 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
The problem is that the user SQLTXPLAIN is not allowed (for some reason) to log in and create its own objects.
From one of the log files:
SQCUSR completed. Some errors are expected.
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: SQLTXPLAIN is not allowed to login using sqlplus@server02 (TNS
V1-V3)
ORA-06512: at line 60
And I also get this:
... creating package specs for SQLT$A
SP2-0640: Not connected
SP2-0641: "SHOW ERRORS" requires connection to server
...
[Updated on: Tue, 03 January 2012 04:52] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
