>Are you able to connect to oracle with sqlplus?
>
># sqlplus $(spacewalk-cfg-get default_db)
>
>
>Regards,
>
>--
>Michael Mráka
>Satellite Engineering, Red Hat
Hi Michael,
I can't connect using SQL plus , I made a seperate post about it on the list,
but I can summerise here.
I currently can't connect to the spacewalk server using plsql.
[quote]
[root@spacewalk01 ~]# sqlplus spacewalk/spacewalk@//localhost/XE
SQL*Plus: Release 11.2.0.2.0 Production on Wed May 25 07:54:30 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
[/quote]
after working this through last night, the problem (and I don't know oracle
well enough to explain/understand why) is the use of the host "localhost" in
listener.ora (this line)
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
and tnsnames.ora (this line)
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
if I change localhost to my FQDN for the server (same as the servers current
hostname) restart the listener and connect, it works.
[quote]
[root@spacewalk01 ~]# sqlplus spacewalk/spacewalk@//localhost/XE
SQL*Plus: Release 11.2.0.2.0 Production on Wed May 25 07:59:06 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL>
[/quote]
this is great.
The problem is then when I try to run spacewalk-hostname-rename, those files
are changed back to localhost, and the hostname rename process fails as it does
this before trying to actually do anything with the database, so when it tries
to update the database with the new hostname, it fails to connect again.
I need to get this back to working on "localhost" but the truth is I don't
understand why this needs to be changed to the FQDN to work, so can't progress
it at this time.
advice on the best way forward would be most welcome.
thanks,
Matt
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
