Home » RDBMS Server » Server Administration » Cant install SQLT - user cant log in (RHEL 6 RDBMS 11.2.0.2 and SQLT)
Cant install SQLT - user cant log in [message #537965] Tue, 03 January 2012 03:58 Go to next message
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 #537971 is a reply to message #537965] Tue, 03 January 2012 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is neither the SID or SERVICE_NAME it is the connect identifier as mentioned in Oracle Net, that is tnsnames.ora.

Regards
Michel
Re: Cant install SQLT - user cant log in [message #537977 is a reply to message #537971] Tue, 03 January 2012 04:35 Go to previous messageGo to next message
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 #537980 is a reply to message #537977] Tue, 03 January 2012 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to connect with SQL*Plus with the same connection string and post the result.
Do you realize that nothing in your posts allows us to know what error you got?

Regards
Michel

[Updated on: Tue, 03 January 2012 04:40]

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 Go to previous messageGo to next message
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

Re: Cant install SQLT - user cant log in [message #537985 is a reply to message #537982] Tue, 03 January 2012 05:01 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-20001: SQLTXPLAIN is not allowed to login using sqlplus@server02 (TNS
V1-V3)

Search for a logon trigger.

Regards
Michel
Previous Topic: v$session (2 Merged)
Next Topic: Ora-01030 Insufficent previlage
Goto Forum:
  


Current Time: Thu Mar 28 06:06:47 CDT 2024